populating table based on v$session
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>,<oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Tue, 05 Dec 2006 10:59:04 -0500
Here is my error any ideas why the error:
doing session
old 38: , '&&lv_host_name', '&&lv_instance_name', SYSDATE
new 38: , 'RTA14', 'or14', SYSDATE
from V$SESSION sess
*
ERROR at line 39:
ORA-02070: database EMGR does not support operator USERENV in this
context
The sql is:
prompt doing session
INSERT into rta.lms_V$SESSION@emgr
( SADDR
, SID
, PADDR
, USER#
, USERNAME
, COMMAND
, STATUS
, SERVER
, SCHEMANAME
, OSUSER
, PROCESS
, MACHINE
, TERMINAL
, PROGRAM
, TYPE
, LAST_CALL_ET
, LOGON_TIME
, machine_id , db_name , timestamp)
SELECT
SADDR
, SID
, PADDR
, USER#
, USERNAME
, COMMAND
, sess.STATUS
, SERVER
, SCHEMANAME
, OSUSER
, PROCESS
, MACHINE
, TERMINAL
, PROGRAM
, TYPE
, LAST_CALL_ET
, LOGON_TIME
, '&&lv_host_name', '&&lv_instance_name', SYSDATE
from V$SESSION sess ;
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
Other related posts:
