Quote:
11:53:52 SQL> conn n/siva
Connected.
11:53:59 SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
SYS_TEMP_FBT TABLE
11:54:02 SQL> create table a (no number(3),name varchar(10));
Table created.
11:54:24 SQL> insert into a values(10,'sdgfhdf');
1 row created.
11:54:36 SQL> insert into a values(11,'ueryer');
1 row created.
11:54:47 SQL> insert into a values(44,
11:54:53 2 'sdfhdj
11:54:56 3 ');
1 row created.
11:54:58 SQL> commit;
Commit complete.
11:55:04 SQL> show parameter undo_rete
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_retention integer 900
11:55:17 SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
A TABLE
SYS_TEMP_FBT TABLE
11:55:32 SQL> insert into a values(55,'ahfjaksd');
1 row created.
11:56:16 SQL> insert into a valueS(66,'adhjkda');
1 row created.
11:56:24 SQL> commit;
Commit complete.
11:56:27 SQL> select * from a as of timestamp to_timestamp('06/11/2007:11:55:04','dd/mm/yyyy:hh24:mi:ss');
select * from a as of timestamp to_timestamp('06/11/2007:11:55:04','dd/mm/yyyy:hh24:mi:ss')
*
ERROR at line 1:
ORA-08180: no snapshot found based on specified time
11:57:18 SQL> select * from a as of timestamp to_timestamp('06/11/2007:11:55:32 ','dd/mm/yyyy:hh24:mi:ss');
select * from a as of timestamp to_timestamp('06/11/2007:11:55:32 ','dd/mm/yyyy:hh24:mi:ss')
*
ERROR at line 1:
ORA-08180: no snapshot found based on specified time
11:57:38 SQL>
Why it is showing "snapshot not found" when i use any time? plz advice...