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