首页 > Linux操作系统 > Linux操作系统 > expdp/impdp
11.1-11.2 exp&imp
1 导出数据库:exp system/oracle full=y file=d:\myfull.dmp log=d:\myfull.log
2 导出用户(方案、模式): exp system/oracle wner=scott file=d:\myuser.dmp log=d:\myuser.log
3 导出表:exp system/oracle tables=scott.emp,scott.dept file=d:\mytable.dmp log=d:\mytable.log
4 导入数据库:imp system/oracle full=y file=d:\myfull.dmp log=d:\myfull.log ignore=y
5 导入用户(方案、模式): imp system/oracle fromuser=scott touser=test file=d:\myuser.dmp log=d:\myuser.log ignore=y
6 导入表:imp system/oracle tables=scott.emp,scott.dept file=d:\mytable.dmp log=d:\mytable.log ignore=y
11.3 expdp&impdp
1 建立directory,并授权;create directory dump_dir as 'd:\oracle';grant read on directory dump_dir to scott; grant exp_full_database to scott;
2 导出数据库:expdp system/oracle dumpfile=dump_dir:myfull.dat full=y nologfile=y job_name=just_scott;
3 导出用户:expdp system/oracle dumpfile=dump_dir:myuser.dat schemas=scott nologfile=y job_name=just_scott;
4 导出表:expdp system/oracle dumpfile=dump_dir:myuser.dat tables=scott.emp,scott.dept nologfile=y job_name=just_table
5 导入用户(方案、模式): impdp system/oracle dumpfile=dump_dir:myuser.dat remap_schemas=scott:test remap_tablespace=users:test nologfile=y job_name=just_user
6 导入表:imp system/oracle dumpfile=dump_dir:mytable.dat tables=scott.emp,scott.dept nologfile=y job_name=just_user
11.4 oracle 数据泵的交互模式
1 ctrl+c退出;export>continue_client;
2 expdp system/oracle attach=just_scott
3 交互模式下常用命令:continue_client(返回到客户登录模式);kill_job(删除现有的作业);status(定义监视作业的频率)
4 与数据泵有关的数据字典:dba_directories;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/10225874/viewspace-566533/ ,如需转载,请注明出处,否则将追究法律责任。