CREATE TABLE STATEMENT

[vrudenko]

Hi,

I read from Metalink forum this syntax of CREATE TABLE statement:

CREATE TABLE PR_DESC (
PR_DESC_ID NUMBER(10)
CONSTRAINT PR_DESC_PK PRIMARY KEY
USING INDEX
(CREATE INDEX PR_DESC_PK_IDX
ON PR_DESC (PR_DESC_ID)
TABLESPACE INDX
STORAGE ( INITIAL 128K NEXT 128K PCTINCREASE 0 )),
PR_NO CHAR(4)
CONSTRAINT PR_DESC_PR_NO_NN NOT NULL
CONSTRAINT PR_DESC_UQ UNIQUE
USING INDEX
(CREATE INDEX PR_DESC_UQ_IDX
ON PR_DESC (PR_NO)
TABLESPACE INDX
STORAGE ( INITIAL 128K NEXT 128K PCTINCREASE 0 )),
PR_D VARCHAR2(100)
)
TABLESPACE DATA
STORAGE (INITIAL 1024K NEXT 1024K PCTINCREASE 0 )
/

But, when I wanted to create the table I got the error:

ERROR at line 5:
ORA-00907: missing right parenthesis

Any suggestions?

Thank you

 

[sem]

You may specify index name (full CREATE INDEX statement) in CREATE TABLE statement only on 9i.

 

[vrudenko]

Thank you Sem