OraFAQ Forum: Backup & Recovery » Flashback Version Query

Home » RDBMS Server » Backup & Recovery » Flashback Version Query (Oracle 10g / windows)

Tue, 11 October 2011 09:36

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

Tue, 11 October 2011 09:39

BlackSwan
Messages: 20108
Registered: January 2009

Senior Member

post results from following

SQL> DESC SCOTT.DEPT

Tue, 11 October 2011 09:57

flyboy
Messages: 1670
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.

Wed, 12 October 2011 03:21

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 May 24 03:18:07 CDT 2013

Total time taken to generate the page: 0.29912 seconds