ALTER TABLE FINANCE_E .BD_CUST MOVE TABLESPACE E _DATA;
SELECT 'alter table '||' '|| ' finance_e .' ||OBJECT_NAME ||' move tablespace ep _data;'
FROM (select OBJECT_NAME from dba_objects where object_type='TABLE'and wner='FINANCE_E ' ) ;
alter index e .PK_BD_SECOND_GROUP_HHPN rebuild tablespace E _Sindx;
SELECT 'alter index '||' '|| ' FINANCE_E .' ||OBJECT_NAME ||' rebuild tablespace e _data;'
FROM (select OBJECT_NAME from dba_objects where object_type='INDEX'and wner='FINANCE_E ' ) ;
SELECT 'alter index FINANCE_E .' ||OBJECT_NAME ||' rebuild tablespace e _data;'
FROM (select OBJECT_NAME from dba_objects where object_type='INDEX'and wner='FINANCE_E ) ;
SELECT 'alter index C .' ||OBJECT_NAME ||' rebuild tablespace indx;'
FROM (select OBJECT_NAME from dba_objects where object_type='INDEX'and wner='C ' ) ;
SELECT 'alter table '||' '|| ' finance_e .' ||OBJECT_NAME ||' move tablespace ep _data;'
FROM (select OBJECT_NAME from dba_objects where object_type='TABLE'and wner='FINANCE_E ' ) ;
alter index e .PK_BD_SECOND_GROUP_HHPN rebuild tablespace E _Sindx;
SELECT 'alter index '||' '|| ' FINANCE_E .' ||OBJECT_NAME ||' rebuild tablespace e _data;'
FROM (select OBJECT_NAME from dba_objects where object_type='INDEX'and wner='FINANCE_E ' ) ;
SELECT 'alter index FINANCE_E .' ||OBJECT_NAME ||' rebuild tablespace e _data;'
FROM (select OBJECT_NAME from dba_objects where object_type='INDEX'and wner='FINANCE_E ) ;
SELECT 'alter index C .' ||OBJECT_NAME ||' rebuild tablespace indx;'
FROM (select OBJECT_NAME from dba_objects where object_type='INDEX'and wner='C ' ) ;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12137615/viewspace-539813/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
