title: ORA-00604: error occurred at recursive SQL level 1 ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 22
body: <p>While doing an import in an oracle 10G database using imp, I receive following error:</p>
  
  <pre><code>IMP-00017: following statement failed with ORACLE error 604:
   CREATE TABLE DASHBOARD_ADMINISTRATOR
   (ID NUMBER(19, 0) NOT NULL ENABLE,
   USER_NAME VARCHAR2(20) NOT NULL ENABLE,
   NAME VARCHAR2(50), FIRST_NAME VARCHAR2(50));
  
  IMP-00003: ORACLE error 604 encountered
  ORA-00604: error occurred at recursive SQL level 1
  ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  ORA-06512: at line 22
  </code></pre>
  
  <p>When doing the same thing in TOAD, I have the same error even if I only try to create the table with only 1 column specificied, which is even more strange since I only have 2 lines...</p>
  
  <p>Creating a table called DASHBOARD_ADMINISTRATO is possible, DASHBOARD_ADMINISTRATORR gives again the same error.</p>
  
  <p>However, when I switch places of the words in the name, it works fine.</p>
  
  <p>There is no limit set on tablename length because several of the imported tables have more characters.</p>
  
  <p>I used the same dumpfile to import into oracle 11G and there it was successful.</p>
  
  <p>Any ideas, someone?</p>
  
  <p>Thx for your help.</p>