Follow below steps for deinstalling XDB component:
--- The catnoqm.sql script drops XDB. >SQL> spool xdb_removal.log SQL> set echo on; SQL> connect / as sysdba SQL> shutdown immediate; SQL> startup SQL> @?/rdbms/admin/catnoqm.sql SQL> spool off;
FOR INSTALLING XDB COMPONENT:
----The catqm.sql script requires few parameters be passed to it when run: SQL> spool xdb_install.log SQL> set echo on; SQL> connect / as sysdba SQL> shutdown immediate; SQL> startup; -----SQL> @?/rdbms/admin/catqm.sql <XDB pwd> <XDB default tbs> <XDB temporary tbs> <SecureFiles = YES/NO> SQL> @?/rdbms/admin/catqm.sql test#1235 USERS TEMP YES SQL> @?/rdbms/admin/utlrp.sql SQL> spool off
SecureFiles = YES or NO
(If YES is specified, the XDB repository will use SecureFile storage.
If NO is specified, LOBS will be used.
To use SecureFiles, compatibility must be set to 11.2.
The tablespace specified for the XDB repository must be using
Automatic Segment Space Management (ASSM) for SecureFiles to be used.)