DataPump Export (EXPDP) Fails With Errors ORA-39126 and ORA-1690 After Applying Patchset 22.214.171.124
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 22-Jan-2014***
After applying patchset 184.108.40.206, full DataPump export (expdp) fails with errors:
ORA-01690: sort area size too small
To get more information about the error ORA-1690, enable errorstack on 1690. First set the following event:
alter system set events '1690 trace name ERRORSTACK level 3';
and then rerun expdp.
The generated tracefile shows the following SQL statement:
DataPump export worked well prior applying 220.127.116.11.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms