Wednesday, June 1, 2011

change default table or index tablespace

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.