Can you use "RENAME" instead of "FLASHBACK TABLE" to restore a table in Oracle?

3 votes

1 answer

2321 views

                          Just a general question about flashback and the recycle bin in Oracle.  I tried doing this on a demo oracle database I have but the recycle bin does not seem to want to be populated; and I want a quick answer.

One can do the following:

    flashback table table_name to before drop;
    alter index "BIN$U/9fvJKaASzgQKjAYAIWhw==$0" rename to sys_c1113050;

Can you do this then, to restore a table:

    RENAME TABLE BIN$U/9fvJKaASzgQKjAYAIWhw==$0 TO TABLE_NAME

Asked by Stelios (389 rep)

Jan 21, 2015, 02:24 PM
Last activity: Jan 21, 2015, 02:51 PM

Can you use "RENAME" instead of "FLASHBACK TABLE" to restore a table in Oracle?

Related Questions