ORA-00972: identifier is too long Cause: An identifier with more than 30 c
599672May 30 2009 — edited May 30 2009Howdy expert,
select sum( case when FULLOPERATION like 'CREATE%MTNSUB%'
and FULLRESULT like 'RESP:0%' then 1
else 0 end ) "succesfully created minor user in the oracle database"
from TAB_PROCLOG
where (FULLOPERATION like '%MTNCSUB%')
and FULLRESULT like 'RESP:0%'
and STARTTIME between TO_TIMESTAMP ('2009-05-16 22:00:00','yyyy-mm-dd hh24:mi:ss')
and TO_TIMESTAMP ('2009-05-16 23:59:59','yyyy-mm-dd hh24:mi:ss');
I execute the command through ToadClient. But giving the error "ORA-00972: identifier is too long Cause: An identifier with more than 30 characters was specified. Action: Specify at most 30 characters"
How to solve the problem?
br//purple