I want alter a temporary table, adding some columns. The alter table statement throws ORA-14450 attempt to access a transactional temp table already in use.
We have a fairly large test environment, running many users and application. My applications using the table are an asp.net application and a pl/sql monitoring application. Restarting webserver and database is not possible to find remove session.
Any idea to find session blocking my alter table?