Database Error Messages

OCI-60471

max_columns can not be set to STANDARD as there are one or more objects with more than 1000 columns

Cause

Setting the parameter max_columns to STANDARD is not possible because there are existing objects with more than 1000 columns.


Action

Remove all objects with more than 1000 columns prior to setting max_columns to STANDARD. To identify all objects with more than 1000 columns, issue the following query: select distinct owner, table_name from dba_tab_columns where column_id > 1000;