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