Drop user ORA-00942, ORA-00604, ORA-06512

[Aljaz]

User a is an account not schema.

I have enabled sql_trace and from what I can see there is a problem with XDB user.

When Oracle drop user it checks table xdb.xbd$schema, becouse this table does not exist the drop command fails.

It seems that I have to create XDB schema.

I have never manually installed XDB user and this is the production database so there is no room for mistakes.

Any expirances with install XDB schema.

Procedure for installing is :
SQL> CREATE TABLESPACE "XDB"
2 LOGGING DATAFILE '/u10/app/oradata/MYDB/xdb01.dbf' SIZE 50M REUSE
3 AUTOEXTEND ON NEXT 50M MAXSIZE 1500M
4 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

SQL> @catqm.sql change_on_install XDB TEMP

SQL> @catxdbj.sql


Then you adjust dispatchers parameter.

And after that everything will be OK?
Right?