Re: impdp changes owner of jobs

On Jan 16, 12:32 pm, lothar.armbrues..._at_t-online.de (Lothar Armbrüster) wrote:
> Hello out there,
> today I imported a full database export of an Oracle 10.2.0.3 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  | lothar.armbrues..._at_t-online.de
> Hauptstr. 26       |
> 65346 Eltville     |

Hello Lothar,

What parameters did you use when running the impdp utility?

Regards,
Arun Received on Wed Jan 16 2008 - 12:21:07 CST