SQL> alter table my_table move tablespace my_data;Moving an index to a different table space is performed as follows :
SQL>alter index my_index rebuild tablespace my_data;
All things relative to everyday programming and DBA practices, This blog will not give you the ET staff, just little remindings about how things work. Subjects are relative to databases, programming, Linux, Windows and ... you name it. I used to have a notepad onto which I put down anything I thought I might need again. Hopefully this is going to be as good as the paper with the added value of being able to paste from.
SQL> alter table my_table move tablespace my_data;Moving an index to a different table space is performed as follows :
SQL>alter index my_index rebuild tablespace my_data;
No comments :
Post a Comment