You cannot drop a global temporary table, which is in use by some user. The table is not locked, but there is data in the GTT, which is enough that the GTT cannot be dropped.
v$tempseg_usage shows which users have 'DATA' temporary segments, but not which temporary tables these are in.
Any way to provide this link between logged in user and GTT(s) that are in use by ths user?
Regards Niels Jespersen