Home » SQL & PL/SQL » SQL & PL/SQL » V$RECOVER_FILE Problem
V$RECOVER_FILE Problem [message #159] Tue, 22 January 2002 05:35 Go to next message
Raj
Messages: 411
Registered: November 1998
Senior Member
Select online from V$recover_file ;
gives error even though its a valid column of the view. How to overcome this problem as oracle seem to take this column as metacharacter??
Re: V$RECOVER_FILE Problem [message #162 is a reply to message #159] Tue, 22 January 2002 06:37 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

Hi online is a keyword, so parser is giving error.so,try this

SELECT "ONLINE" FROM v$recover_file;

but to just remind you the next statement is not going to work.

SELECT "online" FROM v$recover_file;

hope it helps

cheers
pratap
Previous Topic: Dynamic creatig a users
Next Topic: SQL_TRACE setting
Goto Forum:
  


Current Time: Fri Mar 29 10:19:09 CDT 2024