[oracle@racserver1 data_pump]$ expdp MYSCHEMA/MYSCHEMA directory=MYDB_DMP_DIR dumpfile=XDBL_imageIsDOJ_126567rec_schemaMYSCHEMA.dmp tables=\(MY_TABLE\) QUERY=MYSCHEMA.MY_TABLE:'"where ID = 341"'
[oracle@racserver1 data_pump]$ expdp MYSCHEMA/MYSCHEMA directory=MYDB_DMP_DIR dumpfile=XDBL_imageIsDOJ_126567rec_schemaMYSCHEMA.dmp tables=\(MY_TABLE\) QUERY=MYSCHEMA.MY_TABLE:\"where ID \= \'341\'\"
SQL> create directory ENC_EXPDP_DIR as '/u01/oracle/dump_file/myapp/encryption_expdp';
[oracle@racserver1 encryption_expdp]$ expdp MYAPP/MYAPP directory=ENC_EXPDP_DIR tables=MY_TABLE; ・ ・ ・ Job "MYAPP"."SYS_EXPORT_TABLE_01" successfully completed at 12:14:38
[oracle@racserver1 encryption_expdp]$ expdp MYAPP/MYAPP directory=ENC_EXPDP_DIR dumpfile=myapp_2.0_some_of_p100k_and_nate2000_data.dmp tables=MY_TABLE content=data_only;
[oracle@racserver1 encryption_expdp]$ expdp MYAPP/MYAPP directory=ENC_EXPDP_DIR dumpfile=myapp_2.0_some_of_p100k_and_nate2000_data.dmp tables=MY_TABLE content=metadata_only;
[oracle@racserver1 encryption_expdp]$ impdp MYAPP/MYAPP directory=ENC_EXPDP_DIR dumpfile=expdat.dmp tables=MY_TABLE CONTENT=data_only remap_schema=MYAPP:SHISHIMARU
transform=OID:n