This is most likely a problem with the credentials you are using to run jobs. In OEM, go into Configuration -> Preferences -> Preferred Credentials. Make sure that the <DEFAULT> for Node is a valid account that can run jobs. You didn't say what platform you are on. For Windows, you will need...
Are your source and target in different schemas? If so make sure the schema where you are deploying explicitly has select access to the object in the other schema. Also, configure your mapping and make sure the schema names are set for each object.
HTH
When you generate a flat-file mapping, there should be 2 things to generate. The sqlldr control file and the OEM job. Neither of those is "Deploy"ed to the database or "Run". Highlight the sqlldr control file and "Save File". Highlight the oem job and "Save...
Hi,
You can find a very good explanation here -
http://www.evdbt.com/SearchIntelligenceCBO.doc
There are huge disadvantages to using the rule based optimizer, not the least of which is that it will eventually go away.
HTH.
Hi,
I haven't tried it, or even tried to think it through completely, but I'm pretty sure you can do this without any transformation procedure, using filters.
You might be able to use 2 filters in one mapping. One filter would be creation_date < today and would do an update. The other...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.