-
ORA-00911: invalid character while typing select name from v$tempfile;
Hi,
I am getting strange errors while accessing the V$ views each time I access them throws me some or the other error why Oracle behaves like this?
Oracle: 9.2.0.7
Unxi :Aix5.2
SQL> select name from v$tempfile;
select name from v$tempfile
*
ERROR at line 1:
ORA-00911: invalid character
SQL> select Name from v$tempfile;
NAME
--------------------------------------------------------------------------------
/u07/oradata/sreport/wsadatatemp02.dbf
/u06/oradata/srep/wsadatemp01.dbf
/u10/oradata/sreport/wsadatatemp03.dbf.dbf
SQL> select name from v$tempfile;
select name from v$tempfile
*
ERROR at line 1:
ORA-00911: invalid character
DBAs> select any_idea " why it throws me error " from dba_support.com;
no rows selected
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|