Database Administration (MOSC)

MOSC Banner

Unable to drop users as SYS

edited Nov 24, 2016 4:00AM in Database Administration (MOSC) 6 commentsAnswered

Hi all,

I'm trying to drop several users from the DB using SYS account.

However when I issue the command drop user xx cascade, I'm receiving ORA-04063 errors. Please see example below.

SQL> drop user ADMIN_UTILS cascade;

drop user ADMIN_UTILS

*

ERROR at line 1:

ORA-04063: CLIENT_QTAB has errors

Weirdly it only happen on those few users, I didn't face any issue when I tried to drop a dummy account i created on the db.

SQL> create user testing identified by test;

User created.

SQL> drop user testing cascade;

User dropped.

I did check on the table which is having the error & found the table is invalid. Can anyone help me to resolve this? I'm at lost right now because I'm not able to find much info regarding validating invalid table from google or MOS.

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