populating tables based on some v$ views

  • 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:34:27 -0500

I create some tables similar to their v$ version which I want to
populate.  Here is one example - any idea why I am getting the error.
 
SQL> l
  1  INSERT into rta.lms_V$VERSION@emgr
  2  ( banner
  3  )
  4  SELECT
  5    banner
  6* from V$VERSION
SQL> /
SELECT
 *
ERROR at line 4:
ORA-02070: database EMGR does not support operator USERENV in this
context
 

SQL>
 
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113

Other related posts: