{"id":902,"date":"2019-07-30T18:00:47","date_gmt":"2019-07-30T21:00:47","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=902"},"modified":"2019-07-30T18:00:47","modified_gmt":"2019-07-30T21:00:47","slug":"ora-01792-maximum-number-of-columns-in-a-table-or-view-is-1000","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2019\/07\/30\/ora-01792-maximum-number-of-columns-in-a-table-or-view-is-1000\/","title":{"rendered":"ORA-01792: Maximum number of columns in a table or view is 1000"},"content":{"rendered":"<h1>Erro<\/h1>\n<p>ORA-01792: Maximum number of columns in a table or view is 1000 Bug.27423662<\/p>\n<h1>Solu\u00e7\u00e3o<\/h1>\n<pre class=\"lang:plsql decode:true\">09:47:09 SYS@ORCL &gt; shut immediate\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\n<\/pre>\n<p>Iniciar inst\u00e2ncia em nomount<\/p>\n<pre class=\"lang:plsql decode:true \">SYS@ORCL &gt; startup nomount;\nORACLE instance started.\n\nTotal System Global Area 2421825536 bytes\nFixed Size                  2255632 bytes\nVariable Size             620758256 bytes\nDatabase Buffers         1778384896 bytes\nRedo Buffers               20426752 bytes<\/pre>\n<p>Alterar o par\u00e2metro _fix_control<\/p>\n<pre class=\"lang:plsql decode:true\">SYS@ORCL &gt; alter system set \"_fix_control\"='17376322:OFF' scope=spfile;\nSystem altered.<\/pre>\n<pre class=\"lang:plsql decode:true \">SYS@ORCL &gt; alter database mount;\nDatabase altered.<\/pre>\n<pre class=\"lang:plsql decode:true \">SYS@ORCL &gt; alter database open;\nDatabase altered.<\/pre>\n<p>&nbsp;<\/p>\n<p>Ou aplicar o P<span id=\"kmPgTpl:r1:ot71\" class=\"kmContent\"><span id=\"form1:panelPage1\">atch (19509982)<\/span> <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Erro ORA-01792: Maximum number of columns in a table or view is 1000 Bug.27423662 Solu\u00e7\u00e3o 09:47:09 SYS@ORCL &gt; shut immediate Database closed. Database dismounted. ORACLE instance shut down. Iniciar inst\u00e2ncia em nomount SYS@ORCL &gt; startup nomount; ORACLE instance started. Total System Global Area 2421825536 bytes Fixed Size 2255632 bytes Variable Size 620758256 bytes Database Buffers&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[15,22,23,25,218,219],"class_list":["post-902","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-_fix_control","tag-22","tag-23","tag-25","tag-ora-01792","tag-ora-01792-maximum-number-of-columns-in-a-table-or-view-is-1000"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/902","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=902"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/902\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}