oracle 19c 使用EXPDP完成传输表空间导出

郑全

[oracle@host01 scripts]$ expdp system/sztech_4U@pdbprod1 directory=d1 dumpfile=trans3_2.dmp TRANSPORT_TABLESPACES=TRANS_TBS

Export: Release 19.0.0.0.0 - Production on Wed Jun 28 16:05:35 2023
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
Starting "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01":  system/********@pdbprod1 directory=d1 dumpfile=trans3_2.dmp TRANSPORT_TABLESPACES=TRANS_TBS
Processing object type TRANSPORTABLE_EXPORT/STATISTICS/TABLE_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/STATISTICS/MARKER
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Master table "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TRANSPORTABLE_01 is:
  /home/oracle/files/trans3_2.dmp
******************************************************************************
Datafiles required for transportable tablespace TRANS_TBS:
  /u01/app/oracle/oradata/PRODCDB/PDBPROD1/trpdata_6.dbf
Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at Wed Jun 28 16:06:52 2023 elapsed 0 00:01:14