SQL> alter table emp disable constraint pk;
Table altered.
SQL> alter table emp enable constraint pk
Table altered.
SQL> alter table emp enable constraint pk
2 using index tablespace appl_data02;
Table altered.
SQL> select tablespace_name from user_segments
Table altered.
SQL> select tablespace_name from user_segments
2 where segment_name = 'PK';
TABLESPACE_NAME
TABLESPACE_NAME
------------------------------
APPL_DATA02
SQL> select default_tablespace from user_users;
DEFAULT_TABLESPACE
SQL> select default_tablespace from user_users;
DEFAULT_TABLESPACE
------------------------------
APPL_DATA01
SQL>
SQL>
No comments:
Post a Comment