I liked it better in the 10g beta (before marketing got it)... Pretty sure it was just "undrop MY_TABLE" in the version that I originally had On 6/17/05, Sinardy <all_about_oracle@xxxxxxxxxx> wrote: > > SQL> flashback table mytab to before drop; > > Flashback complete. > -- Connor McDonald =========================== email: connor_mcdonald@xxxxxxxxx web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- //www.freelists.org/webpage/oracle-l