Database Administration (MOSC)

MOSC Banner

AQ table unusable

edited Nov 16, 2016 4:00AM in Database Administration (MOSC) 3 commentsAnswered

Hi,

when trying to impdp I get the following errors:

[oracle@vlgora01 ~]$ impdp system/**** schemas=AMOSSERVER_PROD remap_schema=AMOSSERVER_PROD:AMOS_PRIV_U,AMOSUSER_PROD:AMOS_UNPRIV_U remap_tablespace=TS_PROD:AMOSDAT directory=DATA_PUMP_DIR dumpfile=exportdpAMOSSERVER_PROD.dmp content=data_only exclude=statistics logfile=LOG_DIR:impdpAMOSSERVER_PROD_161108.log  DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS

Import: Release 11.2.0.4.0 - Production on Tue Nov 8 16:41:44 2016

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

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

With the Real Application Clusters and Automatic Storage Management options

ORA-31626: job does not exist

ORA-31638: cannot attach to job SYS_IMPORT_SCHEMA_04 for user SYSTEM

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