Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

About creation of an object table under 8i

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
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
 
Ora-00406 means that you are running with a compatible parameter less than the required 8.1.0.0.0. This is specified in your init{sid}.ora parameter file. Please check this file and see what the parameter is set to. You will have to change it, shutdown the database and restart in order to have the change take effect.

Even if you are using 8i Enterprise Edition, Oracle won't let you use features of 8i unless compatible is set right. Oracle assumes that, if it is set to some earlier version of Oracle, you have intentionally made the decision to run at an earlier release level.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top