RE: Direct Vs. SQL*net

2001-04-18 Thread Hillman, Alex
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

Re: Direct Vs. SQL*net

2001-04-18 Thread Charlie Mengler
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

RE: Direct Vs. SQL*net

2001-04-18 Thread Reardon, Bruce (CALBBAY)
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

RE: Direct Vs. SQL*net

2001-04-18 Thread Jacques Kilchoer
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