数据泵：导入导出dblink

概述环境介绍：12c->19c [oracle@enmoedu1 dpdump]$ expdp system/oracle directory=DATA_PUMP_DIR dumpfile=STAT

环境介绍：12c->19c

[oracle@enmoedu1 dpdump]$ expdp system/oracle directory=DATA_PUMP_DIR dumpfile=STATE_2018112201_%U.dmp logfile=STATE_112210.log include=db_link full=y

Export: Release 12.2.0.1.0 - Production on Fri Jun 4 15:45:56 2021

copyright (c) 1982,2017,Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "SYstem"."SYS_EXPORT_FulL_01": system/******** directory=DATA_PUMP_DIR dumpfile=STATE_2018112201_%U.dmp logfile=STATE_112210.log include=db_link full=y
Processing object type DATABASE_EXPORT/SCHEMA/DB_link
Master table "SYstem"."SYS_EXPORT_FulL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYstem.SYS_EXPORT_FulL_01 is:
/u01/app/oracle/admin/PROD/dpdump/STATE_2018112201_01.dmp
Job "SYstem"."SYS_EXPORT_FulL_01" successfully completed at Fri Jun 4 15:46:01 2021 elapsed 0 00:00:04

 

[oracle@rac1 dpdump]$ impdp system/oracle directory=DATA_PUMP_DIR dumpfile=STATE_2018112201_%U.dmp logfile=STATE_112210.log

import: Release 19.0.0.0.0 - Production on Fri Jun 4 15:46:05 2021
Version 19.3.0.0.0

copyright (c) 1982,2019,Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Master table "SYstem"."SYS_import_FulL_01" successfully loaded/unloaded
Starting "SYstem"."SYS_import_FulL_01": system/******** directory=DATA_PUMP_DIR dumpfile=STATE_2018112201_%U.dmp logfile=STATE_112210.log
Processing object type DATABASE_EXPORT/SCHEMA/DB_link
Job "SYstem"."SYS_import_FulL_01" successfully completed at Fri Jun 4 15:46:10 2021 elapsed 0 00:00:03

sql> select owner,object_name from dba_objects where object_type='DATABASE link';

OWNER
--------------------------------------------------------------------------------
OBJECT_name
--------------------------------------------------------------------------------
SYS
SYS_HUB

PUBliC
TESTlink1.ENMOEDU.COM

总结

以上是内存溢出为你收集整理的数据泵：导入导出dblink全部内容，希望文章能够帮你解决数据泵：导入导出dblink所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。