Mega Code Archive
Moving Tables To New Tablespaces or Storage
<![CDATA[
SQL>
SQL> create table EMP(
2 employee_id number(9),
3 first_name varchar2(15),
4 last_name varchar2(20),
5 email varchar2(25),
6 constraint pk_people primary key (employee_id)
7 );
Table created.
SQL>
SQL>
SQL>
SQL> select tablespace_name, table_name
2 from user_tables
3 where table_name in ('EMP', 'DEPT')
4 order by 1, 2;
TABLESPACE_NAME TABLE_NAME
------------------------------ ------------------------------
SYSTEM EMP
SQL>
SQL>
SQL> select segment_name, tablespace_name
2 from user_segments
3 where segment_name = 'EMP';
SEGMENT_NAME TABLESPACE_NAME
--------------------------------------------------------------------------------- ------------------------------
EMP SYSTEM
SQL>
SQL> alter table emp move
2 tablespace users;
Table altered.
SQL>
SQL> select segment_name, tablespace_name
2 from user_segments
3 where segment_name = 'EMP';
SEGMENT_NAME TABLESPACE_NAME
--------------------------------------------------------------------------------- ------------------------------
EMP USERS
SQL>
SQL> drop table EMP;
Table dropped.
SQL>
SQL>
]]>