Search This Blog

Tuesday, January 29, 2013

Loading records from one oracle database to another using oracle sql developer tool

The source and the destination databases are in different OS platforms. go to table->data(record) In one of the records, do a right click click on "export" tick 'export data' format: insert line terminator: environment default save as single file browse and choose the destination folder to place the output file Encoding: Cp1252/default click next click finish you will see a script click on "run script" Connection: destination connection click "ok"

No comments:

Post a Comment