Bryan Stevenson wrote: > > I have an Access DB that needs to move to Oracle 9i. The Oracle DB has been > created and then generated via Oracle Designer and does contain different > table names than the Access DB, and some tables will have less/more columns > than their Access counterparts. In some cases their will be additional > columns on the Oracle side that I will need to add a default value to (so not > data that comes from the Access DB). > > So does anyone have advice to transform this data from Access to Oracle given > the above issues? ....and before you say flat file....re-read the above ;-)
For a one-time manual job: Create linked tables in Access to your Oracle database. Then just use SELECT .. INTO ... to move the data and apply any transformation you want in the process. For repeated exports: export from Access to flat files and mount them in Oracle as external tables. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229367 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
