Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: AA:Why the Object can not created in Oracle SQL*PLUS 8.0.4.00 ?
You haven't install the objects option when you installed the software
Gary Waldrom
Amonra Insight Ltd.
Makers of Q-file IT Quick Reference Guides
http://www.q-file.com
-----Original Message-----
From: centtel.com [mailto:gcao_at_centtel.com]
Posted At: 24 November 1999 18:51
Posted To: server
Conversation: Why the Object can not created in Oracle SQL*PLUS
8.0.4.00?
Subject: AA:Why the Object can not created in Oracle SQL*PLUS 8.0.4.00?
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 - 13:03:48 CST