Home » RDBMS Server » Backup & Recovery » Flashback Version Query (Oracle 10g / windows)
Flashback Version Query [message #526551] Tue, 11 October 2011 09:36 Go to next message
Karlia
Messages: 40
Registered: May 2011
Location: Algiers
Member
Hi,

Can someone tell me why does this query not work

select versions_startscn, versions_endscn,  loc
from scott.dept;


it returns this :

ERROR at line 1:
ORA-00904: "VERSIONS_ENDSCN": invalid identifier

Thanks
Re: Flashback Version Query [message #526555 is a reply to message #526551] Tue, 11 October 2011 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results from following

SQL> DESC SCOTT.DEPT
Re: Flashback Version Query [message #526558 is a reply to message #526551] Tue, 11 October 2011 09:57 Go to previous messageGo to next message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
It really helps if you read documentation before attempting to use some new features.
VERSIONS_* pseudocolumns are described in SQL Reference book, which is available with other Oracle documentation e.g. online on http://tahiti.oracle.com/
For 10gR2, they are documented here: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/pseudocolumns003.htm#i1009358
Quote:
The version query pseudocolumns are valid only in Oracle Flashback Version Query, which is a form of Oracle Flashback Query.
For the definition of the term in bold, search in the same book. Note, that your query is not that one.
Re: Flashback Version Query [message #526643 is a reply to message #526558] Wed, 12 October 2011 03:21 Go to previous message
Karlia
Messages: 40
Registered: May 2011
Location: Algiers
Member
Indeed, i omissed to put

 SCN INTERVAL CLAUSE


So, my query should be the following :

select versions_startscn, versions_endscn,  loc
from scott.dept
VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE;

Thanks to every body

Previous Topic: block change tracking file - when it is used?
Next Topic: RMAN
Goto Forum:
  


Current Time: Fri Mar 29 05:34:49 CDT 2024