Pages

Sunday, 26 May 2013

DATA PUMP 11G

Datapump
• COMPRESSION
• ALL, DATA_ONLY, METADATA_ONLY, NONE
$ expdp / directory=tmp dumpfile=uncompressed.dmp compression=NONE schemas=ops\$tkyte
Export: Release 11.1.0.6.0 - Production on Friday, 21 September, 2007 12:23:26
. . exported "OPS$TKYTE"."BIG_TABLE" 24.57 MB 250000 rows
. . exported "OPS$TKYTE"."T" 6.791 MB 67945 rows
$ expdp / directory=tmp dumpfile=compressed.dmp compression=ALL schemas=ops\$tkyte
Export: Release 11.1.0.6.0 - Production on Friday, 21 September, 2007 12:23:58
. . exported "OPS$TKYTE"."BIG_TABLE" 3.110 MB 250000 rows
. . exported "OPS$TKYTE"."T" 762.1 KB 67945 rows
$ ls -l /tmp/*compressed.dmp
-rw-r----- 1 ora11gr1 ora11gr1 4124672 Sep 21 12:24 /tmp/compressed.dmp
-rw-r----- 1 ora11gr1 ora11gr1 33136640 Sep 21 12:23 /tmp/uncompressed.dmp

No comments:

Post a Comment