Re: Access to Oracle

From: K Stahl <BlueSax_at_Unforgettable.com>
Date: Thu, 24 Feb 2000 15:35:40 -0500
Message-ID: <38B5961C.2AB17B0A@Unforgettable.com>

Philip wrote:
>
> I am looking for a way to import a database from Access to Oracle. The
> Oracle version I am currently working with is 8.0.5. I am new to Oracle
> and have not been able to find documentation on how this type of
> migration can be accomplished.

If you have ODBC configured on your PC to your Oracle database then you might be able to export directly to a table in the Oracle database. Of course you would have to create the table first.

Otherwise you would probably have to export the data to some type of text file and then use sqlloader to bring it into Oracle. Received on Thu Feb 24 2000 - 14:35:40 CST