系統環境: 1、操作系統:windows 2000 Server,機器內存128M 2、數據庫: Oracle 8i R2 (8.1.6) for NT 企業版 3、安裝路徑:C:/ORACLE
模擬現象:
先將數據庫設置為歸檔模式
SQL*Plus
--創建實驗表空間 create tablespace test datafile 'c:/test.ora' size 5M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED default storage (initial 128K next 1M pctincrease 0) /
--創建實驗用戶 drop user test cascade; create user test identified by test default tablespace test; grant connect,resource to test; conn test/test create table a(a number); insert into a values(1); insert into a select * from a; --反復插入,達到10萬條 commit;
拷貝test.ora為test1.ora文件 insert into a select * from a; --20萬條 commit;