Re: recyclebin
- From: Mathias Magnusson <mathias.magnusson@xxxxxxxxx>
- To: joe_dba@xxxxxxxxxxx
- Date: Wed, 3 Jun 2009 07:46:18 +0200
> I can see the segments this user created in user_segments and his table
name in user_tables.
Are you saying that the drop fails? If it succeeds and noting ends up in the
recyclebin, then you would not se it anymore. If this is the case, then
posting the error message will help.
Also, have you tried it yourself, logging on as that user in sql*plus and
dropping a table? Just to make sure it is a very known environment and
you're not getting any odd filtering done by the tool used.
Mathias
On Wed, Jun 3, 2009 at 4:09 AM, Joe Smith <joe_dba@xxxxxxxxxxx> wrote:
> Nope. Not using the purge option.
>
> thanks.
>
> ------------------------------
> From: kennaim@xxxxxxxxx
> To: joe_dba@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Subject: RE: recyclebin
> Date: Tue, 2 Jun 2009 21:57:10 -0400
>
>
> This may be obvious, but depending on how he is dropping it (ie custom
> code, or some gui) the purge option may be specified in the drop command
> “drop table t1 purge”.
>
>
>
> Ken
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Joe Smith
> *Sent:* Tuesday, June 02, 2009 9:43 PM
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* recyclebin
>
>
>
> I have a user that when he drops a table it does not go into the
> recyclebin. I can see the segments this user created in user_segments and
> his table name in user_tables.
>
> All other users can do this. I created a user, granted create session,
> create table, and a ts quota on USERS and he can drop the table and it goes
> into the recyclebin.
>
> The parameters for the recyclebin are turned on and the hidden parameter is
> turned on ( i.e. _recyclebin= ).
>
> The tablespaces are LMTs and this is Oracle EE 10.2.0.4.0.
>
> Why would this user not be able to drop a table and have it go into the
> recyclebin?
>
> thanks.
> ------------------------------
>
> Windows Live™: Keep your life in sync. Check it
> out.<http://windowslive.com/explore?ocid=TXT_TAGLM_WL_BR_life_in_synch_062009>
>
> ------------------------------
> Windows Live™ SkyDrive™: Get 25 GB of free online storage. Get it on your
> BlackBerry or
> iPhone.<http://windowslive.com/online/skydrive?ocid=TXT_TAGLM_WL_SD_25GB_062009>
>
Other related posts:
