Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: moving objects between tablespaces

Re: moving objects between tablespaces

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 23 Mar 2007 00:39:46 +0100
Message-ID: <460313C2.2000402@gmail.com>


Don Seiler schrieb:
> You will have to rebuild those indexes and probably recompile any
> depended PL/SQL objects (triggers, procedures, etc). It won't move
> the indexes and no you don't have to move them if you don't want to.
>

Dependent plsql objects (including triggers and procedures) become not invalidated after alter table move.
Best regards

Maxim

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 22 2007 - 18:39:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US