recover dropped table

[Roshan]

Oracle Database 12.1.0.2
RHEL 7.4

Hi Erman,

is there a way I can recover a dropped table if no flashback has been enabled?

Regards,

Roshan

[ErmanArslansOracleBlog]

is your recyclebin off?

[Roshan]

No it is on

SQL> show parameter RECYCLEBIN

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
recyclebin                           string      on
SQL>

[Roshan]

CONTENTS DELETED

The author has deleted this message.

[Roshan]

BIREPORT         BIN$dTOOorUddl3gU0YAfAoIrA==$0     CBS_SUM_DUN2 DROP   TABLE   DATA4      2018-04-27:10:51:55 2018-09-06:15:54:45 2.3493E+11     YES YES       93102       93102        93102      20480

[ErmanArslansOracleBlog]

ok. recycle bin is on.. What happens when you issue the command -> "FLASHBACK TABLE <YOUR_TABLE_NAME> TO BEFORE DROP;"

[Roshan]

Thanks, object successfully recovered.

If the table is not in recycle bin, what should I do?

[ErmanArslansOracleBlog]

You may use your backups..