query on show recyclebin command.
673860Apr 20 2009 — edited Apr 20 2009Hi,
I have created a table and then I have dropped it. after that I have issued a commit statement as well, now I am trying to view my dropped table using command show recyclebin table_name, but I am not able to get the information about my table.
the output should come like.
show recyclebin emp1;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- --------------------------------------------- ------------------- -----------------
EMP1 BIN$rHfcdmo4QGy64Z2+uFqxXQ==$0 TABLE 2009-10-16:15:13:38
but I am getting error in TOAD as invalid SQl statement.
please help on this.