Oracle DBA, How To, Error, Cause and Action

ORA-01042: detaching a session with open cursors not allowed

ORA-01042: detaching a session with open cursors not allowed




Cause: An attempt was made to detach a seesio n which had open cursors.




Action: Close all the cursors before detaching the session.