How do we get around this as we need to modify the GTT and even the transactions that using this table is commit and expire long ago.
https://stackoverflow.com/questions/27111415/ora-14450-attempt-to-access-a-transactional-temporary-table-alreadyin-use-w…
One of the commentor in the above stackoverflow says there is no lock visible if the table GTT is being created as on commit preserve rows.
Thats our case, so how we are able to do alter table for that GTT ???
Error starting at line : 3 in command -
alter table tmp_repair add (is_pop_uploaded2 varchar2(4000))
Error report -
14450. 00000 - "attempt to access a transactional temp table already in use"
*Cause: An attempt was made to access a transactional temporary table that
has been already populated by a concurrent transaction of the same
session.
*Action: do not attempt to access the temporary table until the
concurrent transaction has committed or aborted.