COPYING between databases

[Former Member]

I am trying to copy content of one DB table into an other DB table how can i do this?

tables are same dadabases are different. they are oracle database.

help!!!!SOS!!!!

[Former Member]

Besides the standard SAP transport mechanism you could also create a so-called 'Database link' between the two DB's (see oracle help on how to do this). Then you can access the source DB from the target DB and do a statement like this:

insert into (targettable) select * from (sourcetable)@(db-link).

However, this is only a just-in-time copy, but one that works fast also with loads of data.

Regards, Kai

[Former Member]

Create in the system source the file: export.ctl

Export

File = '[PATH] export.dat'

Client = xxx

Select * from table;

And in the system target create the file: import.ctl

Import

File = '[PATH] export.dat'

Client = xxx

Then execute in the source systems:

R3trans -w export.log export.ctl

This creates a file named export.dat, copy this file to target system and execute in the target system:

R3trans -w import.log import.ctl

[Former Member]

Hi

Export source table U will get a dump file. Import the same in to target database.

For help exp help=y and imp help=y u can find a list of parameters

Regards

vinod