| ORA-04063: view "SYSTEM.V" has errors [message #266743] |
Tue, 11 September 2007 09:33  |
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
|
Senior Member |
|
|
Dear experts,
I have compiled the followin gquery in sql prompt:
Details:oracle 9i,version 9.2.0.7.0,OS :Redhat linux
system user;
>select c.value || '/' ||instance || '_ora_' || ltrim(to_char(a.spid,'fm99999')) ||'.trc' TRCLOC from
v$process a, v$session b,v$parameter c, v$thread d where a.addr = b.paddr and b.audsid =
userenv('sessionid') and c.name = 'user_dump_dest'
it shows output:
/mnt/ora_test/oracle/admin/test/udump/test_ora_11546.trc
But i have run the same query in script it show followin error:
system user:(same above query)
Output:
select c.value || '/' ||instance || '_ora_' || ltrim(to_char(a.spid,'fm99999')) ||'.trc' TRCLOC from v
a, v b,v c, v c where a.addr = b.paddr and b.audsid = userenv('sessionid') and c.name = 'user_dump_dest'
*
ERROR at line 1:
ORA-04063: view "SYSTEM.V" has errors
- Thanx.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
