Error Preparing Data
  • 1 Minute to read
  • Dark
    Light
  • PDF

Error Preparing Data

  • Dark
    Light
  • PDF

Article Summary

You may have run the extraction and encountered the following Max Extents errors.

  • Error preparing data: ORA-01631: max # extents (505) reached in table APPS.XXPAN_CUSTOM_SOURCE ORA-06512: at line 1
  • java.sql.SQLException: ORA-01631: max # extents (505) reached in table APPS.XXPAN_CUSTOM_SOURCE ORA-06512: at line 1

The extraction execution creates the following table in the database:
XXPAN_CUSTOM_SOURCE (Which is deleted at the end of the process).

If you have limited the Max Extents, please execute the following command in SQL before running the extraction:

ALTER TABLE XXPAN_CUSTOM_SOURCE
STORAGE(MAXEXTENTS UNLIMITED)