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: 63911
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: translator.zip
Next Topic: Weight of data types
Goto Forum:

Current Time: Sun Oct 23 10:13:51 CDT 2016

Total time taken to generate the page: 0.06400 seconds