Oracle8i - "Object identifier is Primary Key " Statement

From: Agnes Sauerer <agnes.sauerer_at_pentasys.de>
Date: Thu, 22 Jul 1999 14:41:18 +0200
Message-ID: <7n7394$k5v$1@nixe.ISAR.net>

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 Received on Thu Jul 22 1999 - 07:41:18 CDT