Database Administration (MOSC)

MOSC Banner

Can I drop OLAPSYS and WKSYS users?

I'm attaching the output of this query

select * from dba_errors where owner in('OLAPSYS','WMSYS','WKSYS') order by 1;

Seems like many of the dependant objects are already dropped leaving behind junk. I don't see any references to these being used in our database or applications.

I'm doing some tiding of data and beginning to plan our Oracle 19c migration. I suspect these objects were all created either on an 8i or 9i database and came forward when I installed 12c and imported the full export.


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center