set heading off ; set feedback off ; SPOOL ON.SQL;select 'alter table '||a.Table_Name||' move tablespace FSPTDATA;'from sys.all_tables awhere a.owner = 'FSPT'and a.tablespace_name <> 'FSPTDATA';SPOOL OFF;@ON.SQL;set heading off ; set feedback off ; SPOOL ON.SQL;select 'grant select,insert,delete,update on '||a.Table_Name||' to ptlinkman;' from sys.all_triggers a where a.owner = 'FUSHUN' and a.trigger_name like '%_PT';SPOOL OFF;@ON.SQL;set heading off ; set feedback off ; SPOOL ON.SQL;select dist...
批量生成sql并执行
最新推荐文章于 2024-01-29 10:19:52 发布