cd /home/pkg/databasebackup
chown oracle:asmadmin /home/pkg/databasebackup
chgrp asmadmin /home/pkg/databasebackup
create or replace directory dump as '/home/pkg/databasebackup'
grant read,write on directory dump to koarac;
expdp 'ekpdev/"123"'@ekpdev directory=dump dumpfile =aa.dmp logfile=aa.log
前2句在sqlplus执行
第3句用oracle用户执行。
执行过程中,因rollback segment过小,KM_REVIEW_MAIN没有导出完毕,因此扩展undo_retention 由15分钟改为2小时。
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> alter system set undo_retention=7200 ;
System altered.
导入方案
--将dump_scott目录下的schema.dmp导入到scott方案中
impdp scott/tiger directory=dump_scott dumpfile=schema.dmp schemas=scott
--将scott方案中的所有对象转移到system方案中
impdp system/redhat directory=dump_scott dumpfile=schema.dmp schemas=scott remap_schema=scott:system