Table Segment Size Grows by Sqlldr After Adding Column (Doc ID 2665225.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

After add column to table and execute SQL*Loader in direct path mode, 126 bytes data are stored per row.

Example:
When t1 table has one column c1 and add t2 column as follows, total column length is 2 bytes.
However, executing SQL*Loader reserves 126 bytes for invisible columns.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.