Home » RDBMS Server » Server Administration » about creation of an object table under 8i
about creation of an object table under 8i [message #50721] Wed, 03 April 2002 07:43 Go to next message
smichi
Messages: 4
Registered: April 2002
Junior Member
Hello
I trayed to create an object table by the following statement :
create table person_objecttable of person_objecttype (id_person PRIMARY KEY )
Object id Primary Key
Of caurse ,person_objecttype is an object type ,and i have this error :
Ora-00406 param.compatible doit etre 8.1.0.0.0 ou plus
When I delete the second line " Object id Primary Key "
the table was created ,but i don't know why oracle 8i entreprise edition don't accept this althout in the object-relationnel feature developer guide there is example of this instruction .
Thank for your help
Re: about creation of an object table under 8i [message #50726 is a reply to message #50721] Wed, 03 April 2002 09:52 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
It is telling you that your COMPATIBLE parameter isn't set high enough. You need to set this in your initSID.ora file (compatible = "8.1.0") and restart it.
Previous Topic: Re: ocp *.* - dumps,braindumps,kits,cbt,tbt,sts......
Next Topic: Error INVALID Password file Urgent!!!
Goto Forum:
  


Current Time: Sun Sep 08 10:38:12 CDT 2024