expdp compression 时间 大小 压缩比对比

发布于:2024-06-04 ⋅ 阅读:(128) ⋅ 点赞:(0)

compression=DATA_ONLY
parallel=4
 

FLASHBACK automatically enabled to preserve database integrity.
Starting "XX "."SYS_EXPORT_SCHEMA_02":  XXXXXXXXXXXX parfile=expXtabpar
ORA-39327: Oracle Database Vault data is being stored unencrypted in dump file set.
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported TABLE                           1.434 GB 89999000 rows
ORA-39173: Encrypted data has been stored unencrypted in dump file set.
Master table "XX "."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
******************************************************************************
Dump file set for XX .SYS_EXPORT_SCHEMA_02 is:
  /u01/app/oracle/dumpfile/TABLE                         _FINAL_PROD01.dmp
  /u01/app/oracle/dumpfile/TABLE                         _FINAL_PROD02.dmp
  /u01/app/oracle/dumpfile/TABLE                         _FINAL_PROD03.dmp
  /u01/app/oracle/dumpfile/TABLE                         _FINAL_PROD04.dmp
Job "XX "."SYS_EXPORT_SCHEMA_02" completed with 1 error(s) at Tue Jun 4 15:40:18 2024 elapsed 0 00:02:09
 
 

compression=DATA_ONLY
 

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
FLASHBACK automatically enabled to preserve database integrity.
Starting "XX "."SYS_EXPORT_SCHEMA_02":  XXXXXXXXXXXX parfile=expXtabpar
ORA-39327: Oracle Database Vault data is being stored unencrypted in dump file set.
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported TABLE                           1.432 GB 89999000 rows
ORA-39173: Encrypted data has been stored unencrypted in dump file set.
Master table "XX "."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
******************************************************************************
Dump file set for XX .SYS_EXPORT_SCHEMA_02 is:
  /u01/app/oracle/dumpfile/TABLE                         _FINAL_PROD01.dmp
Job "XX "."SYS_EXPORT_SCHEMA_02" completed with 1 error(s) at Tue Jun 4 15:47:34 2024 elapsed 0 00:04:37

compression= 
parallel=
 

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
FLASHBACK automatically enabled to preserve database integrity.
Starting "XX "."SYS_EXPORT_SCHEMA_02":  XXXXXXXXXXXX parfile=expXtabpar
ORA-39327: Oracle Database Vault data is being stored unencrypted in dump file set.
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported TABLE                           12.66 GB 89999000 rows
ORA-39173: Encrypted data has been stored unencrypted in dump file set.
Master table "XX "."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
******************************************************************************
Dump file set for XX .SYS_EXPORT_SCHEMA_02 is:
  /u01/app/oracle/dumpfile/1TABLE                         _FINAL_PROD01.dmp
Job "XX "."SYS_EXPORT_SCHEMA_02" completed with 1 error(s) at Tue Jun 4 15:50:13 2024 elapsed 0 00:01:33


网站公告

今日签到

点亮在社区的每一天
去签到