2010年
-
编辑 删除
移动表空间的脚本
Remark Set SQL*Plus variables to manipulate outputset feedback off heading off verify off trimspool offset pagesize 0 linesize 200set sqlterminator '/'Remark Set SQL*Plus user variables used in this scriptdefine movetablespace = 'movetbs.sql'define usrlist = '''SCOTT'',''ESYS'''prompt *** Spooling to &movetablespace.Remark 创建移动表空间的脚本spool &movetablespaceSELECT 'ALTER TABLE ' || A.OWNER || '.' || A.TABLE_NAME ||' MOVE TABLESPACE ' || B.DEFAULT_TABLESPACE || ';' AS CMDFROM (SELEC
