操作步骤:
1、设置数据库为归档模式(Archivelog)模式
<span style="font-family:Microsoft YaHei;">startup mount;
alter database archivelog;
alter database open;</span>
2、建立测试表空间及测试表,插入测试数据
<span style="font-family:Microsoft YaHei;">SQL> create tablespace test_data datafile '/export/app/oradata/ORCL/datafile/test_data.dbf' size 200M;
Tablespace created.</span><pre class="sql" name="code"><span style="font-family:Microsoft YaHei;">SQL> create table cour(cn number,cname varchar2(20)) tablespace test_data;
Table created.</span>
<span style="font-family: