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.
Saturday, 3 February 2007
Oracle 10g Moving Data across tablespaces
Moving a table named my_table to a new tablespace named dest_data is a new feature of Oracle 10g and can be accomplished using the following command in SQLPlus:
No comments:
Post a Comment
I have had so many good people trying to promote various community oriented sites through here. Therefore all comments will first have to come through me... so I get a chance to learn about the interesting sites before you do ...