Common commands for importing SQL scripts to Oracle databases

 Steps required to record the SQL script imported from the Oracle database

1. log on to the database with the highest system privilege, for example, DRP project ):

 
Conn system/bjpowernode;
 

2. Create a user, for example:

 
Create user test identified by test;
 

3. Create a tablespace, for example:

 
Create tablespace ts_test datafile 'e: \ test \ test_data.dbf' size 100 m;
 

4. Allocate the tablespace to the user, for example:

 
Alter user test default tablespace ts_test;
 

5. Authorize the user, for example:

Grant create session, create table, create view, unlimited tablespace to test;
 

6. Switch the user to connect to the test user, for example:

 
Conn test/test;
 

7. Import an SQL script, for example:

 
@ E: \ test \ test_data. SQL;