Re: How to export RDB data into Oracle 7?

Bill Morgan wrote:
>
> I have an RDB v6.0 database with about 120,000 records. How can I export the
> data into an Oracle 7 table? Please email any responses as well as posting to
> this group. Many thanks!
>
> ---------------------------------------------------------------------------
> William E. Morgan NAVAL SURFACE WARFARE CENTER
> Code N83 email: wmorgan_at_nswc.navy.mil
> 17320 Dahlgren Rd. phone: (540)653-8446,(540)653-7151
> Dahlgren, VA 22448 fax: (540)653-1810

Since there are such few number of records try:

From Rdb SQL:
set output out.file
select '"'||text_field||'",'||number_field||',"'||cast(date_field as date ansi)||'",'....
set nooutput

edit the file and use global sear&replace to replace the " with ' The use sqlloader to load the data.

Piece of cake.

Micahel Austin
An Indendent Database Consultant
I specailize in Rdb and can just as easily function with Oracle7.
austin_at_inmind.nospam.com
-- to respond, remove the .n o s p a m from my address --- Received on Fri Feb 27 1998 - 00:00:00 CET