| 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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
