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
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
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.