Re: tablespace for prime key index

... primary key (columns) using index tablespace <tablespace_name> storage ...
etc

Hth,

--
Sybrand Bakker, Oracle DBA
David Zlotchenko <zlotchen_at_voyager.rtd.utk.edu> wrote in message news:82lvl4$33v$1_at_penn.dii.utk.edu...
> Can't figure out how to put table space name for the
> indexes that get created automatically for UNIQUE and PK
> constraints. Can somebody show an example for Oracle 8.0.6?
>
> I end up issuing two DDLs: one to create a table and
> then one to alter index rebuild tablespace. However,
> this works only for named constraints. I tend to name
> only constraints that will create large indexes. But
> I would like to keep all indexes in tablespace for indexes.
> One reason is that I have a fast but rather small disk
> allocated for the indxs tablespace.
>
> David.
>
> --
> --
> David Zlotchenko
> E-mail: zlotchen_at_cs.utk.edu
> WWW: http://www.oars.utk.edu/~zlotchen
Received on Wed Dec 08 1999 - 16:31:30 CST