Moving Tables To New Tablespaces or Storage : Table space « Table « Oracle PL / SQL

1. Oracle PL / SQL
2. Table
3. Table space

Moving Tables To New Tablespaces or Storage

  
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>

   
  

Related examples in the same category