DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Does EXP, export broken jobs?

  1. 11-08-2007, 07:32 AM #1
    ssmith
    ssmith is offline Senior Member
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258

    Does EXP, export broken jobs?

    I had to break 2 jobs, i.e. execute dbms_job.broken(1281,true), so I could export the schema and import onto another database. The problem is these jobs did not get imported. Does exp not export broken jobs? Thanks. Rgds. Sheryl
    Reply With Quote Reply With Quote
  2. 11-08-2007, 08:05 AM #2
    ssmith
    ssmith is offline Senior Member
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    Finally found the missing jobs. They have been imported with log_user 'SYSTEM'. Strange as I did import using fromuser= touser=. Does anyone know why this happens? We are using 9.2.0.8.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width