Re: impdp changes owner of jobs

From: joel garry <>
Date: Wed, 16 Jan 2008 11:06:25 -0800 (PST)
Message-ID: <>

On Jan 16, 9:32 am, (Lothar Armbrüster) wrote:
> Hello out there,
> today I imported a full database export of an Oracle database
> running on Windows 2000. I precreated the tablespaces since I wanted
> to put the datafiles on different locations.
> After the impdp finished, I realized that every job created with
> dbms_job now belongs to system which I used to run the import.
> I granted imp_full_database to system prior to the import.
> Now I wonder what I did wrong. Is there something to consider when I
> want to import jobs?
> This is a SE which was downgraded from an EE 9.1 via exp/imp a time
> ago. Can that cause the problem?
> Any crystal balls around? ;-)
> Regards,
> Lothar
> --
> Lothar Armbrüster  |
> Hauptstr. 26       |
> 65346 Eltville     |

See bug 5620345 (closed, not feasible to fix) workaround:

1.Qualify the function name with owner of the function while specifying in interval parameter. . for ex: interval=>'usr001.next_min(60)' .

2.Run the impdp as the user who submitted the job and has access privileges to the function.

Is your db SE or EE? See bug 5188282. There is at least one other which isn't public having to do with impdb and jobs, looks like they just didn't quite get it right. Perhaps you should submit this.


-- is bogus.
Oracle buys BEA:
Received on Wed Jan 16 2008 - 13:06:25 CST

Original text of this message