SQL> create tablespace XDB datafile '/umsdata03/umsdb/datafile/ums_data_xdb01.dbf' size 1G; Tablespace created. SQL> SQL> SQL> SQL> SQL> @?/rdbms/admin/catqm.sql xdb123 XDB UMS_AUTOALLOC_TEMP CREATE TABLE sys.xdb_installation_tab ( * ERROR at line 1: ORA-00955: name is already used by an existing object CREATE TABLE sys.dropped_xdb_instll_tab ( * ERROR at line 1: ORA-00955: name is already used by an existing object DROP ON DATABASE * ERROR at line 3: ORA-00604: error occurred at recursive SQL level 1 ORA-20000: Trigger xdb_installation_trigger does not support object creation of type TRIGGER ORA-06512: at line 32 Trigger created. System altered. System altered. System altered. System altered. old 23: where tablespace_name = upper('&res_tbs'); new 23: where tablespace_name = upper('XDB'); old 29: where tablespace_name = upper('&temp_tbs'); new 29: where tablespace_name = upper('UMS_AUTOALLOC_TEMP'); old 47: raise_application_error(-20001, 'Compressed tablespace &res_tbs' || new 47: raise_application_error(-20001, 'Compressed tablespace XDB' || old 51: '&temp_tbs cannot be used'); new 51: 'UMS_AUTOALLOC_TEMP cannot be used'); PL/SQL procedure successfully completed. old 1: create user xdb identified by &xdb_pass account lock password expire new 1: create user xdb identified by xdb123 account lock password expire old 2: default tablespace &res_tbs temporary tablespace &temp_tbs new 2: default tablespace XDB temporary tablespace UMS_AUTOALLOC_TEMP User created. PL/SQL procedure successfully completed. old 1: create user anonymous identified by values 'anonymous' default tablespace &res_tbs new 1: create user anonymous identified by values 'anonymous' default tablespace XDB create user anonymous identified by values 'anonymous' default tablespace XDB * ERROR at line 1: ORA-01920: user name 'ANONYMOUS' conflicts with another user or role name Grant succeeded. User altered. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. CREATE role xdbadmin * ERROR at line 1: ORA-01921: role name 'XDBADMIN' conflicts with another user or role name Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Session altered. Table created. Table created. Index created. Type created. Table created. Index created. Type created. Type created. Type created. Synonym created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Index created. Index created. Index created. Table analyzed. Sequence created. Sequence created. Grant succeeded. Library created. Function created. Package created. No errors. Package body created. No errors. Procedure created. Function created. Grant succeeded. Grant succeeded. PL/SQL procedure successfully completed. Type created. Type created. Type created. Type created. Type created. Grant succeeded. Type created. Grant succeeded. Table created. Table altered. Table altered. Index created. Table created. Index created. Index created. Index created. Package created. No errors. Package body created. No errors. PL/SQL procedure successfully completed. Session altered. Package created. No errors. Synonym created. Grant succeeded. Package created. Synonym created. Grant succeeded. No errors. Type created. No errors. Grant succeeded. Package created. No errors. Synonym created. Grant succeeded. No errors. drop type xdb.xdbpi_im * ERROR at line 1: ORA-04043: object XDBPI_IM does not exist drop table xdb.xdb$path_index_params * ERROR at line 1: ORA-00942: table or view does not exist Library created. Table created. Package created. Grant succeeded. No errors. Type created. No errors. Type body created. No errors. Grant succeeded. Package created. Package body created. Package created. No errors. Grant succeeded. Package created. Synonym created. No errors. Grant succeeded. Library created. Procedure created. No errors. Grant succeeded. Function created. No errors. Grant succeeded. Warning: Package Body created with compilation errors. No errors. Grant succeeded. No errors. Trigger created. No errors. Package body created. Package created. No errors. Synonym created. Synonym created. Synonym created. Grant succeeded. Grant succeeded. No errors. Package created. No errors. Synonym created. Synonym created. Synonym created. Grant succeeded. Grant succeeded. No errors. Package created. No errors. Package created. Synonym created. Synonym created. Synonym created. Grant succeeded. Grant succeeded. Grant succeeded. No errors. Grant succeeded. Library created. Package body created. No errors. Library created. Warning: Package Body created with compilation errors. No errors. Synonym created. Grant succeeded. No errors. Library created. Warning: Package Body created with compilation errors. No errors. Warning: Package Body created with compilation errors. Synonym created. Grant succeeded. No errors. Grant succeeded. Library created. Function created. Grant succeeded. Synonym created. Procedure created. No errors. Grant succeeded. Grant succeeded. Function created. No errors. Grant succeeded. Function created. Grant succeeded. Grant succeeded. Package body created. No errors. Warning: Package Body created with compilation errors. No errors. Synonym created. Grant succeeded. No errors. PL/SQL procedure successfully completed. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. Commit complete. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Package created. No errors. Grant succeeded. Package body created. Package body created. No errors. Procedure created. No errors. Procedure created. No errors. drop view xdb.xdb$resource_view * ERROR at line 1: ORA-00942: table or view does not exist drop view xdb.xdb$rv * ERROR at line 1: ORA-00942: table or view does not exist PL/SQL procedure successfully completed. drop indextype xdb.xdbhi_idxtyp force * ERROR at line 1: ORA-29833: indextype does not exist drop operator xdb.path force * ERROR at line 1: ORA-29807: specified operator does not exist drop operator xdb.depth force * ERROR at line 1: ORA-29807: specified operator does not exist drop operator xdb.abspath force * ERROR at line 1: ORA-29807: specified operator does not exist drop operator xdb.under_path force * ERROR at line 1: ORA-29807: specified operator does not exist drop operator xdb.equals_path force * ERROR at line 1: ORA-29807: specified operator does not exist drop package xdb.xdb_ancop * ERROR at line 1: ORA-04043: object XDB_ANCOP does not exist drop package xdb.xdb_funcimpl * ERROR at line 1: ORA-04043: object XDB_FUNCIMPL does not exist drop type xdb.xdbhi_im * ERROR at line 1: ORA-04043: object XDBHI_IM does not exist drop type xdb.path_array * ERROR at line 1: ORA-04043: object PATH_ARRAY does not exist Library created. Library created. Type created. Type created. No errors. Grant succeeded. Grant succeeded. Type created. No errors. Type body created. No errors. Grant succeeded. Package created. No errors. Grant succeeded. Package created. No errors. Grant succeeded. Type altered. Operator created. Operator created. Grant succeeded. Grant succeeded. Synonym created. Synonym created. Operator created. Operator created. Operator created. Grant succeeded. Synonym created. Grant succeeded. Synonym created. Grant succeeded. Synonym created. Indextype created. Grant succeeded. Index created. View created. No errors. Synonym created. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Package created. No errors. Synonym created. Grant succeeded. Trigger created. No errors. Package body created. No errors. Function created. No errors. Grant succeeded. Synonym created. Function created. No errors. Package body created. No errors. Package body created. No errors. Package body created. No errors. Package body created. BEGIN * ERROR at line 1: ORA-04063: package body "XDB.DBMS_XDBZ0" has errors ORA-06508: PL/SQL: could not find program unit being called: "XDB.DBMS_XDBZ0" ORA-06512: at "XDB.DBMS_XDBZ", line 7 ORA-06512: at line 2 declare * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors ORA-06512: at "XDB.XDB$PATCHUPSCHEMA", line 98 ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 3 ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 14 ORA-06512: at line 143 BEGIN * ERROR at line 1: ORA-04063: package body "XDB.DBMS_XDBZ0" has errors ORA-06508: PL/SQL: could not find program unit being called: "XDB.DBMS_XDBZ0" ORA-06512: at "XDB.DBMS_XDBZ", line 14 ORA-06512: at line 2 DECLARE * ERROR at line 1: ORA-31114: XDB configuration has been deleted or is corrupted ORA-06512: at "XDB.DBMS_XDB", line 73 ORA-06512: at line 96 declare * ERROR at line 1: ORA-01403: no data found ORA-06512: at line 5 Commit complete. call xdb.dbms_xdbz0.initXDBSecurity() * ERROR at line 1: ORA-04063: package body "XDB.DBMS_XDBZ0" has errors BEGIN * ERROR at line 1: ORA-04063: package body "XDB.DBMS_XDBZ0" has errors ORA-06508: PL/SQL: could not find program unit being called: "XDB.DBMS_XDBZ0" ORA-06512: at "XDB.DBMS_XDBZ", line 7 ORA-06512: at line 2 Commit complete. grant all on XDB.XDB$ACL to public * ERROR at line 1: ORA-00942: table or view does not exist