Database Administration (MOSC)

MOSC Banner

Errors ora-39127 ora-01422 on expdp domain index of Arcgis geodatabase - Oracle 19.11

When trying to export from Arcgis geodatabase returns the errors below.

ORA-39127: unexpected error from call to status := SYS.DBMS_EXPORT_EXTENSION.GET_V2_DOMAIN_INDEX_TABLES('A1_IX1','SDE','ST_DOMAIN_METHODS','SDE',0,'19.11.00.00.00',1,0) 
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 520
ORA-06512: at "SYS.DBMS_ODCI", line 82
ORA-06512: at "SYS.DBMS_ODCI", line 301
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 496
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 520
ORA-06512: at "SYS.DBMS_ODCI", line 82
ORA-06512: at "SYS.DBMS_ODCI", line 301
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 496
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 10658
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

Indexe have valid status. Oracle version is 19.11

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center