Oracle学习（十七）之还原表空间管理

一、还原表空间管理
1.查看还原表空间
                SQL> select FILE_NAME,status,TABLESPACE_NAME from dba_data_files;

                FILE_NAME                                          STATUS    TABLESPACE_NAME
               -------------------------------------------------- --------- ---------------
               F:\APP\LEE\ORADATA\D547001\USERS01.DBF             AVAILABLE USERS
               F:\APP\LEE\ORADATA\D547001\UNDOTBS01.DBF           AVAILABLE UNDOEB8
               F:\APP\LEE\ORADATA\D547001\SYSAUX01.DBF            AVAILABLE SYSAUX
               F:\APP\LEE\ORADATA\D547001\SYSTEM01.DBF            AVAILABLE SYSTEM

2.增加还原表空间及数据文件
               SQL> CREATE UNDO TABLESPACE undo1
                 2  datafile 'e:\ora11g\D547001\undotest.dbf'
                 3  size 100M
                 4  autoextend on;

               表空间已创建。

3.还原表空间改名
               SQL> alter tablesp