OBJECT's option

[badrinathn]

Hi,
I have installed oracle 8.1.7 EE on the NT server. When I invoke sqlplus I get

Oracle 8I EE Release 8.1.7.0.0. - production
With the Partitioning option
Jserver Release 8.1.7.0.0- Production


However, I want to define a object type using
create type ......AS object.

It does not allow me to do so as I don't have the OBJECT option installed with sqlplus.

Is there any way just to install the object option on to the sqlplus with out making any changes to all the other files like (tnsnames etc);

Badrinath

[gsprince]

Hi:

You should be able to install most of the options without affecting other installed components, using the installer.

But before that, check the v$option whether the OBJECT option is really installed or not.

[Knarayan]

You have to set the parameter compatible=8.1.7
in your initsid.ora file for the 8i parameters to take effect.

Hope this helps

[badrinathn]

Hi,
Thanks for the same.

However, in v$options ,
I can see that "options" are true and
In init.ora, I have made the compatable=8.1.7 (it was 8.1.0)

Still I don't see the "options" when I invoke the sqlplus
Badrinath

[badrinathn]

I have also restarted the database, but don't get the object -option
Badrinath

[gsprince]

I don't think it will be displayed (banner) when you invoke SQL*Plus. (Currently I am not working on Oracle EE).

It might already have been there. Check whether there is a possible syntax error or privilege problems in creating the object.

Also, I don't think its necessary to have the compatibe level set to 8.1.7 for OBJECT option to work. I guess, even the 8.1.5 compatibility will be fine, though the highest comaptibility is recommended for taking advantage of the new features.