Re: HELP: Why object can not be created in Oracle SQL*PLUS 8.0.4.00?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 24 Nov 1999 23:18:48 +0100
Message-ID: <943482002.7251.0.pluto.d4ee154e@news.demon.nl>

The objects option is included with the enterprise edition only. Do a select * from v$option and you will see whether or not you have it installed, obviously you have Oracle Server (in Oracle 7 called Oracle Workgroup Server) and you don't have the object option.

Hth,

--
Sybrand Bakker, Oracle DBA
centtel.com <gcao_at_centtel.com> wrote in message news:383c4628_at_news.centtel.com...
> Hi,
> I want to create object in Oracle SQL*PLUS 8.0.4.00.
> and I have a CREATE TYPE system privilege.
> I write the following statement:
> create type ADDRESS_TY as object
> (street VARCHAR2(50),
> city VARCHAR2(25),
> state CHAR2(2),
> zip NUMBER);
>
> But I get the message "feature not enabled:objects",Why?
>
> Thanks
>
> Mark
>
>
>
>
Received on Wed Nov 24 1999 - 16:18:48 CST