I am having an error while I use flashback

Question

I am having error while I try to use flashback; I am using oracle SQL

I dropped the table called fixer then I want to get it back , So I use flashback , But I got an error below,

Error starting at line : 52 in command - Flashback Error report - ORA-00905: missing keyword 00905. 00000 - "missing keyword" *Cause:
*Action:

Cheers

Answer 1

The correct syntax to get the table back is :

flashback table fixer to before drop;

I presume, probably to keyword is missing in your statement :

flashback table fixer before drop;

and ORA-00905 raised due to this.