Database Administration (MOSC)

MOSC Banner

Alter table shrink or alter table move failing with the error ORA-10662 Segment has long columns

Alter table shrink or alter table move failing with the error ORA-10662 Segment has long columns and ora-00997 : illegal use of LONG datatype.

10662.00000 - "Segment has long columns"

Cause: Shrink was issued on a segment with long columns. This is not supported.

My question is : how to get rid of this error and perform the table re-org with "Alter table move" or "Alter table shrink" command?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center