select b.name,a.value/1024 from v$mystat a,v$statname b
where a.statistic# = b.statistic#
and b.name='redo size';
where a.statistic# = b.statistic#
and b.name='redo size';
begin
insert /*+append nologging*/ into t1 select * from t1 where rownum <=10000;
end loop;
commit;
end;
/
begin
for i in 1..10000 loop
insert /*+append nologging*/ into t1 values(i,i);
end loop;
commit;
end;
/
for i in 1..10000 loop
insert /*+append nologging*/ into t1 values(i,i);
end loop;
commit;
end;
/
insert into t1 select * from t1 where rownum <=10000;
SQL> alter tablespace data01 read only;
Tablespace altered.
SQL> alter tablespace data01 offline ;
Tablespace altered.
SQL> alter tablespace data01 rename datafile '/u01/app/oracle/oradata/oradb3/data01.dbf' to '/u01/app/oracle/oradata/oradb4/data01.dbf';
Tablespace altered.
SQL> alter tablespace data01 online;
Tablespace altered.
SQL>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23382569/viewspace-761082/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
表空间传输
下一篇：
oracle取随机数
请登录后发表评论
登录
全部评论
