准备环境SQLcreate or replace directory dir1 as/home/oracle/dmp;SQLcreate usertestidentified by oracle default tablespaceusers;SQLalter usertestquotaunlimited onusers;SQLcreate table test.t_tab asselect* from dba_objects;selectsum(bytes/1024/1024/1024)Gb from dba_segments where segment_namein(T_TAB)andownerTEST;PAR_DUMPcatexp_data.parschemastestcompressionalldirectorydir1filesize9gdumpfilet_%U.dmplogfilet_data.logparallel3clusternincludeTABLE:IN(T_TAB)导出语句expdp\/as sysdba\parfileexp_data.par expdp system/oracle192.168.222.135:1521/pdbparfileexp_data.par导出表结构expdp\/as sysdba\directorydir1dumpfilexxxxclusternlogfilexxxx.logschemas(username,username)contentmetedata_only
oracle数据泵使用
发布时间：2026/5/19 19:19:25
准备环境SQLcreate or replace directory dir1 as/home/oracle/dmp;SQLcreate usertestidentified by oracle default tablespaceusers;SQLalter usertestquotaunlimited onusers;SQLcreate table test.t_tab asselect* from dba_objects;selectsum(bytes/1024/1024/1024)Gb from dba_segments where segment_namein(T_TAB)andownerTEST;PAR_DUMPcatexp_data.parschemastestcompressionalldirectorydir1filesize9gdumpfilet_%U.dmplogfilet_data.logparallel3clusternincludeTABLE:IN(T_TAB)导出语句expdp\/as sysdba\parfileexp_data.par expdp system/oracle192.168.222.135:1521/pdbparfileexp_data.par导出表结构expdp\/as sysdba\directorydir1dumpfilexxxxclusternlogfilexxxx.logschemas(username,username)contentmetedata_only
