DataPump Export (EXPDP) Fails With Errors ORA-39126 and ORA-1690 After Applying Patchset 18.104.22.168
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 22-Jan-2014***
After applying patchset 188.8.131.52, 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 184.108.40.206.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms