To Bradd Piontek, Great to see your commendation....

2009-09-01T05:58:52.757+07:00

To Bradd Piontek,

Great to see your commendation. Actually I hope I see new article on your blog;)

About Flashback (Production).. I have a chance use Flashback Drop only ;)
Good... no problem on my database. So, I don't have a chance use other (flashback).

And we enabled flashback database, But We use nologging on some tablespaces, So we disabled it.

Thank You so much. I missed it... and I tested It...

2009-09-01T05:33:19.429+07:00

Thank You so much. I missed it...
and I tested It on 10gR2 as well.
It's work.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0

SQL> create table test tablespace users as select * from all_objects;

No problem. I did a rather lengthy Demo of Flashba...

2009-09-01T05:11:38.514+07:00

No problem. I did a rather lengthy Demo of Flashback features in 10g at my last job. Never did turn it into a blog. It covers:
Flashback Transaction Query
Flashback Query (Statement)
Flashback Query (session)
Flashback Query (versions)
Flashback Drop
Flashback Table

I didn't go into Flashback Database as it is a bit different than the other flashback

It is possible I'm missing a subtle different ...

2009-09-01T04:48:04.266+07:00

It is possible I'm missing a subtle different between 11g and 10gR2, but I am pretty sure you can do this in 10gR2. In fact, I wrote a demo of this back in 2007.

Comments on Surachart Opun's Blog: Rewinding a Table Using Oracle Flashback Table

To Bradd Piontek, Great to see your commendation....

Thank You so much. I missed it... and I tested It...

No problem. I did a rather lengthy Demo of Flashba...

It is possible I'm missing a subtle different ...