Re: job ownership during schema imp/exp changes

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;

jg
--

@home.com is bogus.
Wanna buy a watch?
http://www.signonsandiego.com/uniontrib/20060126/news_1b26auction.html Received on Thu Jan 26 2006 - 13:39:28 CST