Won,
Yes, schema to schema.
I'm attempting a join across databases. These databases used to be on the same
server with different owners.
They just moved our app to another server, and now I have to use a DB link to
get the same join to work.
The outcome of these queries is an internal
Qasim, what's up? How's the Triangle?
I get it now. I didn't realize the connection was session independent.
I have noticed that i can let the link persist across sessions from my PL/SQL
client...I didn't realize that was the case when I first wrote this question.
But it has to be run FROM
We do this all the time with one of our government clients.
Unfortunately I have no good idea as to how it was setup (their DBAs
handle that part).
What I can say is
1) When we have cross-schema joins it is done using proper FKs setup
between the schemas
2) permissions involve SELECT and
Can't you just get the DBA to create the dblink?
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 6 August 2010 03:23, Dave P jda...@gmail.com wrote:
Qasim, what's up? How's the Triangle?
I get it now. I didn't realize the connection was session independent.
I
Hello all,
Has anyone actually gotten a database link working from a CF server to a second
oracle server?
I'm trying a connection string:
create database link prodlink connect to myusername identified by mypass
using 'PROD';
and getting:
Error Executing Database Query.
Executing the SQL
-
From: Dave P [mailto:jda...@gmail.com]
Sent: Wednesday, August 04, 2010 8:12 AM
To: cf-talk
Subject: oracle database link
Hello all,
Has anyone actually gotten a database link working from a CF server to a
second oracle server?
I'm trying a connection string:
create database link prodlink
I assume you mean a link from one oracle schema to another schema by
executing the CREATE DATABASE LINK sql command through a CFML page.
Is this correct? If it is check your permissions. This most likely has
nothing to do with CF. As I side note, I don't think CFML pages should be
running
As someone already indicated, why do you want to run db link command from
CF. It should be just a one time thing that your DBA can run. Later you can
run query against a table in linked database like this
SELECT *
FROM
On Wed, Aug 4, 2010 at 9:58 AM, Won Lee won...@gmail.com wrote:
I assume
My last email was incomplete
SELECT *
FROMyourtableinlinke...@nameofdblink
On Wed, Aug 4, 2010 at 8:25 PM, Qasim Rasheed qasim.li...@gmail.com wrote:
As someone already indicated, why do you want to run db link command from
CF. It should be just a one time thing that your DBA can run.
9 matches
Mail list logo