Re: moving objects between tablespaces

  • From: Maxim Demenko <mdemenko@xxxxxxxxx>
  • To: don@xxxxxxxxx
  • Date: Fri, 23 Mar 2007 00:39:46 +0100

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

--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2007