XDB SCHEMA INSTALL STEPS

       開發的同事要求使用XMLPARSER, 檢查發現缺少XDB, 需要安裝, metalink一查，又詳細的安裝說明！ --query if XDB installed select comp_name, version, status
from dba_registry where comp_name like '%XML%';  --select * from dba_tablespaces and create xdb tablespace
CREATE TABLESPACE XDB DATAFILE
  '+DATA' SIZE 64M AUTOEXTEND OFF
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON; -- Connect as sysdba and run the catqm.sql script. Maintain a spool of the script running: SQL> set echo on
SQL> spool xdb_install.log
SQL>@?/rdbms/admin/catqm.sql XDB XDB TEMP  instanceid1.dispatchers="(PROTOCOL=TCP) (SERVICE=XDB)"
instanceid2.dispatchers="(PROTOCOL=TCP) (SERVICE=XDB)"  --Check for any invalid XDB owned objects: SQL> select count(*) from dba_objects
where owner='XDB' and status='INVALID';  --recompile the XDB schema objectSQL> EXEC UTL_RECOMP.recomp_serial('XDB'); -- confirm the xdb is installedselect comp_name, version, status
from dba_registry
where comp_name like '%XML%';