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!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DataMarts in Access to Oracle
- Thread starter petperson
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question