Home » RDBMS Server » Server Administration » Concern about moving tables (Oracle 9i + Unix)
Concern about moving tables [message #302636] Tue, 26 February 2008 07:11 Go to next message
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
Re: Concern about moving tables [message #302640 is a reply to message #302636] Tue, 26 February 2008 07:28 Go to previous message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No procedural object will invalidated by a move.
They don't care where the objects are stored.

Previous Topic: patch-set released
Next Topic: how to see the list of installed patches
Goto Forum:

Current Time: Wed Aug 23 03:17:31 CDT 2017

Total time taken to generate the page: 0.01638 seconds