Oracle is perfectly imported to DMP under the Win7 system

First step: Create a backup file storage directory

Create or replace directory Back_file as ' D:\app\yangxf\back_or_memery_file ';

Create or replace directory name as ' D:\app\yangxf\back_or_memery_file ';

Step two: Create a table space

Create tablespace base_data datafile ' D:\app\yangxf\oradata\base_tablespace\BASE.dbf ' size 100M autoextend on next 50m;

Create tablespace table space name (consistent with backup file tablespace) datafile ' D:\app\yangxf\oradata\base_tablespace\ backup filename. dbf ' size 100M autoextend on Next 50m;

Step three: Create a backup file user, specify a table space

Create user base identified by BASE default Tablespace base_data;

Create user username identified by password default tablespace table space name;

Fourth step: Authorized users to read and write the backup file directory

Grant read, write on directory back_file to BASE;

Grant read, write on directory store directory name to user name;

Fifth step: Execute the Import statement

IMPDP System/[email protected] directory=back_file dumpfile=base. DMP full=y;

IMPDP User name/password @ instance name directory= Directory name dumpfile= to the imported file name. DMP full=y;

Note:

Delete all objects under user

Drop user JCSJ cascade;

Drop user username cascade;

Delete Table space

Drop tablespace jcsj_data including contents and datafiles;

Drop tablespace table space name including contents and datafiles;

Super Admin Login

Sqlplus Sys/[email protected] as SYSDBA;

Sqlplus username/Password @ instance name as SYSDBA;

Oracle is perfectly imported to DMP under the Win7 system