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
Printable View
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
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.