Re: Create index automatically....

From: <www_dba_at_my-deja.com>
Date: Tue, 30 Nov 1999 05:44:04 GMT
Message-ID: <81vo74$q49$1@nnrp1.deja.com>

HI,

Try this:

CREATE TABLE BlahBlah
( BiliBlah NUMBER CONSTRAINT BiliBlahla

                    PRIMARY KEY
                    USING INDEX TABLESPACE BiliBlahBlah,

......

Hope this work.

Wesley.

In article <38433DA6.10010B84_at_yahoo.com>, NJN <ibm_97_at_yahoo.com> wrote:
> Oracle 8i for Solaris.
>
> Try to create a table(in tablespace A) with defining one column as PK,
> but I want the PK index be created inside the tablespace which is
> different from the tablespace A.
>
> In Oracle 8, is it possible that do this using 'Create table....'
> command?
>
> Thanks a lot! pls also email me.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 29 1999 - 23:44:04 CST