And for getting machine name one can use sys_context('USERENV', 'HOST').
Alex Hillman
-Original Message-
Sent: Wednesday, April 18, 2001 2:22 PM
To: Multiple recipients of list ORACLE-L
Charlie,
Now that's a good question. The best answer I can come up with is to
check
the
I already thought of your suggestion but know that it won't be foolproof;
at least for my evironment.
I have a DBLINK that allows my developers to use the SQL*PLUS "COPY"
to reference tables "on the local machine". In other words, I'd like a
way to discern the difference between
SQL connect
Hi,
Unfortunately this doesn't work for NT.
Under NT using 817, the program field from v$process always seems to show
Oracle.exe.
Using v$session.program you can determine if a user is using svrmgrl but I
do not know how to
Also, the terminal and machine fields show the same values.
Is there
Title: RE: Direct Vs. SQL*net
see answer below
-Original Message-
From: Reardon, Bruce (CALBBAY)
[mailto:[EMAIL PROTECTED]]
Unfortunately this doesn't work for NT.
Under NT using 817, the program field from v$process always
seems to show
Oracle.exe.
Using v