SET PAGES 0
SPOOL c:\del.SQL
SELECT 'DROP TABLE SCHeMA.'||TABLE_NAME||';' FROM ALL_TABLES
WHERE OWNER = 'XXXXXX';
SELECT 'DROP TABLE SCHeNA.'||TABLE_NAME||';' FROM ALL_TABLES
WHERE OWNER = 'XXXXXX';
spool off
@c:\del.sql
imp system/PPPPPP@name
file=c:\xxx.dmp log=imp.log fromuser=frusr touser=ZZsrv
imp system/PPPPPP@name
file=c:\xxx.dmp log=imp.log fromuser=frusr touser=ZZtran