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.
Showing posts with label undrop. Show all posts
Showing posts with label undrop. Show all posts
Tuesday, February 13, 2007
Subscribe to:
Comments (Atom)