2. Connect to source oracle database server.
3. Connect to destination oracle database server(?).
4. Pull records from src. db. table.
5. For every record,
Insert that record into dest db table.
I need to do the above. But, the challenge, for me, here is... the names of src and dest. databases are SAME. so, how can I assign that name to the SqlDatabase variable when I prepare the second result set? In oracle, is there any way, I can refer to 2 database having the same name(residing on diff. box)? What are settings in the sql.ini file?
I am new to Oracle and need help on this pls.
Thanks in advance.
Presumably you can rename your DB names for each so they're different and describe which server is which. I think you already have a problem: If you have 2 DBs names FOO, and you:
Set SqlDatabase = 'FOO'
the SqlConnect() call (I'm guessing) would connect to the first one in the list.
Who is online
Users browsing this forum: [Ccbot] and 0 guests