I don't "undrop" table a lot. So once when I tried to "undrop" a table, I got an error:
sql> undrop table test1;
SP2-0734:unknown command beginning "undrop tab..." - rest of line ignored.
Well, I soon found, it's not "undrop", instead:
SQL> flashback table test1 to before drop rename to test2;
Flashback complete.
You can rename it if the previous name has been used by others.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment