We have an access DB which we've architected into a project. When I run the Datamart, I get memory and governing errors when trying to write a table back to Oracle. The table has 1+ million records. We've tried consolidating it down to < 1 mil, but still get the errors. Tech Support is no help because they "don't support" Access. Has anyone been successful in getting this to run? I've checked every memory/governing setting on the project but nothing helps. Suggestions are appreciated!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.