Monday 23 February 2015

'ORA-01792: maximum number of columns in a table or view is 1000' Error Message

Metalink id :
=========
BI Apps 11.1.1.8.1 ETL fails with the 'ORA-01792: maximum number of columns in a table or view is 1000' Error Message (Doc ID 1956038.1)

Solution
++++++++
add this parameter *._fix_control='17376322:OFF'


Shutdown Application services and database .
--------------------------------------------------

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

grep -i fix /u01/oracle/bidev/db/12.1.0/dbs/initbidev.ora
*._fix_control='17376322:OFF'

SQL> create spfile from pfile='/u01/oracle/bidev/db/12.1.0/dbs/initbidev.ora';

File created.
SQL> startup
ORACLE instance started.
Total System Global Area 3506438144 bytes
Fixed Size                  2930368 bytes
Variable Size             922749248 bytes
Database Buffers         2566914048 bytes
Redo Buffers               13844480 bytes
Database mounted.
Database opened.
SQL> show parameter fix

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_fix_control                         string      17376322:OFF
common_user_prefix                   string      C##
fixed_date                           string
os_authent_prefix                    string      ops$
SQL>