Re: Convert Access Tables to Oracle????

LWelty8546 wrote:

> I am an Oracle novice and I want to know what the best way to
> convert three Access .MDB files into something that will work in Oracle.
> The application has three .MDB files and are loosely related. I am
> confused about tablespaces and datafiles. Could I use three tablespaces,
> or do I need one tablespaces and three datafiles?
> Also, is there a way to make the .MDB files into Oracle format
> without having to create the tables from scratch?

SSpiars wrote:
>
> I don't know of any way to automatically convert Access tables to Oracle,
> but I would recommend creating 3 tablespaces, using 3 separate datafiles,
> and putting 1 table in each of the tablespaces.

I am curious as to why you are suggesting one tablespace for each table (although it's not definitve, but rather improbable that each *.MDB file contains only one table). *If* there are only three tables I would have gone for one tablespace and one data file and placing all three tables within this tablespace, given 'reasonable' amounts of data of each table. (Please note that my DBA experience is very limited.)

Placing all tables of one *.MDB file into one seperate tablespace is something that would make sense to me, but I'd like to know what the advantage of creating a tablespace for *one* table is, and when one should do so.

As for your question about how to 'convert' the Access tables to Oracle, the only way I can think of is to export each Access table using a fixed-length or delimited Ascii format, creating each table in Oracle and using SQL*Loader to load the exported files.

Regards,
-- Robert Staedter

   University for Agriculture
   Vienna, Austria Received on Mon Apr 29 1996 - 00:00:00 CEST