Friday, January 22, 2016

ora-14450 ora-14452 global temporary table attempt to access a transactional temp table already in use

SELECT
distinct
ss.program "SOFTWARE",
SS.TERMINAL,
       ss.username "USER",
'alter system disconnect session ''' || ss.sid || ',' || ss.serial# || ',@' || ss.inst_id || ''' immediate;'
  fROM gv$process pr, gv$session ss, gv$sqlarea sqa,
(select  sid
  from  gv$lock
  where id1 = (
               select  object_id
                 from  dba_objects
                 where owner = 'LDBO'
                   and object_name = 'TBLTEMPTRADESTATUS'))tbllock
 WHERE pr.addr = ss.paddr
   AND ss.username is not null
   AND ss.sql_address = sqa.address(+)
   AND ss.sql_hash_value = sqa.hash_value(+)
and ss.inst_id=pr.inst_id
and ss.sid = tbllock.sid
;

No comments:

Post a Comment

Followers