My Oracle Support Banner

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

Last updated on APRIL 30, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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