Re: job ownership during schema imp/exp changes

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 26 Jan 2006 15:33:07 -0500
Message-ID: <9fcit1le9h9s92eocdph3pbu33p2b7unr1@4ax.com>

On 26 Jan 2006 11:39:28 -0800, "Joel Garry" <joel-garry_at_home.com> wrote:

>Interestingly enough, the metalink document about how to use exp/imp to
>copy PORTAL schemas has this little nugget:
>
>---- Jobs
>--
>-- Reassign the JOBS imported to PORTAL. After the import, they belong
>-- incorrectly to the user SYS.
>update dba_jobs set LOG_USER='PORTAL', PRIV_USER='PORTAL' where
>schema_user='PORTAL';
>commit;

I didn't know updating dba_* was allowed.

Thanks for the tip.
.......
We run Oracle 9.2.0.6 on RH4 AMD
remove NSPAM to email Received on Thu Jan 26 2006 - 14:33:07 CST