Installing ORACLE XML DB

All posts relating to Oracle database administration.

Moderator: Tim...

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:

---------------------------------------- -------------------------------------------- ------------------------------
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID

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

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

Re: Installing ORACLE XML DB

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


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.


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:
My blog:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 1 guest