Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Tablespaces
"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message
news:ao1062$i4l71$1_at_ID-152732.news.dfncis.de...
> Caution ! In some cases, indexes on moved tables become invalid (check
> dba_indexes for them).
> In that case, You would have to rebuild them.
*All* indexes on a moved table become invalid because the rowid's of necessity change.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************Received on Thu Oct 10 2002 - 03:37:39 CDT