Re: impdp changes owner of jobs

From: Lothar Armbrüster <lothar.armbruester_at_t-online.de>
Date: Thu, 17 Jan 2008 17:57:17 +0100
Message-ID: <87zlv4l79u.fsf@t-online.de>


Arun Mathur <themathurs_at_gmail.com> writes:

> 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? ;-)
>>

[...]
>
> Hello Lothar,
>
> What parameters did you use when running the impdp utility?
>
> Regards,
> Arun

Hello Arun,
I just gave the name of the directory, the dumpfile and the logfile. No esoteric parameters.

Regards,
Lothar

-- 
Lothar Armbrüster  | lothar.armbruester_at_t-online.de
Hauptstr. 26       |
65346 Eltville     |
Received on Thu Jan 17 2008 - 10:57:17 CST

Original text of this message