| segment names like "BIN$/" [message #135786] |
Fri, 02 September 2005 09:48  |
mjschwenger
Messages: 137
Registered: July 2005
Location: US
|
Senior Member |
|
|
When I run:
SELECT * FROM dba_segments WHERE OWNER NOT IN('SYS','OUTLN','SYSTEM');
I get a strange segment_name like "BIN$/6jSUWRwMLjgMwlIFgMwuA==$0", 'BIN$/7vFHE2IkXzgMwlIFgORfA==$0', etc.
What are they and is there a way to clear them up?
Thanks for the help,mj
|
|
|
|
|
|
| Re: segment names like "BIN$/" [message #135789 is a reply to message #135786] |
Fri, 02 September 2005 09:57  |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
| Quote: |
What are they and is there a way to clear them up?
|
In 10g, when you delete a table, you don't really delete the table, you simply rename it. tables with the BIN prefix are ones tht have been renamed (i.e. deleted) to get rid of them, As Mahesh so succinctly put it, Purge your recycle bin:
PURGE RECYCLEBIN
HTH
Jim
|
|
|
|
|
|
| Re: segment names like "BIN$/" [message #135809 is a reply to message #135804] |
Fri, 02 September 2005 11:57 |
mjschwenger
Messages: 137
Registered: July 2005
Location: US
|
Senior Member |
|
|
There's no records into user_ or dba_ recyclebin at all.
I set up a job to purge them every 2 hours.
I also did :"purge tablespace users;"
But these segments are still there. Why they are not gone?
What else can I do?
Thanks a lot,mj
|
|
|
|
|
|
| Re: segment names like "BIN$/" [message #135821 is a reply to message #135814] |
Fri, 02 September 2005 13:02 |
mjschwenger
Messages: 137
Registered: July 2005
Location: US
|
Senior Member |
|
|
Oh, sure, here we go
SQL> select * from dba_recyclebin;
no rows selected
Elapsed: 00:00:00.12
SQL>
SQL> select * from user_recyclebin;
no rows selected
Elapsed: 00:00:00.03
SQL> select * from "SYS"."RECYCLEBIN$";
no rows selected
Elapsed: 00:00:00.12
SQL> SELECT count(*) FROM dba_segments WHERE segment_name like 'BIN$/%'
2 /
COUNT(*)
----------
29554
Elapsed: 00:00:08.13
Thanks,mj
|
|
|
|
| Re: segment names like "BIN$/" [message #135826 is a reply to message #135786] |
Fri, 02 September 2005 14:00 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Looks odd to me. What is your version? Recyclebin is new, so there may be some "undocumented features". I did notice changes in behavior from 10.1.0.2 to 10.1.0.4 on windows.
you did a "purge dba_recyclebin" right?
Who is the owner of those "bin%" objects in dba_segments?
MYDBA@ORCL > select segment_name from dba_segments where segment_name like 'BIN%';
SEGMENT_NAME
------------------------------
BIN$JSiWLJkRRcKvOTEmWby/cg==$0
1 row selected.
MYDBA@ORCL > purge dba_recyclebin;
DBA Recyclebin purged.
MYDBA@ORCL > select segment_name from dba_segments where segment_name like 'BIN%';
no rows selected
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
