Can I add XDB after db Created?

[KenEwald]

I created a database (using dbca) in 9.2.0.4 and didn't choose to include the xdb option. I have a developer that needs it. Is there a script I can run to add it after the fact?

Thanks in advance,

[rohitsn]

Hi,
1. Connect as sysdba and run the catqm.sql script.
Maintain a spool of the script running:
UNIX: $ORACLE_HOME/rdbms/admin subdirectory
WINDOWS: $ORACLE_HOME\rdbms\admin subdirectory
The catqm.sql script requires the following parameters be passed to it when run:
A. XDB user password
B. XDB user default tablespace
C. XDB user temporary tablespace
Therefore the syntax to run catqm.sql will be:
SQL> catqm.sql A B C

For Example:
SQL> set echo on
SQL> spool xdb_install.log
SQL>@?/rdbms/admin/catqm.sql XDB XDB TEMP

2. Check for any invalid XDB owned objects:
SQL> select count(*) from dba_objects where owner='XDB' and status='INVALID';
COUNT(*)
----------
0

3. Check DBA_REGISTRY for XDB status:
SQL> select comp_name, status, version from DBA_REGISTRY where comp_name='Oracle XML Database'
The results should indicate the correct version and patch in a valid status.


Regards
Rohit S Nirkhe,Oracle/Apps DBA
OCP 8i,9i
oracle-support@indiatimes.com

[KenEwald]

Thank you very much. You're certainly hard core Oracle.

Is there also a script to remove XDB?

[KenEwald]

What about 10g? Can you remove XDB without killing the basic functionality of this version?