Re: RDB to Oracle 7.3

You can move the data in a three step operation:

Step 1 - Define the tables for Oracle.
Step 2 - Do the rdb equivalent of SELECT * FROM table_name; and

        direct the output to a spool file.
Step 3 - Use Oracle's SQL*Loader to load the tables.

Repeat for each table you want to move.

Oracles loader is FAST! (On an NT I am able to load a 2.1 million row table with 6 indexes in under 20 minutes.) The loader is also a very versatile utility that can be used to validate and format your data while it is being loaded.

Jerry

braz wrote:
>
> Hi,
>
> We are looking to convert a database on our Digital machine that is running
> under RDB. We want to convert to Oracle 7.3 on a Sun box.
>
> What is the best way to "export" data from the RDB database and "import" it
> to Oracle 7.3??
> Is this even possible? Any methods suggested would be appreciated!
>
> Thanks much in advance,
> TLB
> mailto:braz_at_mnw.net
Received on Mon Oct 27 1997 - 00:00:00 CST