Reorganizing Schema

SQL> select table_name,tablespace_name from user_tables

2 where table_name='EMPLOYEES';

   

TABLE_NAME TABLESPACE_NAME

------------------------------ ------------------------------

EMPLOYEES EXAMPLE

   

SQL> alter table employees move tablespace users;

   

Table altered.

   

SQL> analyze table employees validate structure cascade;

analyze table employees validate structure cascade

*

ERROR at line 1: => 재구성 필요

ORA-01502: index 'HR.EMP_EMAIL_UK' or partition of such index is in unusable state

   

▣ 완료된 후 analyze 실행

SQL> analyze table employees validate structure cascade;

   

Table analyzed.