SQL> desc dba_data_files;
Name Null Type
----------------------------------------------------------------- -------- --------------------------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
ONLINE_STATUS VARCHAR2(7)
SQL> col file_name for a40
SQL> col tablespace_name for a15
SQL> select file_name,tablespace_name,status from dba_data_files where tablespace_name like '%TEST_T%';
FILE_NAME TABLESPACE_NAME STATUS
---------------------------------------- --------------- ------------------
/home/oracle/oracle/oradata/mdsp/test_ta TEST_TAB AVAILABLE
b_r.dbf
/home/oracle/oracle/oradata/mdsp/test_ta TEST_TAB AVAILABLE
b1.dbf
SQL> alter tablespace test_tab online;
Tablespace altered.
SQL> select file_name,tablespace_name,status from dba_data_files where tablespace_name like '%TEST_T%';
FILE_NAME TABLESPACE_NAME STATUS
---------------------------------------- --------------- ------------------
/home/oracle/oracle/oradata/mdsp/test_ta TEST_TAB AVAILABLE
b_r.dbf
/home/oracle/oracle/oradata/mdsp/test_ta TEST_TAB AVAILABLE
b1.dbf
SQL> select tablespace_name,status,contents from dba_tablespaces where tablespace_name like '%TEST_T%';
TABLESPACE_NAME STATUS CONTENTS
--------------- ------------------ ------------------
TEST_TEMP ONLINE TEMPORARY
TEST_TAB ONLINE PERMANENT
00027_2通过数据库表文件移动
适用于移动系统表空间；
SQL> shutdown immediate
SQL> startup mount
SQL> host cp /home/oracle/oracle/oradata/mdsp/system01.dbf /home/oracle/oracle/oradata/mdsp/system02.dbf
SQL> alter database rename file '/home/oracle/oracle/oradata/mdsp/system01.dbf' to '/home/oracle/oracle/oradata/mdsp/system02.dbf'