Donald K. Burleson Oracle Tips

Export bug warning

There is a bug in Oracle’s Export that generates invalid storage clauses for tables. (Oracle bug 708790)

This is a serious bug that can cripple a database during routine reorganization.

This problem affects all versions of export shipped with all Oracle releases: since 7.0.12 through 8.0.5, and has not yet been fixed.

If an export is performed using COMPRESS=Y then it is possible for the storage clause in the export file to contain invalid values for INITIAL and  NEXT extents, causing the table definition to fail.

This problem will occur if export is run with the COMPRESS option set to YES (which is the default), and usually effects Oracle tables where NEXT_EXTENT >= (2*1024*1024*1024).  In these cases, import will terminate with ... IMP-00003: ORACLE error 2219 encountered ORA-02219: invalid NEXT storage option value.  The workaround is not to use COMPRESS=Y when doing exports for these types of tables.

If you like Oracle tuning, you might enjoy my latest book “Oracle Tuning: The Definitive Reference” by Rampant TechPress.  It’s only $41.95(I don’t think it is right to charge a fortune for books!) and you can buy it right now at this link:

http://www.rampant-books.com/book_2005_1_awr_proactive_tuning.htm