Database Utilities (MOSC)

MOSC Banner

ORA-01422 for import/export

edited Jan 8, 2019 4:04PM in Database Utilities (MOSC) 7 commentsAnswered

Hi,

I am using 11g version 11.2.0.4.0.  I try to import or export data into/from "SYSTEM" schema. and I get the following error:

11.2.0.4.0 - Production on Mon Dec 10 18:02:06 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-31626: job does not exist

ORA-31637: cannot create job SYS_IMPORT_FULL_01 for user SYSTEM

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT_INT", line 798

ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "SYS.DBMS_AQADM", line 201

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