Skip to content
≡

Administrator

Developer

Tools

External Tools

FLASHBACK TABLE

FLASHBACK TABLE#

Syntax#

flashback_table ::=#

Prerequisites#

At least one or more of the following conditions must be met:

  • The SYS user

  • The users with the CREATE TABLE or CREATE ANY TABLE system privilege in their own schema.

  • The users with the CREATE ANY TABLE system privilege in another user's schema.

Description#

FLASHBACK TABLE recovers tables from the recycle bin. If there are several tables with the same name, the first table that was dropped is recovered to the database.

table_name#

This specifies the name of the table to be recovered from the recycle bin. The table takes the name it had before it was moved, or a new name generated by the system when it was moved to the recycle bin. If there are several tables with the same name, the first table that was moved to the recycle bin is recovered to the database.

RENAME TO table_name#

The user can specify a new name for the table when it is recovered; if the same name exists in the user's schema, the name can be altered.