Importing Exporting data from Orale 8.0

[cyberdyne]

I want a solution for importing and exporting data comming from different tables of oracle database. Oracle being used is verson 8.0

The basic Idea is
1. To transfer data from one office to another.
2. To take backups.

What I require is that for a perticular record data is scattered in multiple tables with one common field in each table. Now I want this whole record to be exported, and then Imported later at some other place. The table structure is same at both ends. While importing this data should be appended to other place as there may some data exsisting in tables.

All you brains can u help me ? This would be of great help
Thank you.

I can be contacted at cyberdyne@softhome.net

 

[Nebuchednezzar]

There may be an easier way that I'm not thinking of, but my suggestion is this...

Since you are pulling data from multiple tables on the source database, and you aren't wanting all records, I would do this...
create a script to select the rows you want, delimit fields by pipe symbol(|) or comma (or something like that), and spool results to file - be sure to turn off column headings, etc...

Then, you can send the file to the other machine, and use sqlload to pull the data into a table.
If this joined data is not in the format you want, you can have yet another script to pull the data out that you need and place it in the other tables.