 I can't purge my recyclebin! [message #136289] |
Wed, 07 September 2005 07:29  |
Achchan
Messages: 86
Registered: June 2005
|
Member |
|
|
Hi all,
This is strange for me: I drop tables from one schema and there is no need to purge those BIN$... tables even but in another schema I have many BIN$... tables and I pruge recyclebin and get completion message but they don't disapear! What should I do in your opinion ?
-Thank in advance.
|
|
|
|
|
|
|
|
| Re: I can't purge my recyclebin! [message #136300 is a reply to message #136297] |
Wed, 07 September 2005 08:04  |
Achchan
Messages: 86
Registered: June 2005
|
Member |
|
|
I connect to scott/tiger using sqlplus then did :
Drop table test;
purge recyclebin;
and it does perfectly.
I connected to other schema say filer/filer and see many previously old BIN$... tables so I submit a
and it say me: Recyclebin purged.
but when I select table_name from user_tables I see those BIN$...
tables again.
Your help will appreciated.
|
|
|
|
| Re: I can't purge my recyclebin! [message #136307 is a reply to message #136289] |
Wed, 07 September 2005 08:22 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Please provide more detail, such as your exact version. Also, when we say show what you did we mean create and capture your test case in a session and show us the results and the objects in your system, not just the commands.
Also there were changes in behavior from 10.1.0.2 to 10.1.0.4 on windows with regards to recyclebin and dropped objects.
MYDBA@ORCL > purge dba_recyclebin;
DBA Recyclebin purged.
MYDBA@ORCL > create table test(a number);
Table created.
MYDBA@ORCL > drop table test;
Table dropped.
MYDBA@ORCL > select object_name, original_name from user_recyclebin;
OBJECT_NAME ORIGINAL_NAME
------------------------------ --------------------------------
BIN$vGOKmWcEQfCopvA9jDjmiw==$0 TEST
1 row selected.
MYDBA@ORCL > purge recyclebin;
Recyclebin purged.
MYDBA@ORCL > select object_name, original_name from user_recyclebin;
no rows selected
|
|
|
|
| Re: I can't purge my recyclebin! [message #137922 is a reply to message #136300] |
Sun, 18 September 2005 21:24 |
mjschwenger
Messages: 137
Registered: July 2005
Location: US
|
Senior Member |
|
|
You know from previous post that I have the same problem - and I still have it. The only way to clean it up is to move the table and rebuild the unusable indexes after. Still nothing meaningful from Oracle support.
I have already posted my selects and the situation is the same... 10.1.0.4 version, but it looks that 10.1.0.3 has the same problem. It looks that the problem is in dba_recyclebin. If I use "purge user_recbin" then there's nothing going, runs fast, but the tables are still there. "Purge dba_recyclebin" run for hours and even after that the BIN$$ tables are still there like in the example I posted. I have a job which runs every night and purges the dba_recyclebin. Still at noon I have about 20-30,000 bin$$ tables for all users...
Regards,mj
|
|
|
|
| Re: I can't purge my recyclebin! [message #137950 is a reply to message #137922] |
Mon, 19 September 2005 01:04 |
Achchan
Messages: 86
Registered: June 2005
|
Member |
|
|
Hi,
I found that those BIN$ tables are not in my recycle bin.
I did a select * from user_recyclebin and even dba_recyclebin and it returned no data.
So what are those tables in your opinion? They seemed to be locked because I can't drop them too.
The only way I found to get rid of them is to exp/imp schema without those ones.
Your help will be so appreciated.
|
|
|
|
| Re: I can't purge my recyclebin! [message #138023 is a reply to message #137950] |
Mon, 19 September 2005 07:46 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Do one thing ... first of all purge from your user schema.
and if you have DBA right then remove form your Dba_recyclebin
and then see are u still getting that table ... & if you are still getting that table then you better restart your Database after doing this i hope you will not see your droped table.
try this out ... coz long time back i was facing such problem ...but when i restart my database ... or machine on whihc my database resides then every thing was cleared.
Regards
sunilkumar
|
|
|
|
|
|
| Re: I can't purge my recyclebin! [message #138275 is a reply to message #138031] |
Wed, 21 September 2005 02:18 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Remember, placing tables in the recycle bin does not free up space in the original tablespace. To free the space, you need to purge the bin using:
PURGE RECYCLEBIN;
But what if you want to drop the table completely, without needing a flashback feature? In that case, you can drop it permanently using:
DROP TABLE <table name> PURGE;
This command will not rename the table to the recycle bin name; rather, it will be deleted permanently, as it would have been pre-10g.
I hope above mention thing is of your use 
Regards
Always friend sunilkumar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
