00027_1通过表空间移动
SQL> col tablespace_name for a30
SQL> set line 120
SQL> desc dba_tablespaces;
Name Null Type
----------------------------------------------------------------- -------- --------------------------------------------
TABLESPACE_NAME NOT NULL VARCHAR2(30)
BLOCK_SIZE NOT NULL NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NOT NULL NUMBER
MAX_EXTENTS NUMBER
MAX_SIZE NUMBER
PCT_INCREASE NUMBER
MIN_EXTLEN NUMBER
STATUS VARCHAR2(9)
CONTENTS VARCHAR2(9)
LOGGING VARCHAR2(9)
FORCE_LOGGING VARCHAR2(3)
EXTENT_MANAGEMENT VARCHAR2(10)
ALLOCATION_TYPE VARCHAR2(9)
PLUGGED_IN VARCHAR2(3)
SEGMENT_SPACE_MANAGEMENT VARCHAR2(6)
DEF_TAB_COMPRESSION VARCHAR2(8)
RETENTION VARCHAR2(11)
BIGFILE VARCHAR2(3)
PREDICATE_eva lUATION VARCHAR2(7)
ENCRYPTED VARCHAR2(3)
COMPRESS_FOR VARCHAR2(12)
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
SQL> alter tablespace test_tab offline;
Tablespace altered.
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 OFFLINE PERMANENT
SQL> alter tablespace test_tab rename datafile '/home/oracle/oracle/orad