Home » SQL & PL/SQL » SQL & PL/SQL » Error using Objects
Error using Objects [message #1301] Thu, 18 April 2002 11:43 Go to next message
Arti
Messages: 6
Registered: April 2002
Junior Member
I'm using Oracle 8.0, when I create any objetc such as Varray or User-defined data type it gives me ERROR -
"0RA - 00439 , FEATURE NOT ENABLED - OBJECTS."
Pls help me to overcome it..

Thanks,
Arti
Re: Error using Objects [message #1305 is a reply to message #1301] Thu, 18 April 2002 23:24 Go to previous messageGo to next message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
select parameter, value from v$option
WHERE UPPER(PARAMETER) = UPPER('Objects');

IT SHOULD BE TRUE .
Re: Error using Objects [message #1308 is a reply to message #1301] Fri, 19 April 2002 07:36 Go to previous message
Arti
Messages: 6
Registered: April 2002
Junior Member
I checked the value set in v$option fixed view, its set to FALSE, hence objetcs cant be created.Since it cannot be Updated , is there any other way I can create user defined objects?

Because of this error, I'm unable use any object related features of Oracle 8, so how do I fix it??
Please help out..

Thanks
Previous Topic: Query performance please Help!!!!!!
Next Topic: Nested Table problem(URGENT)
Goto Forum:
  


Current Time: Fri Mar 29 01:42:30 CDT 2024