Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: I can't create OBJECT TYPE in sql*plus!!

Re: I can't create OBJECT TYPE in sql*plus!!

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/04
Message-ID: <952174977.22195.0.pluto.d4ee154e@news.demon.nl>#1/1

The objects option is available in the enterprise edition only.

Please do not crosspost this question (which BTW has been asked repeatedly and should be available at www.deja.com) to ALL oracle newsgroups.

Hth,

Sybrand Bakker, Oracle DBA

victor <lch_2_at_hotmail.com> wrote in message news:38C0F421.F0668ED8_at_hotmail.com...
> Hi everyone,
> I got a problem in creating object in sql*plus.
> Here is the CREATE TYPE statement that i type:
>
> CREATE TYPE address_type AS OBJECT(
> street varchar2(25),
> city varchar2(25),
> post_code varchar2(10),
> country varchar2(20))
> /
>
> However, an error message is displayed:
>
> 'feature not enable: Objects'
>
> I dont' know what's wrong with it. I am sure the code is correct, it is
> because it is so simple and I can create the object in my school oracle
> account. But just can't create it in my notebook.
>
> The copy of oracle I am using in my notebook is downloaded from the
> oracle webpage. Its version is Oracle8.05.
> Would anybody teach me how to deal with this problem?
>
> Thank you very much!
>
> Victor Lung
>
Received on Sat Mar 04 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US