<<Back to Oracle DATAPUMP Main Page
expdp fails with ORA-01690: sort area size too small expdp
As per Metalink note Doc ID 1911968.1 issue has been fixed in 12.1 and above however I had the issue in 12.1.0.2 version while performing full database export using expdp utility.Tried to increase the pga_aggregate_target from 2G to 10G but no luck.
Solution1: Recommended
Changed the parameter file to have schema based export instead of full.
Before
userid= system
directory=dump
dumpfile=dump_%U
logfile=exp.log
full=y
parallel=3
flashback_scn=291638761
AFTER
userid= system
directory=dump
dumpfile=dump_%U
logfile=exp.log
schemas=TEST1, TEST2
parallel=3
flashback_scn=291638761
Solution2:
use traditional exp utility instead of expdp
Comments
Post a Comment