Export using select option

Export using select option

expdp system/carrier@traxmisu schemas=ODB INCLUDE=TABLE,VIEW,PACKAGE,PROCEDURE,INDEX:"LIKE'MWH_%'" estimate_only=y

expdp system/carrier@traxmisu schemas=ODB INCLUDE=TABLE,VIEW,PACKAGE,PROCEDURE,INDEX:"IN (select object_Name from dba_objects where object_name like 'MWH%')" estimate_only=y

select object_Name from dba_objects where object_name like 'MWH%'

expdp DADM/passwd DIRECTORY=DMP_DIR SCHEMAS=DADM DUMPFILE=dadm_data.dmp

CONTENT=DATA_ONLY include=TABLE:"IN (SELECT tbl_name FROM list_of_tables)"

expdp system/carrier@traxmisu schemas=ODB INCLUDE=TABLE:"IN\(select object_Name from dba_objects where object_name like'MWH%'\)" estimate_only=y

expdp system/carrier@traxmisu schemas=ODB INCLUDE=TABLE:"LIKE'MWH_%'" directory=EXPORT_DIR1 dumpfile=TRAXMISU_MWHT.dmp logfile=TRAXMISU_MWHT.log

impdp system/carrier@dlyfrmut schemas=ODB directory=EXPORT dumpfile=DLYFRMUT_MWHT.dmp logfile=DLYFRMUT_MWHT.log

expdp system/carrier@traxmisu schemas=ODB INCLUDE=PACKAGE:"LIKE'MWH_%'" estimate_only=y

impdp system/carrier@dlyfrmut schemas=ODB directory=EXPORT dumpfile=TRAXMISU_MWHT.dmp logfile=DLYFRMUT_IMP.log TABLE_EXISTS_ACTION=REPLACE