Re: flashback question

Eugene schrieb:
> Hi all,
> I have a question about flashback. For some reason it doesn't work?!
> Here is what I do:
>
> show parameter undo_retention;
> NAME TYPE VALUE
> ------------------------------------ ----------- -----
> undo_retention integer 5400
>
> create table t (varchar2(1));
> Table created.
>
> select dbms_flashback.get_system_change_number from dual;
> GET_SYSTEM_CHANGE_NUMBER
> ------------------------
> 2927483661
>
> insert into t values (1);
> 1 row created.
>
> insert into t values (2);
> 1 row created.
>
> select dbms_flashback.get_system_change_number from dual;
> GET_SYSTEM_CHANGE_NUMBER
> ------------------------
> 2927483700
>
> insert into t values(3);
> 1 row created.
>
> select dbms_flashback.get_system_change_number from dual;
> GET_SYSTEM_CHANGE_NUMBER
> ------------------------
> 2927483714
>
> commit;
> Commit complete.
>
> select * from t;
> A
> -
> 1
> 2
> 3
>
> delete from t;
> 3 rows deleted.
>
> commit;
> Commit complete.
>
> select * from t;
> no rows selected
>
> select * from t as of scn 2927483700;
> select * from t as of scn 2927483700
> *
> ERROR at line 1:
> ORA-01466: unable to read data - table definition has changed
>
> ----------------------------------------------
> Why didn't it work??? Did I do something wrong?
> ----------------------------------------------
>
> Thanks,
> Eugene
>

It depends on Oracle version you are working with, in 9iR2 for example you should wait about 5 min after table was created to avoid this error. You may find interesting the comment of Jonathan Lewis in thread http://groups.google.de/group/comp.databases.oracle.server/browse_frm/thread/9a32d6aad92cc174/35c4d8b40047baa8?q=event+10311&rnum=1&hl=de#35c4d8b40047baa8

Best regards

Maxim Received on Tue Aug 09 2005 - 00:59:59 CDT