Re: Transferring Access data to Oracle
Date: 1996/05/25
Message-ID: <4o5vke$648_at_masala.cc.uh.edu>#1/1
Moorthy N. Rekapalli (moorthy_at_atl.mindspring.com) wrote:
: 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:
: 1) Are there any better ways of doing this.
: 2) Will there be any problems by deleting all the data from Oracle and
: Loading data again.
: 3) 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 Sat May 25 1996 - 00:00:00 CEST