Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: create type as object
Hi Robert,
The object option of Oracle only comes with enterprise edition. You probably have the standard (or what ever they call the 'non enterprise' edition), so you out of luck.
Mike
Roberto Diaz <rdiazmar_at_nova.es> wrote in message
news:slrn7rm1ei.vb.rdiazmar_at_localhost.localdomain...
> Hi!
>
> I'm running Oracle 8.5.0 server the demo version from Oracle site..
>
> I'm trying to create new types as objects..
>
> create type ADDRESS_TY as object
> (street VARCHAR2(50),
> city VARCHAR2(25),
> state CHAR(2),
> zip NUMBER);
> /
>
> I have this error:
>
> SQL> @ADDRESS_TY
> create type ADDRESS_TY as object
> *
> ERROR at line 1:
> ORA-00439: feature not enabled: Objects
>
>
> I dont know if this is a problem with my init.ora (I cant see anything
> related with objects).. or is a limitation of the demo..
>
> Please some help?
>
> P.D. please answer to my email address rdiazmar_at_nova.es i'm having
troubles
> with my news server.
>
> --
>
> Saludos
>
> Roberto Díaz <rdiazmar_at_nova.es>
> http://www.linuxfocus.org/developer/Roberto
Received on Sun Sep 05 1999 - 23:15:21 CDT