Home » RDBMS Server » Server Administration » Is CRETAE TYPE command supported in Oracle8.0.5 ???
Is CRETAE TYPE command supported in Oracle8.0.5 ??? [message #371023] Thu, 10 August 2000 05:51 Go to next message
Raj
Messages: 411
Registered: November 1998
Senior Member
Is CRETAE TYPE command supported in Oracle8.0.5 ???
I get an error ora-00439 Feature not enabled.
How do I fix it???
Re: Is CRETAE TYPE command supported in Oracle8.0.5 ??? [message #371031 is a reply to message #371023] Mon, 14 August 2000 15:41 Go to previous messageGo to next message
akkerend
Messages: 1
Registered: August 2000
Junior Member
CREATE TYPE is available only if the Oracle objects option is installed on your database server.
Re: Is CRETAE TYPE command supported in Oracle8.0.5 ??? [message #371034 is a reply to message #371023] Tue, 15 August 2000 12:41 Go to previous messageGo to next message
-sven
Messages: 11
Registered: August 2000
Junior Member
Yes it is supported if the correct options are installed. Query the V$OPTION view to determine whether or not the Objects parameter is TRUE or FALSE.
Re: Is CRETAE TYPE command supported in Oracle8.0.5 ??? [message #371038 is a reply to message #371034] Wed, 16 August 2000 03:18 Go to previous message
Raj
Messages: 411
Registered: November 1998
Senior Member
Sven and Akkerend :Thank's a Lot !! for your help!!!!
Previous Topic: Help with renameing tables from plsql
Next Topic: Re: Commit after certain # of rows inserted
Goto Forum:
  


Current Time: Fri Mar 29 09:54:19 CDT 2024