time based recovery not working for table droped any1 can help me?
hiim trying
<!--
@page { margin: 0.79in }
P { margin-bottom: 0.08in }
--time based recovery – a
table is dropped which you
need to recover so i did the following steps bt still it never worked can any1 help me??
thanx in advance
SQL> create table emp(id number);
Table created.
SQL> insert into emp values(1);
1 row created.
SQL> set time on
09:28:07 SQL> commit;
Commit complete.
09:28:09 SQL> drop table emp;
Table dropped.
09:28:18 SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
09:29:07 SQL> startup mount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218292 bytes
Variable Size 75499788 bytes
Database Buffers 83886080 bytes
need to recover so i did the following steps bt still it never worked can any1 help me??
thanx in advance
SQL> create table emp(id number);
Table created.
SQL> insert into emp values(1);
1 row created.
SQL> set time on
09:28:07 SQL> commit;
Commit complete.
09:28:09 SQL> drop table emp;
Table dropped.
09:28:18 SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
09:29:07 SQL> startup mount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218292 bytes
Variable Size 75499788 bytes
Database Buffers 83886080 bytes
0