Re: Flashback queries

2003-12-24 Thread Jonathan Lewis
9:44 PM > It's been awhile since I've looked at flashback queries, and > I have a couple questions: > > * Given an SCN, is there any way to know for certain whether > a flashback query to that SCN is possible? Can a non-DBA > user determine this? > No, not without doi

Flashback queries

2003-12-24 Thread Jonathan Gennick
It's been awhile since I've looked at flashback queries, and I have a couple questions: * Given an SCN, is there any way to know for certain whether a flashback query to that SCN is possible? Can a non-DBA user determine this? * Is there an easy way to determine how much undo data my d