How to import an Oracle database file using IMPDP

1. First of all, install the Oracle database.

2, use Sqlplus to enter SYSDBA permission, sqlplus "/as sysdba", for example:

3. Create user framework, for example:

CREATE USER Framework Profile DEFAULT identified by framework
DEFAULT tablespace USERS Temporary tablespace temp account UNLOCK;
GRANT UNLIMITED tablespace to framework;
GRANT Connect,resource to framework;
Grant DBA to framework;

Note: If you want to restrict permissions for the framework, the last sentence of Grant DBA to framework;

4, in My computer, set up a folder F:\tempdump, the frameworkexpdp.dmp copy into the folder. For example:

5. Create the directory in the Sqlplus window and assign permissions to the framework User:

CREATE OR REPLACE DIRECTORY tempdump as ' f:/tempdump/';
GRANT READ, WRITE on the DIRECTORY tempdump to framework;

6. Open another CMD window and import the database using IMPDP:

IMPDP Framework/[email protected] full=y directory=tempdump dumpfile=frameworkexpdp.dmp

7, Import success!

Wood elder brother's articles are based on their own practice, you can pass: "E-Mail protected " contact.

How to import an Oracle database file using IMPDP