expdp compression 时间大小压缩比对比

最新推荐文章于 2024-07-25 08:41:17 发布

jnrjian

最新推荐文章于 2024-07-25 08:41:17 发布

阅读量540

点赞数 15

文章标签： oracle

本文链接：https://blog.csdn.net/jnrjian/article/details/139445600

版权

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