四、用expdp导出数据
1)导出用户
expdp scott/tiger@orcl schemas=scott dumpfile=expdp.dmp directory=dump_dir;
2)导出表
expdp scott/tiger@orcl tables=emp,dept dumpfile=expdp.dmp directory=dump_dir;
3)按查询条件导
expdp scott/tiger@orcl directory=dump_dir dumpfile=expdp.dmp tables=empquery='where deptno=20';
4)按表空间导
expdp system/manager@orcl directory=dump_dir dumpfile=tablespace.dmptablespaces=temp,example;
5)导整个数据库
expdp system/manager@orcl directory=dump_dir dumpfile=full.dmp full=y;
五、用impdp导入数据
1)导入用户(从用户scott导入到用户scott)
impdp scott/tiger@orcl directory=dump_dir dumpfile=expdp.dmp schemas=scott;
2)导入表(从scott用户中把表dept和emp导入到system用户中)
impdp system/manager@orcl directory=dump_dir dumpfile=expdp.dmptables=scott.dept,scott.emp remap_schema=scott:system;
3)导入表空间
impdp system/manager@orcl directory=dump_dir dumpfile=tablespace.dmp tablespaces=example;
4)导入数据库
impdb system/manager@orcl directory=dump_dir dumpfile=full.dmp full=y;
5)追加数据
impdp system/manager@orcl directory=dump_dir dumpfile=expdp.dmp schemas=systemtable_exists_action
1;复制ups和USC的dmp文件到D:\database\oracle\admin\orcl\dpdump 2:清空用户下的对象 3:在cmd内执行: impdp 用户名/密码@115.159.112.175:1521/orcl schemas=dmp内的用户 dumpfile=usc.dmp REMAP_TABLESPACE=TBS_INDX_SPC:XH-ASC-U remap_schema=dmp内的用户:用户名 impdp 用户名/密码@115.159.112.175:1521/orcl schemas=dmp内的用户 dumpfile=ups.dmp REMAP_TABLESPACE=TBS_INDX_SPC:XH-ASC-P remap_schema=dmp内的用户:用户名 impdp ups/ups@192.168.2.135:1521/orcl schemas=ups dumpfile=ups.dmp REMAP_TABLESPACE=TBS_INDX_SPC:ups REMAP_TABLESPACE=TBS_DATA_SPC:ups REMAP_TABLESPACE=UPS-DATA:ups remap_schema=ups:ups version=10.2.0
expdp usc/usc@106.15.91.126:1521/orcl schemas=usc dumpfile=usc_11.dmp version=10.2.0
expdp ups/ups@106.15.91.126:1521/orcl schemas=ups dumpfile=ups_11.dmp version=10.2.0
impdp udsm/udsm@106.15.91.126:1521/orcl schemas=usc dumpfile=usc_11.dmp remap_schema=usc:udsm version=10.2.0
impdp uspd/uspd@106.15.91.126:1521/orcl schemas=ups dumpfile=ups_11.dmp remap_schema=ups:uspd version=10.2.0
欢迎光临 临海小憇 (http://czidea.cn/) | Powered by Discuz! X3.3 |