This forum is currently locked. You can't register or post questions at this time. (read more)

Installing ORACLE XML DB

All posts relating to Oracle database administration.

Moderator: Tim...

user8177
Member
Posts: 10
Joined: Thu Mar 08, 2012 6:40 pm

Installing ORACLE XML DB

Postby user8177 » Tue Sep 11, 2012 6:10 pm

Hi Tim,

My imported completed with below errors..when i searched, it look like i don't have XML DB installed.

ORA-39083: Object type TABLE:"STEST_DEV2"."USER_MSG_OLD" failed to create with error:
ORA-44425: XML DB needs to be installed for creating an XMLType table or column
Failing sql is:


COMP_NAME STATUS VERSION
---------------------------------------- -------------------------------------------- ------------------------------
Oracle Database Catalog Views VALID 11.2.0.3.0
Oracle Database Packages and Types VALID 11.2.0.3.0


Not familiar with XML DB.. Can you explain me how to fix this error by installing XML DB? does it required downtime? please advise.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Installing ORACLE XML DB

Postby Tim... » Wed Sep 12, 2012 8:20 am

Hi.

Start up the DBCA, choose to modify the existing database and tick the XML DB option. That should install all XML DB code for you.

XML DB is a no cost option, so there is no additional licensing implication.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 6 guests

cron