Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: moving objects between tablespaces
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-lReceived on Thu Mar 22 2007 - 18:39:46 CDT
![]() |
![]() |