Database Administration (MOSC)

MOSC Banner

user_constraints ORA-01013: user requested cancel of current operation


Hello,

I'm retrieving data from user_constraints view and I get ORA-01013: user requested cancel of current operation 


I've updated stats for following tables - these are included in user_constraints view defintion


EXEC DBMS_STATS.GATHER_TABLE_STATS('SYS', 'CON$');

EXEC DBMS_STATS.GATHER_TABLE_STATS('SYS', 'CDEF$');

EXEC DBMS_STATS.GATHER_TABLE_STATS('SYS', 'USER_EDITIONING$');

EXEC DBMS_STATS.GATHER_TABLE_STATS('SYS', 'COL$');

EXEC DBMS_STATS.GATHER_TABLE_STATS('SYS', 'COLTYPE$');

EXEC DBMS_STATS.GATHER_TABLE_STATS('SYS', 'OBJ$');

EXEC DBMS_STATS.GATHER_TABLE_STATS('SYS', 'USER$');


But still query of the view user_constraints or "SYS"."INT$INT$DBA_CONSTRAINTS" is broken by ORA-01013

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