Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Tablespaces
sorry should have read Richard's reply first :(
-- 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 ****************************************** "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3da53c54$0$1294$ed9e5944_at_reading.news.pipex.net...Received on Thu Oct 10 2002 - 03:38:21 CDT
> "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
>
> ******************************************
>
>