Yes, data and indexes should be put in seperate tablespaces.
In 8.1.x, you can use alter table xyz move tablespace new_tbs for tables and alter index xyz_pk rebuild tablespace new_tbs for indexes.
|
Results 1 to 3 of 3
Thread: change tablespace for objectsThreaded View
|
Click Here to Expand Forum to Full Width |