ORA-02253

From: Rene Nyffenegger <renenyffenegger_at_my-deja.com>
Date: Tue, 19 Sep 2000 09:22:08 GMT
Message-ID: <8q7b7i$uu7$1@nnrp1.deja.com>

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. Received on Tue Sep 19 2000 - 04:22:08 CDT