All, I got a problem with v$recover_file. Somehow the
query failed if selecting is on ONLINE column.
SQL> desc v$recover_file;
Name Null? Type
----------------------------- --------
---------------
FILE# NUMBER
ONLINE VARCHAR2(7)
ERROR VARCHAR2(18)
CHANGE# NUMBER
TIME DATE
These are OK:
-------------------
select CHANGE# from v$recover_file;
select TIME from v$recover_file;
select * from v$recover_file;
However these gave me error:
------------------------------------
select ONLINE from v$recover_file;
select online, ERROR from v$recover_file;
select FILE# , ONLINE,ERROR , CHANGE#,TIME from
v$recover_file;
*
ERROR at line 1:
ORA-00936: missing expression
SQL> select v.name, b.online
2 from v$datafile v, v$recover_file b
3 where v.file# = b.file#;
select v.name, b.online
*
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or
column specification
What's happening?! Thank you.
Andrea
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrea Oracle
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
