populating tables based on some v$ views

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 05 Dec 2006 10:34:27 -0500
Message-Id: <s5754b4d.037@groupwise.gcrta.org>

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_at_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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 05 2006 - 09:34:27 CST