leshanster_at_gmail.com wrote:
> Hey guys, sorry to bother you again, but I am coming into a problem
> that I don't know how to fix.
>
> I create a table by saying:
>
> create table a (b number);
>
> and a table is created and I can view the table by using:
>
> select table_name from user_tables;
>
> then I drop the table by using:
>
> drop table a;
>
> commit;
>
> then when I view the list of tables I have, I get:
> TABLE_NAME
> -----------------------------------------
> BIN$XZFPbjldRmm5fzdo3pJpnA==$0
>
> for every table I create and drop I get this...
>
> any ideas on how to solve this problem?
It is not a problem. If is just functionality you are not aware of.
Go to www.psoug.org and click on Morgan's Library
Look at the demos under RECYCLEBIN and TABLE FLASHBACK.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Jan 29 2006 - 13:24:31 CST
