Erro
ORA-01792: Maximum number of columns in a table or view is 1000 Bug.27423662
Solução
|
1 2 3 4 |
09:47:09 SYS@ORCL > shut immediate Database closed. Database dismounted. ORACLE instance shut down. |
Iniciar instância em nomount
|
1 2 3 4 5 6 7 8 |
SYS@ORCL > startup nomount; ORACLE instance started. Total System Global Area 2421825536 bytes Fixed Size 2255632 bytes Variable Size 620758256 bytes Database Buffers 1778384896 bytes Redo Buffers 20426752 bytes |
Alterar o parâmetro _fix_control
|
1 2 |
SYS@ORCL > alter system set "_fix_control"='17376322:OFF' scope=spfile; System altered. |
|
1 2 |
SYS@ORCL > alter database mount; Database altered. |
|
1 2 |
SYS@ORCL > alter database open; Database altered. |
Ou aplicar o Patch (19509982)