Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
ORA-01792: maximum number of columns in a table or view is 1000
설명
When performing a live reorganization of an Oracle table with 1000 columns, the following error occurs:
ORA-01792: maximum number of columns in a table or view is 1000
해결 방안
Space Manager can perform a live reorg on a table with 1000 columns if the table satisfies either of the following: 1. has a primary key constraint 2. has a unique index with at least one not null column 3. has a unique constraint with at least one not null column
If the table does not satisfy any of the above, then you can only perform a standard reorganization.
