Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Create index automatically....
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),
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