Hi All,
I have partitioned an existing table using DBMS_REDEFINITION.
EBS Database: 11.2.0.4
EBS: R12.2.5
OS: RHEL 7
I have observed that there is a difference size on a table before & after table partitioning. Can any one help me why we have this difference?
Before Table Partition:
SQL> select owner, segment_name OBJECT_NAME, partition_name,segment_type OBJECT_TYPE,round(bytes/1024) KB from dba_segments
where segment_name like 'OE_ORDER_HEADERS_ALL';
After Table Partition:
SQL> select owner, segment_name OBJECT_NAME, partition_name,segment_type OBJECT_TYPE,round(bytes/1024) KB from dba_segments
where segment_name like 'OE_ORDER_HEADERS_ALL';
