Transferring Access data to Oracle
From: Moorthy N. Rekapalli <moorthy_at_atl.mindspring.com>
Date: 1996/05/24
Message-ID: <4o4cq9$5l8_at_mule1.mindspring.com>#1/1
Date: 1996/05/24
Message-ID: <4o4cq9$5l8_at_mule1.mindspring.com>#1/1
Hello There,
I need to transfer Microsoft Access data to Oracle. I am
thinking of exporting Access tables to a flat file and then using
Oracle's SQL*Loader.
Access -> Export to flat file -> SQL*Loader -> Oracle.
In the mean time, people will add more data to Access. I am thinking of transferring data at regular intervals like once in a week. To do this, first I have to delete all the existing data in Oracle tables. I would like to know:
- Are there any better ways of doing this.
- Will there be any problems by deleting all the data from Oracle and Loading data again.
- I am also thinking of dropping the Oracle tables and recreating them before loading data. Will this cause fragmentation or any other problems.
Moorthy
(moorthy_at_mindspring.com)
Received on Fri May 24 1996 - 00:00:00 CEST