在用户user2下建立与user1.your_table1相同的表结构,命名为your_table2; insert into your_table2 select * from user1.your_table1; 注意grant connect,resource to user2;
set linesize 400 set pagesize 0 spool c:\TableRebuild.sql select 'ALTER TABLE '||SEGMENT_NAME ||' MOVE TABLESPACE '' NOLOGGING;' FROM USER_SEGMENTS where TABLESPACE_NAME=''and SEGMENT_TYPE='TABLE'; select 'ALTER INDEX '||SEGMENT_NAME ||' REBUILD TABLESPACE '' FROM USER_SEGMENTS where TABLESPACE_NAME='' and SEGMENT_TYPE='INDEX'; spool off @c:\TableRebuild.sql
insert into your_table2 select * from user1.your_table1;
注意grant connect,resource to user2;
set pagesize 0
spool c:\TableRebuild.sql
select 'ALTER TABLE '||SEGMENT_NAME ||' MOVE TABLESPACE '' NOLOGGING;' FROM USER_SEGMENTS where TABLESPACE_NAME=''and SEGMENT_TYPE='TABLE';
select 'ALTER INDEX '||SEGMENT_NAME ||' REBUILD TABLESPACE '' FROM USER_SEGMENTS where TABLESPACE_NAME='' and SEGMENT_TYPE='INDEX';
spool off
@c:\TableRebuild.sql