Import/Export Limitations

Document ID : KB000088627
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Import/Export Limitations
Resolution:
Detailed Description and Symptoms
A ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes error is thrown when you attempt to run an Applications Manager import

Solution

Sometimes there is a business need to export a large number of Applications Manager objects to another instance. 

While there is not a hard limit to the number of objects you can import, the buffer limit has been set for imports so as not to disturb other processing within Applications Manager.

The import/export utility within Applications Manager was not designed to move an entire instance's objects to another.  If this is the function you are looking to perform the supported method for this is to clone this instance using the copy/move procedure described in the Administration Guide.
If you run into the above error the recommendation is to break up the export into a few smaller chunks.  This will still allow the objects to be moved over but will not disturb other processing on the master.

If the above is not possible and you are still running into this error you can do the following:

*In the Master's machine, go into the %AW_HOME%/sql directory.

*Make a back-up copy of the IMPORT.sql.

*Edit the IMPORT.sql file and change:

*set serveroutput on size 1000000
to
*set serveroutput on size unlimited

Try the import again.  The import file is pretty large so you may run into other issues.