SELECT 'DROP TABLE ' || OWNER || '.' ||TABLE_NAME|| ' CASCADE CONSTRAINT; ' 
FROM dba_tables 
WHERE OWNER = 'PONTO';
--WHERE OWNER IN ('CAUSO', 'CAUSU', 'TELEMAT', 'USUTCP01', 'USUTCP02', 'USUTCP03');

SELECT 'DROP ' ||OBJECT_TYPE|| ' ' || OWNER || '.' || OBJECT_NAME || ';'
FROM dba_objects WHERE object_type NOT IN ('TABLE','inDEX','DATABASE LinK')
AND OWNER = 'PONTO';
--AND OWNER IN ('CAUSO', 'CAUSU', 'TELEMAT', 'USUTCP01', 'USUTCP02', 'USUTCP03');

--'SYNONYM') 


'PONTO', 'CAUSO', 'CAUSU', 'TELEMAT', 'USUTCP01', 'USUTCP02', 'USUTCP03'

CREATE OR REPLACE DIRECTORY DBATIVIT AS '/export/home/oracle/TAS000001433019';

expdp DIRECTORY=DBATIVIT DUMPFILE=FULL_ZDBDEV_20121002.DMP LOGFILE=FULL_ZDBDEV_20121002.LOG FULL=Y

impdp DIRECTORY=TIVIT DUMPFILE=catracAS.dmp LOGFILE=import_catracAS.log FULL=
impdp DIRECTORY=TIVIT DUMPFILE=ponto.dmp LOGFILE=import_ponto.log FULL=Y

hostgator