Creaste a view based on v_$session

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Tue, 19 Sep 2000 15:44:33 GMT
Message-ID: <39c7893e.1888379046@news.alt.net>

I found a query via deja and it runs well. However, when I attempt to create a view, it gives me an error. Am I missing something?

Brian

SQL: CREATE OR REPLACE VIEW Check_Locks AS

	SELECT
		OWNER||'.'||OBJECT_NAME "Object",
		OS_USER_NAME "Terminal",
		ORACLE_USERNAME "Locker",
		PROGRAM "Program",
		NVL(lockwait,'ACTIVE') "Wait",
		DECODE(
                        LOCKED_MODE,
			2, 'ROW SHARE',
			3, 'ROW EXCLUSIVE',
			4, 'SHARE',
			5, 'SHARE ROW EXCLUSIVE',
			6, 'EXCLUSIVE',
                        'UNKNOWN'
                      ) "Lockmode",
		OBJECT_TYPE "Object Type",
		SESSION_ID "Session ID",
		SERIAL#  "Serial",
		C.SID
	FROM
		SYS.V_$LOCKED_OBJECT A,
		SYS.ALL_OBJECTS B,
		SYS.V_$SESSION C
	WHERE
		A.OBJECT_ID = B.OBJECT_ID AND
		C.SID = A.SESSION_ID
	ORDER BY
		1 ASC,
		5 Desc;

Error:
                SYS.V_$SESSION c
                    *

ERROR at line 24:
ORA-00942: table or view does not exist Received on Tue Sep 19 2000 - 10:44:33 CDT