Re: recyclebin problem.

Chuck wrote:
> oracle 10.2.0.3, recycelbin parameter is on. I drop a table in an
> non-system LMT but nothing is in the recyclebin. What am I missing here?
>
> SQL> show parameter recyclebin
>
> NAME TYPE VALUE
> ----------- ----------- ------------------
> recyclebin string on
>
> SQL> create table mytable as select * from dba_users;
>
> Table created.
>
> SQL> select tablespace_name from user_tables where table_name = 'MYTABLE';
>
> TABLESPACE_NAME
> ------------------------------
> USERS
>
> SQL> select count(*) from mytable;
>
> COUNT(*)
> ----------
> 13
>
> SQL> drop table mytable;
>
> Table dropped.
>
> SQL> show recyclebin
> SQL> select * from recyclebin;
>
> no rows selected

What happens if you do "show parameter compatible"?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com