| Concern about moving tables [message #302636] |
Tue, 26 February 2008 07:11  |
Muddassar
Messages: 28
Registered: March 2007
|
Junior Member |
|
|
I need to move some tables to another tablespace which i can do as:
ALTER TABLE <table_name> MOVE TABLESPACE <tablespace_name>
I know that i need to rebuild the indexes on the tables i move,after the move opertion.
I am concerned about the triggers and functions (and also any other objects)that refers to these tables. Will all of them become invalid even if none of them are executed during the move operation. Or only the objects which gets executed during the move operation will become invalid?
Thanks & Regards
Muddassar
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
