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
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
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: 64139
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.

Regards
Michel
Previous Topic: translator.zip
Next Topic: Weight of data types
Goto Forum:
  


Current Time: Thu Dec 08 08:43:48 CST 2016

Total time taken to generate the page: 0.10315 seconds