Re: impdp stopped working error UDI-31623

From: David Barbour <david.barbour1_at_gmail.com>
Date: Mon, 18 Apr 2016 11:16:05 -0500
Message-ID: <CAFH+ifeGQut6hDeN5prPOzuS4iNJkM4ODwNQ9covqe_jbhBA6A_at_mail.gmail.com>



What do you get when you run the following?

Select owner_name, job_name, operation, state from dba_datapump_jobs;

On Mon, Apr 18, 2016 at 11:01 AM, Howard Latham <howard.latham_at_gmail.com> wrote:

> Version 11.2.04
> Linux Redhat Ent 4
>
>
> ​After a failed impdp and then I dropped a user to retry import impdp
> will not work.
> I've logged it with Oracle support but so far nothing.
> Its not the streams size that comes up with google . OS said it might be a
> data dictionary inconsistency.
>
> Import: Release 11.2.0.1.0 - Production on Mon Apr 18 16:58:04 2016
>
> Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights
> reserved.
>
> Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -
> 64bit Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
>
> UDI-31623: operation generated ORACLE error 31623
> ORA-31623: a job is not attached to this session via the specified handle
> ORA-06512: at "SYS.DBMS_DATAPUMP", line 3263
> ORA-06512: at "SYS.DBMS_DATAPUMP", line 4488
> ORA-06512: at line 1
>
> ​Any ideas? Anyone?
>
>
>
>
> --
> Howard A. Latham
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 18 2016 - 18:16:05 CEST

Original text of this message