Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Objects feature not enabled

When I execute the following statement in Oracle 8

 create type student_name_ty as object
 (first_name varchar2(15),last_name varchar2(15));
I get the following error
ORA-00439: feature not enabled: Objects'
So, how can I enable the feature?

It is likely that you only have Standard Edition installed. You need to have Enterprise Edition installed to use user-defined datatypes. Make sure that you install EE instead of SE.

After that, Objects is an option that you can choose from the installer. If you are running EE and still get this error, bring down all Oracle software, fire up the Installer, and do a custom install of Objects.

For More Information


Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close