ORA-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;