1.1.10.6 添加TEMP表空间文件,更新数据库特征表记录
SQL>alter
tablespace temp add tempfile ‘/dev/rora_temp01.dbf’ size 3500m;
SQL>conn
aidu/********
SQL> insert into test03(id,name) select id+(select count(1) from test03),name
from test03;
SQL> insert into test03(id,name) select id+(select count(1) from
test03),name from test03;
1751 rows created.
SQL> commit;
Commit complete.SQL> conn / as sysdba
Connected.
SQL> alter system checkpoint;
System altered.
SQL> a...
Link URL: http://djb1008.itpub.net/post/42280/518495