Brian Peasland wrote:
> 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
good point.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Nov 05 2007 - 20:56:21 CST