Friday, September 9, 2011

How to install XML DB

How to install XML DB

1. create tablespace for XDB

create tablespace xdb datafile '/u01/oradata/xdb.dbf' size 100m

2. Make sure sufficient Shared pool size

alter system set shared_pool_size = 180M scope=spfile;


3.Run script

@?/rdbms/admin/catqm password xdb temp

4. select comp_name,version,status from dba_registry;

5.Re install XML DB

@?/rdbms/admin/catnoqm
drop tablespace xdb including contents and datafiles;

No comments: