René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Oracle XML DB installation

If XML DB is installed can be verified through dba_registry:
SQL> select comp_name "Component" from dba_registry;
Component
------------------------------------------------------
Oracle Database Catalog Views
Oracle Database Packages and Types
As can be seen, XML DB is not installed.
XML DB can be installed with the database configuration assistant (dbca) or by calling the catqm.sql script. catqm stands for catalog script for sQl xMl management.
In the following, I demonstrate how to use the script.
This script creates
When the script is called, it must be given (in the following order):
It seems that it is advisable to have a tablespace for XML DB (see re-installing XML DB below).
create tablespace xmldb_ts 
datafile 'd:\oracle\databases\ora10\xmldb_ts.dbf' size 10M autoextend on maxsize unlimited
extent management local uniform size 1M;
Also, the pool size must be configured sufficiently large:
SQL> alter system set shared_pool_size = 80M scope=spfile;
If the shared pool size was altered, the database has to be bounced.
The script must be run as sys.
SQL> set feedback off
SQL> @?/rdbms/admin/catqm xml_password xmldb_ts temp
Now, the installation should be reflected in dba_registry:
select comp_name "Component" from dba_registry;
Component
------------------------------------------
Oracle Database Catalog Views
Oracle Database Packages and Types
Oracle XML Database

re-installing XML DB

SQL> @?/rdbms/admin/catnoqm
SQL> alter tablespace XMLDB_TS offline;
SQL> drop tablespace XMLDB_TS including contents;
Then the same procedure as installing the XML DB.