Hello,
we have a well running system with connection to an oracle database. (this was not setup be me).
Now i have 2 questions, and i didn't find an answer by searching in this forum up to now:
1) Is it possible to have connections defined to more than 1 database?
So that i could read data from a table in database "A" and write the data in a table of database "B"?
2) If yes, could anybody give me a detailed description (for a beginner in this area), in which config or setup files i have to add what kind of entry to make a new database connection?
Hello,
thanks for your feedback.
I read it several times, but it is still a riddle, what you wanted to tell me.
My hope was, to get i possible more detailed answers, especially, which entries in which are necessary.
Manfred
You can connect to whatever instances are defined in your server's tnsnames.ora file. If you need more, add them, usually by enlisting the aid of your DBA to do that for you.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Hi Chulett,
if it is only the tnsnames.ora then i have no further question.
I expected that i would have to update several datastage environment files.