What are you trying to do ?




"Sudheer
Padinhare To: "LazyDBA.com Discussion" <[Email Address Removed]
Covilakam" cc:
<[Email Address Removed] Subject: RE: Help reqd
om>

31/01/02 08:18








Hi

This is not working
regards/sudheer

SQL> SELECT * FROM v$SESSION WHERE AUDSID = (select sys_context
('USERENV','SESSI
ONID') from dual);
SELECT * FROM v$SESSION WHERE AUDSID = (select sys_context
('USERENV','SESSIONID'
) from dual)

ERROR at line 1:
ORA-00942: table or view does not exist
-----Original Message-----
From: Ganesh Raja [mailto:[Email Address Removed] Thursday, January 31, 2002 12:54 PM
To: LazyDBA.com Discussion
Subject: RE: Help reqd

SELECT * FROM v$SESSION WHERE AUDSID = (select sys_context
('USERENV','SESSIONID') from dual);

Remeber the AudSid for SysDBA is 0.

Best Regards,
Ganesh R
Tel  : +971 (4)  397 3337  Ext 420
Fax : +971 (4)  397 6262
HP  : +971 (50) 7456019

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html



Oracle LazyDBA home page