Simple but Annoying error for UpperCase/LowerCase Schema name.

[parekh.haresh]

Hi All,

We use dbms_utility.compile_schema at the end of our migration for compiling invalid objects if any. This however is giving us ORA error about insufficient privileges. We tried doing the same as sysdba by giving argument as ‘TIQOWNER’ (The schema owner), but it failed with the same error.


SQL> exec dbms_utility.compile_schema('TIQOWNER');

BEGIN dbms_utility.compile_schema('TIQOWNER'); END;

*

ERROR at line 1:

ORA-20000: You have insufficient privileges for an object in this schema.

ORA-06512: at "SYS.DBMS_UTILITY", line 422

ORA-06512: at line 1


Strangely, when the schema argument is supplied with lower-case it works.i.e the following

" exec dbms_utility.compile_schema('tiqowner'); "

gets completed successfully.

We never faced this in any other migration, so could this possibly be some oracle-parameter related issue ?

Note that the “Select user from dual” returns uppercase TIQOWNER.

Also ,

SQL> select USERNAME, USER_ID from dba_users;

USERNAME USER_ID
------------------------------ ----------
SYS 0
SYSTEM 5
OUTLN 11
DBSNMP 19
TIQOWNER 73