Re: ORA-02253

From: Rene Nyffenegger <renenyffenegger_at_my-deja.com>
Date: Tue, 19 Sep 2000 09:34:17 GMT
Message-ID: <8q7buo$vjb$1@nnrp1.deja.com>

HM,

Seeing no forest because of the trees.... I should have used the word REFERENCES instead of REFERNECES .... May be a syntax highlighter does it...

Rene

> Hi
> Trying to create two tables:
>
> CREATE TABLE PR_NUMBER (
> PR_NUMBER_ID NUMBER CONSTRAINT PK_PR_NUMBER PRIMARY KEY,
> RAW_PR_NUMBER CHAR ( 6),
> HS CHAR ( 2),
> VALID_FROM DATE NOT NULL,
> MODEL_CODE VARCHAR2( 10),
> PROCESSING_CODE NUMBER,
> CONSTRAINT UQ_PR_NUMBER UNIQUE (RAW_PR_NUMBER, VALID_FROM,
> MODEL_CODE)
> )
> TABLESPACE USERS;
>
> CREATE PUBLIC SYNONYM PR_NUMBER FOR PR_NUMBER;
>
> CREATE TABLE TEXT_PR_NUMBER (
> ID CONSTRAINT FK_PN_TEXT_PN REFERNECES PR_NUMBER
> (PR_NUMBER_ID),
> TEXT VARCHAR2(999)
> )
> TABLESPACE USERS;
>
> CREATE PUBLIC SYNONYM TEXT_PR_NUMBER FOR TEXT_PR_NUMBER;
>
> I get an ORA-02253 at the 2nd table (text_pr_number) for the
> column ID.
>
> Why is that?
>
> Rene
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 19 2000 - 04:34:17 CDT