I have some temp tables. Somtimes I need to modify it to add a column.
But usually this table has a session open on it and would give below error. I resolve it by just killing sessions. But I would like to find just that session or sessions that are the culprits rather than blindly killing all the sessions.
-Question - How i do find the session/s that has the temp table open now?
ERROR at line 1:
ORA-14450: attempt to access a transactional temp table already in use