3

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
Stelios
  • 389
  • 1
  • 5
  • 14

1 Answers1

6

No you cannot. To restore a table from the recycle bin use flashback table <table_name> to before drop;

<table_name> is the original table name and not the object_name from the recycle bin.

Do not rename the table to restore it from the recycle bin!

o0x258
  • 1,324
  • 6
  • 10