The reason the oracle data is being backed up to oracle is because there is a backup piece of software for the frontline software that uses the oracle db.
This simplistic backup piece of software uses access.
So when our frontline app goes down we then use the simplistic version which sits on top of access. (Its legacy software)
I am only grabbing a few columns from oracle and i will probably get it dumped to a csv file and then load it into access.
My aim is however to come up with a document that shows what bits of data from my oracle db will be backed up to access tables so that its obvious to the average jow blow exactly whats going where. I am looking for an example or a standard.