• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
I'm working on extracting production data to our new test server, using exp_current_library.
At least 3 times now, I have had incomplete tables result from this process.

For example, on Monday I exported ABC50. Only about 1.7 million of over 2 million Z30 records were exported. Only about 2 million of over 6 million Z30H records were exported. I think that Z34, Z35, and Z71 were also short. Today with ABC01, only about 2 million of 16 million Z01 records were exported.

In all cases, I have seen no errors in the output log. When I export the tables individually using p_file_03 with the same parameters, it worked fine. Could there be something wrong with p_file_03? Or something wrong with exp_current_library?

Resolution:
You need to increase the rollback segments and run the export when there is little database activity.
Note: Oracle 9 doesn't have rollback segments, it has the undo tablespace. This was fixed by increasing the undo_retention time:
SQL> ALTER SYSTEM SET UNDO_RETENTION=36000;

• Article last edited: 10/8/2013