How to Reclaim Space Used by LogMiner Tables
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
***Checked for relevance on 30-May-2013***
By default all LogMiner tables are created to use the SYSTEM tablespace, but the SYSTEM tablespace may not have enough space for these tables.
To determine the amount of space allocated for the Logminer metadata schema, run the statements below within an Sql*plus session:
set linesize 256
select sum(bytes)/(1024*1024) "Total_size_in_MB"
from dba_extents where segment_name like '%LOGMN%';
select owner, segment_name, segment_type, sum(bytes) "ext_bytes"
from dba_extents where segment_name like '%LOGMN%'
group by owner, segment_name, segment_type order by ext_bytes desc;
You have the option to relocate the LogMiner tables to a new tablespace before mining with the LogMiner Utility.
How to reclaim the space used by LogMiner tables such as LOGMNR_OBJ$ and LOGMNR_COL$?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms