user Session
700193May 24 2011 — edited May 24 2011Hi,
I need to add a column into a temporary table but when trying to add the column is giving error "ORA-14452: attempt to create, alter or drop an index on temporary table already in use'
I just want to know the user session or the terminal IP address this table is being used by. I have tried v$session but there is no table specific information.
Can anyone tell me how to see this?
Another query I have that when using forall in bulk collect how do I get the index value like 1,2,3,4,5,6,7.......