sql> spool on
sql> spool c:\a.txt;
sql>select 'ALTER TABLE CJH.'||table_name||' MOVE TABLESPACE YZDCQ ' from user_all_tables
sql> spool off
修改索引:select 'ALTER INDEX YZD7.'||INDEX_NAME||' REBUILD TABLESPACE YZD7; ' from user_indexes
copy a.txt到命令行执行
批量生成sequence:
SELECT 'CREATE SEQUENCE SEQ_'|| table_name|| ' START WITH 100 MAXVALUE 999999999999999999999999999 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;'
FROM user_all_tables
注:CJH是用户 user_all_tables当前连接用户下的所有表及相关情况