Perform Flashback Query

Restore Dropped Tables from the Recycle Bin

The recycle bin is enabled by default.

SQL> ALTER SYSTEM SET recyclebin = ON;

To disable for the entire database (not recommended):

SQL> ALTER SYSTEM SET recyclebin = OFF;

To enable the recycle bin for a session:

SQL> ALTER SESSION SET recyclebin = ON;

To disable the recycle bin for a session:

SQL> ALTER SESSION SET recyclebin = OFF;


Show recyclebin contents

To see the objects in the recyclebin:

SHOW RECYCLEBIN

Clear recyclebin

To remove all dropped objects from the recyclebin (current user):

PURGE RECYCLEBIN;

To remove all dropped objects from the recyclebin (system wide):

PURGE DBA_RECYCLEBIN;

Tables can also be droped without sending them to the recyclebin. Example:

DROP TABLE t1 PURGE;
Examples

Drop a table:

SQL> DROP TABLE t1;
      drop the table:

SQL> FLASHBACK TABLE t1 TO BEFORE DROP;

Migrating SQL Server to Oracle 11.2 using SQL Developer 3.2

Environment:

Microsoft SQL Server 2008
Oracle Database 11.2 on Linux 32-bit
SQL Developer 3.2


Download driver for JDBC.
http://www.oracle.com/technetwork/developer-tools/sql-developer/thirdparty-095608.html

Tools Menu --> Preferences --> Database -->Third Party JDBC Drivers -->
add Entry --> C:\jdbc\jtds-1.2.jar