Richard Harrison . wrote:Hello,
I wonder if you are hitting some variation on this bug
Bug 6804815 Jobs in incorrect schema after datapump import
It affects 10.2.0.3 - maybe there is something odd about the metadata which menas 11.2 impdp ignores it?
Can you do an impdp to a sqlfile and see if that gives any clues?
is that refresh group owned by the schema you exported ?
Dean Gagne wrote:1. I can not run a new import as the system is in production.
A couple of things you can try.
1. run the import but add these 2 parameters
Then you can look at the master table to see if there are any jobs. I don't know why export would show these objects but import would not. Here is a good query:
select object_type, object_name, processing_status, processing_state
where process_order > 0 and duplicate = 0 and object_type = 'JOB';
If you can post this I can take a look at it to see if I can see anything.
2. If you run your import command with:
Do you get anything in your jobs.sql file?