Hi all,

Version 10.2.0

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...
TIA,