Oracle Data Import

1. Delete the contents of the original database

Drop user username cascade;

My database name is test, so the SQL statement is:

Drop user test cascade;

2. Create TABLE spaces:

The statement is: Create tablespace localtest datafile ' F:\Oracle\localtest.dbf ' size 2048M autoextend on;

Where Localtest is the new tablespace name, the path for datafile is the initial size of the table space, and Autoextend is auto-expanded.

PS: Error found after execution

Find the wrong words according to the asterisk position!

In the coming time:

3. Create your own users:

CREATE user utest (user name)
Identified by Upassword (password)
DEFAULT tablespace Test (table space created above)
Temporary tablespace temp; (Temporary tablespace will write temp)

Perform

4. Authorization:

5. Importing DMP files

Note: To exit from the SQL environment,

Input exit exit;

Execute statement:

Imp yzy/**** @localhost: 1521\ORCL file=d:\0309.dmp full=y log =y;

There was an error!

The reason is that the host in Tnsnames.ora is not localhost, here you can change to localhost, you can also use the file

Solution :

Rewrite statement:

Imp yzy/**** @DESKTOP-k74s92q:1521\orcl file=d:\0309.dmp full=y log =y;

OK, it's on the table, but there are some errors from the log, we can ignore the error, just add ignore=y, we can

Oracle Data Import