Import of local database and problems encountered

1. Modify the DMP package permissions
D:\ORACLE11G\admin\orcl\dpdump\ (The DMP package is placed in this directory by default)

2 Setting up tablespaces and creating users (using the management tools in the client)

3 Import
--(wrong) IMPDP LPF/LPF directory= ' D:\ORACLE11G\admin\orcl\dpdump\ ' dumpfile=gsmcpm201409092200.dmp remap_schema=gsmcpm : LPF
--(to) IMPDP LPF/LPF dumpfile=gsmcpm201409092200.dmp REMAP_SCHEMA=GSMCPM:LPF

Connecting to a database
Sqlplus/nolog
Or
Sqlplus/as SYSDBA

4. Problems encountered:

Not enough table space:

Method One:

select* from Dba_data_files
TBS_GSMCPM_MAIN01.DBF Tbs_gsmcpm_main
ACWS_FRAME01.DBF Acws_frame

--Create a delete table space
Create tablespace tbs_gsmcpm_main datafile ' D:\ORACLE11G\ORADATA\ORCL\TBS_GSMCPM_MAIN01. DBF ' size 500m;
Create tablespace acws_frame datafile ' D:\ORACLE11G\ORADATA\ORCL\ACWS_FRAME01. DBF ' size 500m;
ALTER DATABASE DataFile ' D:\ORACLE11G\ORADATA\ORCL\ACWS_FRAME01. DBF ' autoextend on next 500m maxsize 1500m
DROP tablespace acws_frame including CONTENTS and datafiles CASCADE CONSTRAINTS

--table space is manually deleted processing method (cannot recover)
Alter session set Nls_language=american;
ALTER DATABASE DataFile ' D:\ORACLE11G\ORADATA\ORCL\ACWS_FRAME01. DBF ' offline drop;
ALTER DATABASE open;
--See if the data import is running
SELECT job_name,state from dba_datapump_jobs where State <> ' not RUNNING ';

Select segment_name,sum (bytes)/1024/1024 from User_extents Group by segment_name

Method Two:

Install a oracle-client software and use the database Enterprise MANAGER console inside to create an additional table space.

Access to the imported path is not available:

You can give the Import folder permission, or put it under the Oracle default import path, such as: \oracle11g\admin\orcl\dpdump\

Import of local database and problems encountered