Re: Oracle8i - "Object identifier is Primary Key " Statement

Agnes

I would assume by looking at the messages that the PRIMARY KEY syntax came in 8.1, whereas the system generated syntax really reflects what was the default prior to 8.1, and therefore it works regardless of the syntax. In any case, try changing the COMPATIBLE parameter in your init.ora file to 8.1.0 and bounce the database to see if that removes the problem.

HTH. Pete

Agnes Sauerer wrote:

> Hi,
>
> I'm using Oracle8i, Release 8.1.5, SQL Plus Release 8.1.5 (really!!!)
> and have a problem with the "OBJECT IDENIFIER IS PRIMARY KEY" Statement.
>
> create TABLE Hotelgast_Objtab OF Gast_ty (Gast_id PRIMARY KEY) OBJECT
> IDENTIFIER is PRIMARY KEY;
>
> ERROR at line 1:
> ORA-00406: COMPATIBLE parameter needs to be 8.1.0.0.0 or greater
>
> But this statement is o.k.
> create TABLE Hotelgast_Objtab OF Gast_ty (Gast_id PRIMARY KEY) OBJECT
> IDENTIFIER is system generated;
>
> Table created.
>
> what is the problem?
>
> Thanks in advance!
>
> Agnes Sauerer

--
Regards

Pete

Received on Thu Jul 22 1999 - 11:26:33 CDT