OraFAQ Forum: Server Administration » Create a view base on a v

Home » RDBMS Server » Server Administration » Create a view base on a v_$session

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create a view base on a v_$session [message #52696]

Wed, 07 August 2002 04:09

Laurent Reumaux
Messages: 1
Registered: August 2002

Junior Member

Hi,
I am trying to create a local view base on v$session. When I run the subquery alone, it works. But as soon as I try to create the view, I have the message that my "table or view does not exist".

I can successfully create some views base on other SYS view like All_catalog, except v_$**** view.

Here are the simplify code :

CREATE OR REPLACE VIEW v_process (Process) as
select process from sys.v_$session

best regards,
Laurent

Report message to a moderator

Re: Create a view base on a v_$session [message #52700 is a reply to message #52696]

Wed, 07 August 2002 05:05

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

works fine for me!.
are u having the dba privs?

local@ > CREATE OR REPLACE VIEW v_process (Process) as 
  2  select process from sys.v_$session
  3  
local@ >/

View created.

local@ >select * from v_process;

PROCESS
---------
812
816
820
828
824
840
948:1368

7 rows selected.

Report message to a moderator

Previous Topic:	install oracle 9.01 on solaris 5.8
Next Topic:	Memory problem?!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 12:04:12 CDT 2024