title: How to solve Oracle exp error "ORACLE error 1455 encountered " when segments for all tables are available?
body: <p>We use exp to backup our database in Oracle 11g. Suddenly, the following error is being reported in the log file:</p>
  
  <pre><code>. exporting synonyms
  . exporting views
  . exporting stored procedures
  . exporting operators
  . exporting referential integrity constraints
  . exporting triggers
  . exporting indextypes
  . exporting bitmap, functional and extensible indexes
  . exporting posttables actions
  . exporting materialized views
  . exporting snapshot logs
  EXP-00008: ORACLE error 1455 encountered
  ORA-01455: converting column overflows integer datatype
  EXP-00000: Export terminated unsuccessfully
  </code></pre>
  
  <p>I have checked the database for <code>SEGMENT_CREATED</code> column for <code>USER_TABLES</code>, <code>USER_INDEXES</code> and <code>USER_LOBS</code> and there are no rows where <code>SEGMENT_CREATED = 'NO'</code>.</p>
  
  <p>Found some solutions to export database by turning audit off, using <code>INDEXES=N</code> and <code>STATISTICS=NONE</code> but I don't want to use those options.</p>
  
  <p>Also, don't want to use <code>expdp</code> as I have had problems importing.</p>
  
  <p>The only change somebody did was to create 2 user types recently but I suppose that is not causing the problem.</p>
  
  <p>Suggestions and solutions are highly appreciable.</p>
  
  <p>Thanks.</p>