| Tables need to move from one Tablespace to another [message #602387] |
Tue, 03 December 2013 23:19  |
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
|
Senior Member |
|
|
Dear All,
Developer user has create some tables and assigned them to USERS tablespace. Now, we need to move it to its respective owners's tablespaces.
Kindly provide me the steps to change tablespace. Also let me know what are all do I need to execute (like rebuilt indexes etc).
Waiting for your kind response...
Regards,
Ishika
|
|
|
|
| Re: Tables need to move from one Tablespace to another [message #602389 is a reply to message #602387] |
Tue, 03 December 2013 23:24  |
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
|
Senior Member |
|
|
from OTN i got the scripts -
SQL> ALTER TABLE <TABLE NAME> MOVE TABLESPACE <TABLESPACE NAME>;
select 'alter index '||owner||'.'||index_name||' rebuild tablespace TO_TABLESPACE_NAME;' from all_indexes where owner='OWNERNAME';
While doing such activities, application team will get effected?
Regards,
Ishika
|
|
|
|
|
|
| Re: Tables need to move from one Tablespace to another [message #602398 is a reply to message #602389] |
Wed, 04 December 2013 01:13 |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
ishika_20 wrote on Wed, 04 December 2013 05:24from OTN i got the scripts -
SQL> ALTER TABLE <TABLE NAME> MOVE TABLESPACE <TABLESPACE NAME>;
select 'alter index '||owner||'.'||index_name||' rebuild tablespace TO_TABLESPACE_NAME;' from all_indexes where owner='OWNERNAME';
While doing such activities, application team will get effected?
Regards,
Ishika The table will be locked against DML during the move until you rebuild the indexes.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
