| 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
|
|
|
|
| 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: 10708
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
