Database Administration (MOSC)

MOSC Banner

ORA-01436: CONNECT BY loop in user data

Hi Good day,

im encountering ORA-01436: CONNECT BY loop in user data, but i don't know what trigger this issue,

ORA-01436: CONNECT BY loop in user data

ORA-12012: error on auto execute of job "VISTA"."DBMS_JOB$_101"

ORA-01436: CONNECT BY loop in user data

ORA-00604: error occurred at recursive SQL level 1


as per checking in the trace file this sql select is causing the issue. ---- Current SQL Statement for this session (sql_id=5dqz0hqtp9fru) -----

select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand(nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 <<<<<<<<< SQL failing with ORA-01436 Error

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