Installing ORACLE XML DB

All posts relating to Oracle database administration.

Moderator: Tim...

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.
user8177
Member
 
Posts: 10
Joined: Thu Mar 08, 2012 6:40 pm

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
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 1 guest

cron