Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Tablespaces
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 - 06:26:08 CDT