Is so simple as useful
ALTER TABLE table_name MODIFY DEFAULT ATTRIBUTES TABLESPACE new_tablespace;
ALTER INDEX index_name MODIFY DEFAULT ATTRIBUTES TABLESPACE new_tablespace;
For example, new partitions for local indexes will be created in the new tablespace when you add new partitions on the table.
No comments:
Post a Comment