Re: Create index automatically....

From: Multifarious <multifarious_at_nospamhome.com>
Date: Tue, 30 Nov 1999 04:20:28 GMT
Message-ID: <ggI04.2496$f5.21929@news1.rdc1.mb.home.com>

CREATE TABLE blahblah (
  id NUMBER

         CONSTRAINT pk_blahblah_id PRIMARY KEY
         USING INDEX TABLESPACE blah_idx
             INITRANS n
             MAXTRANS n
            PCTFREE n
        STORAGE ( INITIAL nK or M
                                NEXT nK or M
                                MINEXTENTS n
                                MAXEXTENTS n
                                PCTINCREASE n ),

  field2 VARCHAR2(n),
  field3 etc, etc,
  lastfield DATE
    );

Of course you can set whatever storage parameters are appropriate for you situation.

HTH
 M

"NJN" <ibm_97_at_yahoo.com> wrote in message news:38433DA6.10010B84_at_yahoo.com...
> 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.
>
>
Received on Mon Nov 29 1999 - 22:20:28 CST