How to tell if XML option is installed in the db?

2003-09-11 Thread Murali_Pavuloori/Claritas
Gurus: How can we find out if XML is installed in DB? I looked @ the v$option and it doesnot say. I have queried the dba_users for XDB user...is this the correct way? Please help. Thanks in advance. Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET:

Re: How to tell if XML option is installed in the db?

2003-09-11 Thread Govindan K
AFAIK, XDB is created by dbca if you use 9iRel2 ; If you migrate 9iRel1 or 8.1.7.x to 9iRel2 then it is not created. You need to run a set of scripts. There is some reference on Metalink about this. Search on XDB; In 8.1.6.3 you need to edit and run $ORACLE_HOME//xml/OracleXSU12/libls -l