Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace in Index
No,
I suggest you use some tools to generate your DROP INDEX / CREATE INDEX
syntax for you
you can download dbartisan at www.embarcadero.com
In a windows interface you edit your index or whatever object with a mouse
click and it
generate the sql for you.
you can also preview the sql generated before running it
Fred
Leszek Taratuta <lecho_at_abg.com.pl> wrote in article
<7tsf91$1oh8$1_at_news.ipartners.pl>...
> Hi,
> I would like to change a tablespace for created index. ALTER INDEX do not
> change the tablespace. DROP INDEX and CREATE INDEX is too complex.
> Does anybody know another solution of my problem ?
>
> LEU
>
>
>
>
Received on Mon Oct 11 1999 - 08:36:41 CDT