Is it possible to use EXPDP directly with GZIP ? [ID 463336.1]
修改時間 20-JUL-2010 型別 HOWTO 狀態 PUBLISHED |
In this Document
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10.1 to 10.2Information in this document applies to any platform.
Goal
With the old EXPORT utility you can execute the export using exp command with gzip program as below:mknod /u01/backup/exp/export_pipe p
nohup /usr/bin/gzip < /u01/backup/exp/export_pipe > /u01/backup/exp/dbaceh.dmp.gz 2>
/u01/backup/logs/gzip.log &
$ORACLE_HOME/bin/exp user/senha@dbaceh file=/u01/backup/exp/export_pipe buffer=40000000
log=/u01/backup/logs/dbaceh.log full=y >>$ARQLOG 2>>$ARQLOG
When trying to do the export using EXPDP (Data Pump) in the same way, the dump file doesn't work with the gzip program
Is it possible to use EXPDP with GZIP ? and if not, why?
Solution
Since Datapump Export is optimized to work from within the server,
the export dumpfile information is no longer processed in a sequential
manner.
As a result, sequential media, such as tapes and pipes,
are no longer supported with Export DataPump (expdp) and Import DataPump
(impdp).
So, There is no way to do this with DataPump, as you cannot use named pipes with datapump, so there
is
no way to pass the dumpfile to the gzip command through a pipe. You can
only compress the dump file after the export is complete. It cannot be
done during the export itself.
The only option would be to add
disk space, or nfs mount a large enough filesystem to the server and use
that as the export destination, do the DataPump export to that
destination, then use GZIP to compress the output file.
In Oracle
10.2 release, Data Pump by default supports compressing the system
metadata ( grants, schemas, roles, types, etc.) that's written to the
dump file. This can be manually enabled/disabled using the compression
parameter.
For example,
expdp userid/password DIRECTORY=dpump_dir DUMPFILE=scott SCHEMAS=scott
COMPRESSION=METADATA_ONLY
explicitly
indicates that the system metadata be compressed. This is the default
behavior. Using "COMPRESSION=NONE" would explicitly disable compression.
In 11.1 release of Oracle the feature was enhanced to allow for
the compression for table data. The "compression" parameter now accepts
the following values:
NONE
METADATA_ONLY
DATA_ONLY
ALL
For example,
expdp userid/password DIRECTORY=dpump_dir DUMPFILE=scott SCHEMAS=scott
COMPRESSION=ALL
will compress all system metadata and all table data in the dumpfile.
11g, needs the Advanced Compression Option license (extra costs) for compression = ALL or DATA_ONLY. It is also needed for the import it these options were used during expdp.
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/161195/viewspace-1055069/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【EXPDP】11g版本EXPDP 的COMPRESSION引數壓縮比堪比“gzip -9”
- nginx gzip 與 gzip_staticNginx
- gzip
- Android總結之Gzip/Zip壓縮Android
- Android App Injection&&Drozer UseAndroidAPP
- how to use oidpasswd to admin your AS/OID account
- wait for possible quiesce finishAIUI
- For v$ views you need to grant privilege to each v_$ directlyView
- TypeError: Descriptors cannot not be created directly問題的解決Error
- android解壓縮GZIP格式的網頁資料Android網頁
- Flutter Gzip 編碼與解碼 Dart Gzip 工具類操作FlutterDart
- Nginx的Gzip功能Nginx
- Linux gzip、gunzipLinux
- nginx gzip on 無效Nginx
- 【轉載】Kano Model — Ways to use it and NOT use it
- stm32 use of undeclared identifier GPIO_InitTypeDefIDE
- nginx的gzip指令介紹,Nginx的gzip指令使用小結Nginx
- use-magic-grid:magic-grid 庫的官方 React 埠React
- the "in" use in mysqlMySql
- nginx useNginx
- tar compress gzip 操作
- Android Java壓縮Zlib,Gzip,Zip支援J2MEAndroidJava
- Archiving not possible: No primary destinations errorsError
- ARCH: Possible network disconnect with primary databaseDatabase
- oracle hint_use_concat_use_nl_with_indexOracleIndex
- Oracle expdpOracle
- Android Demo:手工覆蓋率(AS3.2)use JacocoAndroidS3
- Bitmap回收—Canvas: trying to use a recycled bitmap android.graphicsCanvasAndroid
- Apache 開啟gzip壓縮Apache
- nginx配置gzip中的坑Nginx
- Linux基礎命令---gzipLinux
- gzip: stdin:unexpected end of file
- tar/gzip/unzip命令詳解
- 使用gzip壓縮檔案
- gzip-1.2.4程式分析 (轉)
- DataPump Export (EXPDP) Fails With Error LPX-216 Invalid CharacterExportAIError
- 【MOS】 EXPDP - ORA-39166 (Object Was Not Found) (文件 ID 1640392.1)Object
- plsql use skillsSQL