expdp wptb/wptb@DTV_D1 CONTENT=DATA_ONLY tables=TB_RESOURCETYPE, TB_RESOURCETYPEPARAMETER, TB_NODEDEFINITION,TB_MESSAGE,TB_MESSAGENODEDEFINITIONMAP, TB_NODEDEFINITIONPARENTMAP, TB_RESOURCEGROUP, TB_PROTECTIONKEY, TB_TEMPLATE, TB_TEMPLATEPROTECTIONKEYMAP ,TB_RESOURCEGROUPTEMPLATEMAP,TB_NODEDEFINITIONTEMPLATEMAP directory=TEST_DIR dumpfile=TB_DIRECTV_1.dmp logfile=junk.log QUERY= TB_RESOURCETYPE:\"WHERE CREATEDATE \> TO_DATE\(\'01/22/2008 19:00\', \'MM/DD/YYYY HH24:MI\'\)\", TB_RESOURCETYPEPARAMETER:\"WHERE CREATEDATE \> TO_DATE\(\'01/22/2008 19:00\', \'MM/DD/YYYY HH24:MI\'\)\", TB_NODEDEFINITION:\"WHERE CREATEDATE \> TO_DATE\(\'01/22/2008 19:00\', \'MM/DD/YYYY HH24:MI\'\)\",TB_MESSAGE:\"WHERE CREATEDATE \> TO_DATE\(\'01/22/2008 19:00\', \'MM/DD/YYYY HH24:MI\'\)\",TB_MESSAGENODEDEFINITIONMAP:\"WHERE CREATEDATE \> TO_DATE\(\'01/22/2008 19:00\', \'MM/DD/YYYY HH24:MI\'\)\",TB_NODEDEFINITIONPARENTMAP:\"WHERE CREATEDATE \> TO_DATE\(\'01/22/2008 19:00\', \'MM/DD/YYYY HH24:MI\'\)\"


GRANT CREATE ANY DIRECTORY TO wptb;
CREATE OR REPLACE DIRECTORY test_dir AS '/home/oracle/Daniels_DTV_DUMP/';
GRANT READ, WRITE ON DIRECTORY test_dir TO wptb;

impdp wptb/wptb@DTV_Q1 CONTENT=DATA_ONLY tables=TB_RESOURCETYPE, TB_RESOURCETYPEPARAMETER, TB_NODEDEFINITION,TB_MESSAGE,TB_MESSAGENODEDEFINITIONMAP, TB_NODEDEFINITIONPARENTMAP, TB_RESOURCEGROUP, TB_TEMPLATE, TB_PROTECTIONKEY, TB_TEMPLATEPROTECTIONKEYMAP ,TB_RESOURCEGROUPTEMPLATEMAP,TB_NODEDEFINITIONTEMPLATEMAP directory=TEST_DIR dumpfile=TB_DIRECTV_1.dmp

exec TEMPLATEBUILDERDIRECTV.BEFORE_UPGRADE;
exec TEMPLATEBUILDERDIRECTV.AFTER_UPGRADE;