SQL> create tablespace TBS_YKEMS DATAFILE '/u02/oradata/ykdb002/tbs_ykems.dbf'
2 size 2048M AUTOEXTEND ON NEXT 2048K MAXSIZE 2048M LOGGING EXTENT
3 MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> create tablespace NDX_YKEMS DATAFILE '/u02/oradata/ykdb002/ndx_ykems.dbf'
2 size 1024M AUTOEXTEND ON NEXT 2048K MAXSIZE 2048M LOGGING EXTENT
3 MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> create user ykems profile default identified by emsyk
2 default tablespace TBS_YKEMS
3 temporary tablespace TEMP
4 ACCOUNT UNLOCK;
User created.
SQL> grant connect to ykems;
Grant succeeded.
SQL> grant resource to ykems;
Grant succeeded.
SQL> exit
SQL> select * from dba_directories;
[oracle@ykdb002 dump]$ impdp system/nykpas01 content=all remap_schema=ems:ykems remap_tablespace=TBS_EMS:TBS_YKEMS directory=DUMPDIR dumpfile=ems20110303.dmp logfile=ykems20110303.log remap_tablespace=NDX_EMS:NDX_YKEMS remap_tablespace=TBS_FMS:TBS_YKEMS
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11366721/viewspace-688340/ ，如需转载，请注明出处，否则将追究法律责任。
