Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Tablespaces
You can always check dba_indexes.status . If it is not 'VALID', then rebuild
them.
I do not know if _all_ concerned indexes become invalid (that is:
'UNUSUABLE' e.g.),
but that is why I always check data dictionary, and getting next actions
from it.
Jan
"s Lehaire" <s.lehaire_at_meilleuregestion.com> schrieb im Newsbeitrag
news:ao12ku$qcb$1_at_reader1.imaginet.fr...
> ok that's great thanks!
>
> But if my indexes are or an other table sapce is there any problems ?
> Must I rebuild them ?
>
> "Steve Ashmore" <sashmore_at_neonramp.com> a écrit dans le message de news:
> uq81gcn1mph33c_at_corp.supernews.com...
> > Assuming you are using oracle 8i or 9i and the table doesn't have
> > any LONG or LONG Raw fields you can use
> >
> > alter table move mytable NEWTABLESPACE;
> >
> > Note if the table has any indexes you will need to rebuild them after
the
> > move.
> > (Check the SQL REF guide for the complete syntax)
> >
> >
> > Stephen C. Ashmore
> > Brainbench MVP for Oracle Administration
> > http://www.brainbench.com
> >
> > Author of: 'So You Want to be an Oracle DBA?'
> >
> >
> >
> > "s Lehaire" <s.lehaire_at_meilleuregestion.com> wrote in message
> > news:ao0tb7$p3p$1_at_reader1.imaginet.fr...
> > > Hi,
> > > How can I move a table on a new tablespace ?
> > > I know that I can move a index on an other tablespace with this
command
> :
> > > alter index MYINDX rebuild tablespace MYTABLESPACE.
> > >
> > > I have some tables on the tablespace system and I want to move them on
> my
> > > tablespace.
> > > To day for that I use a borring method:
> > > Create the same table with a new name
> > > copy the data from the old to the new, drop the old and rename the new
> > with
> > > the old name (is my indexes are ok after this?).
> > > So if there's a method like the alter index command it would be great.
> > >
> > > Thx for helping me
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
Received on Wed Oct 09 2002 - 07:12:30 CDT