Dear All, I tried 10g "FLASHBACK TABLE RECYCLETEST TO BEFORE DROP;". It did not work in 9i client but it worked in TOAD. I guess SQL*plus client interprets the command and TOAD is not doing that. C:\>sqlplus sami/sami@linux SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 9 20:46:13 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> show recyclebin SP2-0158: unknown SHOW option "recyclebin" SQL> FLASHBACK TABLE RECYCLETEST TO BEFORE DROP; SP2-0734: unknown command beginning "FLASHBACK ..." - rest of line ignored. SQL> SQL> Thanks Say ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------