10G、11G expdp的compression引數的區別
只是對metadata的壓縮 也就是定義的壓縮 說白了 就是沒鳥用的
今天剛剛裝了個11g 就測試了下expdp的compression
首先expdp help=y看看 11g 和10g有什麼不同
[@more@]Keyword Description (Default)
------------------------------------------------------------------------------
ATTACH Attach to existing job, e.g. ATTACH [=job name].
COMPRESSION Reduce size of dumpfile contents where valid keyword.
values are: ALL, (METADATA_ONLY), DATA_ONLY and NONE.
CONTENT Specifies data to unload where the valid keyword
values are: (ALL), DATA_ONLY, and METADATA_ONLY.
DATA_OPTIONS Data layer flags where the only valid value is:
XML_CLOBS-write XML datatype in CLOB format
DIRECTORY Directory object to be used for dumpfiles and logfiles.
DUMPFILE List of destination dump files (expdat.dmp),
e.g. DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp.
ENCRYPTION Encrypt part or all of the dump file where valid keyword
values are: ALL, DATA_ONLY, METADATA_ONLY,
ENCRYPTED_COLUMNS_ONLY, or NONE.
ENCRYPTION_ALGORITHM Specify how encryption should be done where valid
keyword values are: (AES128), AES192, and AES256.
ENCRYPTION_MODE Method of generating encryption key where valid keyword
values are: DUAL, PASSWORD, and (TRANSPARENT).
ENCRYPTION_PASSWORD Password key for creating encrypted column data.
ESTIMATE Calculate job estimates where the valid keyword
values are: (BLOCKS) and STATISTICS.
ESTIMATE_ONLY Calculate job estimates without performing the export.
EXCLUDE Exclude specific object types, e.g. EXCLUDE=TABLE:EMP.
FILESIZE Specify the size of each dumpfile in units of bytes.
FLASHBACK_SCN SCN used to set session snapshot back to.
FLASHBACK_TIME Time used to get the SCN closest to the specified time.
FULL Export entire database (N).
HELP Display Help messages (N).
INCLUDE Include specific object types, e.g. INCLUDE=TABLE_DATA.
JOB_NAME Name of export job to create.
LOGFILE Log file name (export.log).
NETWORK_LINK Name of remote database link to the source system.
NOLOGFILE Do not write logfile (N).
PARALLEL Change the number of active workers for current job.
PARFILE Specify parameter file.
QUERY Predicate clause used to export a subset of a table.
REMAP_DATA Specify a data conversion function,
e.g. REMAP_DATA=EMP.EMPNO:REMAPPKG.EMPNO.
REUSE_DUMPFILES Overwrite destination dump file if it exists (N).
SAMPLE Percentage of data to be exported;
SCHEMAS List of schemas to export (login schema).
STATUS Frequency (secs) job status is to be monitored where
the default (0) will show new status when available.
TABLES Identifies a list of tables to export - one schema only.
TABLESPACES Identifies a list of tablespaces to export.
TRANSPORTABLE Specify whether transportable method can be used where
valid keyword values are: ALWAYS, (NEVER).
TRANSPORT_FULL_CHECK Verify storage segments of all tables (N).
TRANSPORT_TABLESPACES List of tablespaces from which metadata will be unloaded.
VERSION Version of objects to export where valid keywords are:
(COMPATIBLE), LATEST, or any valid database version.
The following commands are valid while in interactive mode.
Note: abbreviations are allowed
Command Description
------------------------------------------------------------------------------
ADD_FILE Add dumpfile to dumpfile set.
CONTINUE_CLIENT Return to logging mode. Job will be re-started if idle.
EXIT_CLIENT Quit client session and leave job running.
FILESIZE Default filesize (bytes) for subsequent ADD_FILE commands.
HELP Summarize interactive commands.
KILL_JOB Detach and delete job.
PARALLEL Change the number of active workers for current job.
PARALLEL=
REUSE_DUMPFILES Overwrite destination dump file if it exists (N).
START_JOB Start/resume current job.
STATUS Frequency (secs) job status is to be monitored where
the default (0) will show new status when available.
STATUS[=interval]
STOP_JOB Orderly shutdown of job execution and exits the client.
STOP_JOB=IMMEDIATE performs an immediate shutdown of the
Data Pump job.
這裡只討論compression 其他的後續再研究 呵呵
我們可以發現 11g的compression比10g 多了2個引數值 增加了all 和data_only
data_only是什麼意思呢？ 其實就是提供對錶資料的壓縮 下面看測試
[oracle@red-db1 bin]$ expdp system/huanhuan dumpfile=1210_02.dmp tables=roger.b1,roger.b2,roger.b3,roger.b4,roger.b5,roger.b6 logfile=lizx02.log
Export: Release 11.1.0.6.0 - Production on Saturday, 12 December, 2009 0:29:19
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01": system/******** dumpfile=1210_02.dmp tables=roger.b1,roger.b2,roger.b3,roger.b4,roger.b5,roger.b6 logfile=lizx02.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 384 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "ROGER"."B1" 10.44 KB 2 rows
. . exported "ROGER"."B2" 10.52 KB 3 rows
. . exported "ROGER"."B3" 10.59 KB 4 rows
. . exported "ROGER"."B4" 10.66 KB 5 rows
. . exported "ROGER"."B5" 10.74 KB 6 rows
. . exported "ROGER"."B6" 10.81 KB 7 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
/oracle/product/admin/alex/dpdump/1210_02.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 00:29:42
[oracle@red-db1 bin]$ expdp system/huanhuan dumpfile=1210_03.dmp compression=none tables=roger.b1,roger.b2,roger.b3,roger.b4,roger.b5,roger.b6 logfile=lizx03.log
Export: Release 11.1.0.6.0 - Production on Saturday, 12 December, 2009 0:30:39
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01": system/******** dumpfile=1210_03.dmp compression=none tables=roger.b1,roger.b2,roger.b3,roger.b4,roger.b5,roger.b6 logfile=lizx03.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 384 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "ROGER"."B1" 10.44 KB 2 rows
. . exported "ROGER"."B2" 10.52 KB 3 rows
. . exported "ROGER"."B3" 10.59 KB 4 rows
. . exported "ROGER"."B4" 10.66 KB 5 rows
. . exported "ROGER"."B5" 10.74 KB 6 rows
. . exported "ROGER"."B6" 10.81 KB 7 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
/oracle/product/admin/alex/dpdump/1210_03.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 00:31:02
[oracle@red-db1 bin]$ expdp system/huanhuan dumpfile=1210_04.dmp compression=metadata_only tables=roger.b1,roger.b2,roger.b3,roger.b4,roger.b5,roger.b6 logfile=lizx04.log
Export: Release 11.1.0.6.0 - Production on Saturday, 12 December, 2009 0:31:40
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01": system/******** dumpfile=1210_04.dmp compression=metadata_only tables=roger.b1,roger.b2,roger.b3,roger.b4,roger.b5,roger.b6 logfile=lizx04.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 384 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "ROGER"."B1" 10.44 KB 2 rows
. . exported "ROGER"."B2" 10.52 KB 3 rows
. . exported "ROGER"."B3" 10.59 KB 4 rows
. . exported "ROGER"."B4" 10.66 KB 5 rows
. . exported "ROGER"."B5" 10.74 KB 6 rows
. . exported "ROGER"."B6" 10.81 KB 7 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
/oracle/product/admin/alex/dpdump/1210_04.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 00:32:03
[oracle@red-db1 bin]$ expdp system/huanhuan dumpfile=1210_05.dmp compression=data_only tables=roger.b1,roger.b2,roger.b3,roger.b4,roger.b5,roger.b6 logfile=lizx05.log
Export: Release 11.1.0.6.0 - Production on Saturday, 12 December, 2009 0:32:45
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01": system/******** dumpfile=1210_05.dmp compression=data_only tables=roger.b1,roger.b2,roger.b3,roger.b4,roger.b5,roger.b6 logfile=lizx05.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 384 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "ROGER"."B1" 5.765 KB 2 rows
. . exported "ROGER"."B2" 5.773 KB 3 rows
. . exported "ROGER"."B3" 5.820 KB 4 rows
. . exported "ROGER"."B4" 5.765 KB 5 rows
. . exported "ROGER"."B5" 5.875 KB 6 rows
. . exported "ROGER"."B6" 5.898 KB 7 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
/oracle/product/admin/alex/dpdump/1210_05.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 00:33:09
[oracle@red-db1 bin]$ expdp system/huanhuan dumpfile=1210_06.dmp compression=all tables=roger.b1,roger.b2,roger.b3,roger.b4,roger.b5,roger.b6 logfile=lizx06.log
Export: Release 11.1.0.6.0 - Production on Saturday, 12 December, 2009 0:33:44
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01": system/******** dumpfile=1210_06.dmp compression=all tables=roger.b1,roger.b2,roger.b3,roger.b4,roger.b5,roger.b6 logfile=lizx06.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 384 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "ROGER"."B1" 5.765 KB 2 rows
. . exported "ROGER"."B2" 5.773 KB 3 rows
. . exported "ROGER"."B3" 5.820 KB 4 rows
. . exported "ROGER"."B4" 5.765 KB 5 rows
. . exported "ROGER"."B5" 5.875 KB 6 rows
. . exported "ROGER"."B6" 5.898 KB 7 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
/oracle/product/admin/alex/dpdump/1210_06.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 00:34:08
[oracle@red-db1 bin]$
-rw-r----- 1 oracle oinstall 237568 12-12 00:29 1210_02.dmp
-rw-r----- 1 oracle oinstall 237568 12-12 00:31 1210_03.dmp
-rw-r----- 1 oracle oinstall 237568 12-12 00:32 1210_04.dmp
-rw-r----- 1 oracle oinstall 81920 12-12 00:33 1210_05.dmp
-rw-r----- 1 oracle oinstall 81920 12-12 00:34 1210_06.dmp
我們可以看到 預設是不進行壓縮的 對於表資料而言 all和data_only基本一樣。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/670493/viewspace-1029593/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【EXPDP】11g版本EXPDP 的COMPRESSION引數壓縮比堪比“gzip -9”
- oracle10g,11g中的exp,expdp引數compress, compression完全不同的定義Oracle
- 關於 Oracle 10g EXPDP 的 EXCLUDE 引數Oracle 10g
- EXPDP的parallel引數Parallel
- Oracle 10g expdp attach引數體驗Oracle 10g
- 10G資料泵載入命令expdp/impdp的引數說明
- 10g和11g自動任務的區別
- 10g和11g自動統計的區別
- 10g 11g 檢視是否DISABLE CRS和10g 11g LOCAL listener的區別
- exp/expdp與imp/impdp的區別
- EXP/IMP和EXPDP/IMPDP的區別
- 【EXPDP】使用expdp的QUERY引數限定備份資料的範圍
- Java引數-Xms和-Xmx的區別Java
- exp與expdp區別
- Oracle expdp 排除表引數Oracle
- EXPDP/IMPDP 中的並行度PARALLEL引數並行Parallel
- 統計資訊10G和11G區別
- oracle9i、10g、11g區別Oracle
- 10g升級至11g需要考慮的引數優化優化
- oracle 10g 與11g統計資訊區別Oracle 10g
- 【EXPDP】不使用DIRECTORY引數完成expdp資料備份
- 引數為*&與*的區別以及二維陣列傳遞時列數不對等的區別陣列
- 詳解Oracle 10g、11g和CHECKPOINT相關的初始化引數Oracle 10g
- subprocess中命令為引數序列和字串的區別字串
- EXP匯出引數compress=y(n)的區別
- exp/imp與expdp/impdp區別
- Oracle expdp impdp dump引數介紹Oracle
- 常用的jvm配置引數 ：永久區引數配置JVM
- OB有問必答 | 引數和變數的區別是什麼？變數
- 10g中的sga_target引數
- mongod命令的一些引數以及引數--pidfilepath與mongod.lock區別Go
- my.cnf中[mysql]與[mysqld]下引數的區別MySql
- 【Data Pump】理解expdp中的ESTIMATE和ESTIMATE_ONLY引數
- 【EXPDP】使用EXPDP備份資料時預估大小——ESTIMATE引數
- 10g中的optimizer_mode引數的取值
- exp和expdp的filesize引數的使用--匯出多個檔案
- 透過expdp&impdp把11g的資料遷移到10g平臺的要點
- 通過expdp&impdp把11g的資料遷移到10g平臺的要點