CREATE OR REPLACE VIEW EXPORT_WEEKLY (TABLE_NAME) AS SELECT table_name FROM all_tables WHERE owner = 'SYSADM' AND NOT REGEXP_LIKE (table_name, '^PS(_)');
I then used Oracle datapump to export the tables listed in this view ..
parfile contentsexpdp username/password parfile=parfilename
DIRECTORY=dpump_dir1 DUMPFILE=dpump_dir1:dumpfile.dmp LOGFILE=dpump_dir1:logfile.log SCHEMAS=SCHEMANAME INCLUDE=TABLE:"IN (SELECT TABLE_NAME FROM EXPORT_WEEKLY)" CONTENT=DATA_ONLY



0 comments:
Post a Comment