Re: Importing and exporting

if you have a program loads the data into "a" database, why not make that same program load the data from the same "source" into the other database(which incidentally has the same structure) I believe your "source" must be files since you mention a "load" of data.

Nick Bull wrote:

> Hi.
>
> Can anyone help !
>
> What we are trying to do is set up a program that will run on a WIndows 95
> machine. This program will then connect to an Oracle 8 server on an NT
> machine. The program will populate the tables with a load of data, then we
> want to dump that data out into a text file. This text file is then to be
> sent off to another location (round the world) and then loaded into another
> Oracle server that has all the same table structures.
>
> Can anyone suggest the best way to do this ? Oh, it doesn't have to be a
> text file. Just some file that can be loaded back into Oracle.
>
> Cheers !
>
> Nick.
Received on Mon Apr 19 1999 - 08:15:25 CDT