Hi Tom,
        You are doing a great job.I am learning so much stuff from your website. Here is my issue..
I am receiving ORA-01466 when I tested your example in my test database (9.2.0.6).My undo settings are

undo_management                      string      AUTO
undo_retention                       integer     10800
undo_suppress_errors                 boolean     FALSE
undo_tablespace                      string      UNDOTBS1

I have enough free space in undo tablespace.

***********************************************************

SQL> create table test1 (empid number,ename varchar2(20),esal number);

Table created.

SQL> insert into test1 values (&i,&n,&s);
Enter value for i: 1
Enter value for n: 'SMITH'
Enter value for s: 1000
old   1: insert into test1 values (&i,&n,&s)
new   1: insert into test1 values (1,'SMITH',1000)

1 row created.

SQL> /
Enter value for i: 2
Enter value for n: 'GEORGE'
Enter value for s: 2000
old   1: insert into test1 values (&i,&n,&s)
new   1: insert into test1 values (2,'GEORGE',2000)

1 row created.

SQL> /
Enter value for i: 3
Enter value for n: 'TIM'
Enter value for s: 3000
old   1: insert into test1 values (&i,&n,&s)
new   1: insert into test1 values (3,'TIM',3000)

1 row created.

SQL> /
Enter value for i: 4
Enter value for n: 'HANK'
Enter value for s: 4000
old   1: insert into test1 values (&i,&n,&s)
new   1: insert into test1 values (4,'HANK',4000)

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test1;

     EMPID ENAME                      ESAL
---------- -------------------- ----------
         1 SMITH                      1000
         2 GEORGE                     2000
         3 TIM                        3000
         4 HANK                       4000

SQL> variable n number
SQL> exec select dbms_flashback.get_system_change_number into :n from dual;

PL/SQL procedure successfully completed.

SQL> print n

         N
----------
   7825696


SQL> update test1 set esal=esal*2;

4 rows updated.

SQL> commit;

Commit complete.

SQL> select * from test1;

     EMPID ENAME                      ESAL
---------- -------------------- ----------
         1 SMITH                      2000
         2 GEORGE                     4000
         3 TIM                        6000
         4 HANK                       8000

SQL> select a.ename,a.esal new_sal,b.esal old_sal from test1 a, test1 as of scn :n b
  2  where a.empid=b.empid;
select a.ename,a.esal new_sal,b.esal old_sal from test1 a, test1 as of scn :n b
                                                  *
ERROR at line 1:
ORA-01466: unable to read data - table definition has changed


 

When I drop a table I see both the table and index in the recyclebin:

SQL> select object_name,type from recyclebin;

OBJECT_NAME                    TYPE
------------------------------ -------------------------
BIN$FpUFLdu5Vr7gRAADupYrZw==$1 INDEX
BIN$FpUFLdu6Vr7gRAADupYrZw==$0 TABLE

SQL> flashback table t1 to before drop;

Flashback complete.

SQL> select index_name from user_indexes;

INDEX_NAME
------------------------------
BIN$FpUFLdu5Vr7gRAADupYrZw==$1

But when I look at user_indexes I see the new name not the original index name.  What do I have to do to get it back to the original, drop & recreate? 

SQL> -- Create the tables and display their content --
SQL> 
SQL> create table t1 enable row movement
  2  as select level val from dual connect by level <=3
  3  /
Table created.
SQL> create table t2 enable row movement
  2  as select level val from dual connect by level <=3
  3  /
Table created.
SQL> exec dbms_lock.sleep(10);
PL/SQL procedure successfully completed.
SQL> select * from t1;
          VAL
-------------
            1
            2
            3

3 rows selected.

SQL> select * from t2;
          VAL
-------------
            1
            2
            3

3 rows selected.

SQL> col scn new_value scn
SQL> SELECT dbms_flashback.get_system_change_number scn FROM DUAL;
          SCN
-------------
4339478652078

1 row selected.

SQL> def scn
DEFINE SCN             = 4339478652078 (NUMBER)
SQL> 
SQL> -- Modify data --
SQL> 
SQL> delete t1 where mod(val,2)=0;
2 rows deleted.
SQL> commit;
Commit complete.
SQL> update t2 set val=val*val;
5 rows updated.
SQL> commit;
Commit complete.
SQL> select * from t1;
          VAL
-------------
            1
            3

2 rows selected.

SQL> select * from t2;
          VAL
-------------
            1
            4
            9

3 rows selected.

SQL> 
SQL> -- Flashback both tables at the same time --
SQL> 
SQL> flashback table t1,t2 to scn &scn;

Flashback complete.

SQL> select * from t1;
          VAL
-------------
            1
            2
            3

3 rows selected.

SQL> select * from t2;
          VAL
-------------
            1
            2
            3

3 rows selected.