Oracle 10g incorporated the idea of a recycle bin for dropped objects.
You have to manually purge the dropped objects to remove them
permanently.
http://www.orafaq.com/node/968
http://www.rampant-books.com/art_liu_10g_flashback_feat.htm
Axton Grams
On Thu, Jun 5, 2008 at 11:45 AM, Ravi [EMAIL
When I run the following query to look for space being takedn up by
remedy tables, I get a segment_name called:
BIN$P9nIvT+TSejgRAADut5Q1w==$0. Anyone know what this is?
select segment_name, segment_type, bytes from user_segments where
SEGMENT_TYPE='TABLE' order by bytes asc;
SEGMENT_NAME
2 matches
Mail list logo