CODEWITHSUNDEEP
sqldatabaseoracle-databaseplsqlflashback
Masum Billah
Masum Billah

Reputation: 135

I am having an error while I use flashback

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

Upvotes: 0

Views: 375

Answers (1)

Barbaros Özhan
Barbaros Özhan

Reputation: 65373

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.

Upvotes: 3

Related Questions