gistfile1.sh

exp xx/xx@xx tables='baz' file='test1.dmp' consistent=y
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning option
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                            BAZ    1000000 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Sep 23 11:05:19 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning option

SQL> create table delme(id int);

Table created.

exp xx/xx@xx tables='baz' file='test2.dmp' consistent=y
About to export specified tables via Conventional Path ...
. . exporting table                            BAZ    1000000 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
[Kenny-Gormans-MacBook-Pro:~] oracle% dd if=test2.dmp bs=8192 count=99999 of=test2.out iseek=1
973+1 records in
973+1 records out
7974912 bytes transferred in 0.025140 secs (317222462 bytes/sec)
[Kenny-Gormans-MacBook-Pro:~] oracle% dd if=test1.dmp bs=8192 count=99999 of=test1.out iseek=1
973+1 records in
973+1 records out
7974912 bytes transferred in 0.024213 secs (329363858 bytes/sec)
[Kenny-Gormans-MacBook-Pro:~] oracle% md5 test1.out
MD5 (test1.out) = 5ba71eb409f73c9f760ae2c2160d329d
[Kenny-Gormans-MacBook-Pro:~] oracle% md5 test2.out
MD5 (test2.out) = 5ba71eb409f73c9f760ae2c2160d329d
[Kenny-Gormans-MacBook-Pro:~] oracle% dd if=test1.dmp bs=8192 count=99999 of=test1.out 
974+1 records in
974+1 records out
7983104 bytes transferred in 0.025608 secs (311744719 bytes/sec)
[Kenny-Gormans-MacBook-Pro:~] oracle% dd if=test2.dmp bs=8192 count=99999 of=test2.out
974+1 records in
974+1 records out
7983104 bytes transferred in 0.023256 secs (343273308 bytes/sec)
[Kenny-Gormans-MacBook-Pro:~] oracle% md5 test2.out
MD5 (test2.out) = 234bfb2d6a7001e9df98da3982e9aa29
[Kenny-Gormans-MacBook-Pro:~] oracle% md5 test1.out
MD5 (test1.out) = 7fd58a8b187d8023ab257f0f65e06e1c

This test shows the suitability of Oracle export files (dumps) for dedup techniques.