DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: FLASHBACK problem.

  1. #1
    Join Date
    Jul 2007
    Posts
    32

    FLASHBACK problem.

    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,

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you are trying to go back a month, bet you dont have a months worth of retention

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width