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'
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'
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29551564/viewspace-2126340/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
