Home » RDBMS Server » Enterprise Manager » Flashback Database (os:windows 7 , Version : SQL*Plus: Release 10.2.0.5.0)
Flashback Database [message #507211] Fri, 13 May 2011 03:18 Go to next message
x-oracle
Messages: 332
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
Re: Flashback Database [message #507218 is a reply to message #507211] Fri, 13 May 2011 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 59203
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
Re: Flashback Database [message #507245 is a reply to message #507218] Fri, 13 May 2011 06:31 Go to previous messageGo to next message
x-oracle
Messages: 332
Registered: April 2011
Location: gujarat
Senior Member
ok my version is this

SQL*Plus: Release 10.2.0.5.0
ok
Re: Flashback Database [message #507283 is a reply to message #507245] Fri, 13 May 2011 08:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ok
Re: Flashback Database [message #507483 is a reply to message #507283] Mon, 16 May 2011 02:47 Go to previous message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
@OP
http://www.orafaq.com/node/1847
Michel already answered you question
Quote:
There are many Oracle times (scn) in a second.



Sriram
Previous Topic: Enterprise manager installation
Next Topic: Erorr in Grid control installation
Goto Forum:
  


Current Time: Tue Sep 23 19:27:29 CDT 2014

Total time taken to generate the page: 0.05881 seconds