OraFAQ Forum: Enterprise Manager » Flashback Database

Home » RDBMS Server » Enterprise Manager » Flashback Database (os:windows 7 , Version : SQL*Plus: Release 10.2.0.5.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Flashback Database [message #507211]

Fri, 13 May 2011 03:18

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

one of my user POM create one table

using this statement

12:55:59 SQL> create table hello_world (emp_id number(4), emp_name varchar2(30))
;

Table created.

then insert some raw into this hello_world table

12:56:41 SQL> insert into hello_world values (1, 'Bill Gates');

1 row created.

12:57:51 SQL> insert into hello_world values (2, 'Steve Jobs');

1 row created.

13:00:32 SQL> insert into hello_world values (3, 'Chris Eaton');

1 row created.

13:01:19 SQL> commit;

Commit complete.

then i have drop this hello_world table

13:02:08 SQL> drop table hello_world;

Table dropped.;

then i have to connect with sys user

13:03:03 SQL> conn sys as sysdba
Enter password:

13:08:21 SQL> select current_timestamp from dual;

CURRENT_TIMESTAMP
---------------------------------------------------------------------------
13-MAY-11 01.10.21.691000 PM +05:30

13:10:21 SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
13:11:35 SQL>

13:11:35 SQL> startup mount;
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size 1304848 bytes
Variable Size 301991664 bytes
Database Buffers 947912704 bytes
Redo Buffers 7081984 bytes
Database mounted.
13:12:48 SQL>

13:17:57 SQL> flashback database to timestamp to_timestamp('13-05-2011 13:01:19'
,'DD-MM-YYYY HH24:MI:SS');

Flashback complete.

13:20:10 SQL> alter database open resetlogs;

Database altered.

13:21:23 SQL> show user
USER is "SYS"
13:21:57 SQL>
13:21:57 SQL> conn pom/pom
Connected.

13:22:21 SQL> select * from tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
HELLO_WORLD TABLE

13:22:50 SQL> select * from hello_world;

no rows selected
==========================================================================================

i flashback my this HELLO_WORLD table but why i cannot Flashback RAW of this table can anyone give me solution what can i do if
i want to flashback raw of this table
which query i have to run

Report message to a moderator

Re: Flashback Database [message #507218 is a reply to message #507211]

Fri, 13 May 2011 04:22

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Still no version
Still not formatted.

There are many Oracle times (scn) in a second.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator