well, identifiers are limited to 30 characters.

but you give us no example.  I get this error myself:

ops$tkyte@ORA920LAP> create table t123456789012345678901234567890t ( x int );
create table t123456789012345678901234567890t ( x int )
             *
ERROR at line 1:
ORA-00972: identifier is too long

 

look for a system event trigger one of your guys wrote.


ops$tkyte@ORA9IR2> create or replace trigger test before drop on database
  2  declare
  3          l_n number;
  4  begin
  5          null;
  6          null;
  7          null;
  8          execute immediate 'select 1 from tafdafa' into l_n;
  9  end;
 10  /
 
Trigger created.
 
ops$tkyte@ORA9IR2>
ops$tkyte@ORA9IR2> drop user a cascade;
drop user a cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 7
 
 
ops$tkyte@ORA9IR2> drop trigger test;
 
Trigger dropped.
 
ops$tkyte@ORA9IR2> drop user a cascade;
 
User dropped.
 

ops$tkyte%ORA10GR2> alter session set events '10046 trace name context forever, level 12';

Session altered.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> select /*+ lookforme plus */ * from "
  2
ops$tkyte%ORA10GR2> /
ERROR:
ORA-00972: identifier is too long


ops$tkyte%ORA10GR2> begin
  2          for x in (select * from ")
  3          loop
  4          null;
  5          end loop;
  6  end;
  7  /
ERROR:
ORA-01740: missing double quote in identifier


ops$tkyte%ORA10GR2> declare
  2          l_x long;
  3  begin
  4          execute immediate 'select /*+ lookforme plsql */ * from "' into l_x;
  5  end;
  6  /
declare
*
ERROR at line 1:
ORA-01740: missing double quote in identifier
ORA-06512: at line 4