sqlplus spool

sqlplus
SQL> set feedback off heading off term off;
SQL> set pages 0 trim on trims on lines 32767 long 999999;
SQL> set echo off;
SQL> spool PSDVIEW2.sql;
SQL> select 'GRANT SELECT ON DWMGRPRD.' || table_name || ' to PSDVIEW;'
 from DBA_tables WHERE OWNER = 'DWMGRPRD';  2
 


Spool off;
SELECT 'alter table '||TABLE_NAME||' enable constraint '||CONSTRAINT_NAME||';' FROM USER_CONSTRAINTS WHERE CONSTRAINT_TYPE='R'
SELECT 'alter table '||TABLE_NAME||' disable constraint '||CONSTRAINT_NAME||';' FROM USER_CONSTRAINTS WHERE CONSTRAINT_TYPE='R'
Select 'TRUNCATE TABLE '||OWNER||'.'||TABLE_NAME FROM DBA_TABLES WHERE OWNER='XXXX'