Cursor Load

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bujjus173@gmail.com - 25 Sep 2007 18:21 GMT

Hi,
I like to load data from one table in a database in a server into
another table in another database residing in another server. I like
to use cursor load. in that case.
1) Do i need to catalog the target database.
2) Can i do it online.

Any suggestions. This might be simple. I am new to this. Please help
me.
Thank You
Vijay

Reply to this Message

Sanjuro - 25 Sep 2007 18:58 GMT

On Sep 25, 12:21 pm, bujjus...@gmail.com wrote:

> Hi,
> I like to load data from one table in a database in a server into
[quoted text clipped - 7 lines]
> Thank You
> Vijay

You 'll need nicknames (federation) for the target tables at the
source location (or vice versa) to be able to use cursors for this
kind of load. An easier option would be to export in 'ixf' or 'del'
format and ftp and then load.

~sanjuro

Reply to this Message