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



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

Answer / guest

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

Action: Close all the cursors before detaching the session.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12419: null binary label value

1 Answers  


NNL-00802: Queries received, type ADDRESS: number

1 Answers  


NNL-00893: Similar requests received: number

1 Answers  


ORA-13052: unsupported geometric type for geometry string.string

1 Answers  


ORA-31158: schema "string" currently being referenced

1 Answers  






ORA-13028: Invalid Gtype in the SDO_GEOMETRY object

2 Answers  


PCB-00553: FOR clause not allowed on this statement

1 Answers  


ORA-35276: (SNSYN163) The format of the ALLOCATE command is: ALLOCATE varname [SOURCE svarname] [BASIS bvarname [ACROSS dimname]] [TARGET tvarname [TARGETLOG logvarname]] [ USING aggmap ]

1 Answers  


ORA-29309: export dump file was generated by different version of DBMS_PITR package

1 Answers  


ORA-01571: redo version string incompatible with ORACLE version string

1 Answers  


ORA-21527: internal OMS driver error

1 Answers  


ORA-25105: RECOVERABLE option can only be used with ALTER INDEX REBUILD

1 Answers  


Categories