Data Pump Import for Oracle Import

1. First, look at the directory object, for viewing only.

SELECT * from Dba_directories;

2. Create directory object: (note D:\APP\EXPDP must have Oh, and will import the DMP method under this folder easy to import OH).

CREATE OR REPLACE DIRECTORY expdp_dir as ' D:\APP\EXPDP ';

3. Create a temporary tablespace (note that the D:\app\oradata must exist or the directory does not correspond to it).

Create temporary tablespace espxmgl_temp
Tempfile ' D:\app\oradata\ESPXMGL_TEMP. DBF '
Size 50m
Autoextend on
Next 50m maxsize 2048m
Extent management Local;

4. Create a tablespace (note that the D:\app\oradata must be true or the directory does not correspond)

Create Tablespace Fmisdbdata
Logging
DataFile ' D:\app\oradata\FMISDBDATA. DBF '
Size 10240M
Autoextend on
Next 500m MaxSize 20480M
Extent management Local;

5. Create a user and give permissions

CREATE USER Fmisdb identified by Fmisdb DEFAULT tablespace fmisdbdata temporary tablespace espxmgl_temp;
ALTER USER fmisdb DEFAULT tablespace fmisdbdata temporary tablespace espxmgl_temp;
GRANT read,write on DIRECTORY expdp_dir to Fmisdb;

Alter user FMISDB account unlock;
Grant DBA to Fmisdb;

6. Import data (Note If you do not have a client installed, the imported statements are different because of the different versions of Oracle.) ）

Aaa. DMP is the D:\ORACLE\EXPDP corresponding import file. The first one in Remap_schema is the user name when exporting: The second is the user name that is imported. Remap_tablespace (table space)

IMPDP fmisdb/[email PROTECTED]/ORCL directory=expdp_dir dumpfile=d:\oracle\expdp\aaa. DMP logfile=fedata1124.log remap_schema=fmisdb:fmisdb remap_tablespace= fmisdbdata:fmisdbdata (32-bit client 64-bit Oracle with the above data pump import)

IMPDP Fmisdb/[email protected] directory=expdp_dir dumpfile=d:\oracle\expdp\aaa. DMP logfile=fedata1124.log remap_schema=fmisdb:fmisdb remap_tablespace= fmisdbdata:fmisdbdata (no client installed with this)

Import of data pump imported by Oracle