ITPub博客

首页 > Linux操作系统 > Linux操作系统 > EXPDP IMPDP

EXPDP IMPDP

原创 Linux操作系统 作者:ganwangge 时间:2011-03-03 16:02:23 0 删除 编辑

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博客 ” ,链接:http://blog.itpub.net/11366721/viewspace-688340/,如需转载,请注明出处,否则将追究法律责任。

上一篇: EXPDP IMPDP
下一篇: 用戶表空間
请登录后发表评论 登录
全部评论

注册时间:2009-03-30

  • 博文量
    22
  • 访问量
    5718