{"id":827,"date":"2019-05-16T16:31:10","date_gmt":"2019-05-16T19:31:10","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=827"},"modified":"2019-05-16T16:31:10","modified_gmt":"2019-05-16T19:31:10","slug":"ora-28014-cannot-drop-administrative-users","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2019\/05\/16\/ora-28014-cannot-drop-administrative-users\/","title":{"rendered":"ORA-28014: cannot drop administrative users"},"content":{"rendered":"<h3>Erro ORA-28014: cannot drop administrative users<\/h3>\n<pre class=\"lang:plsql decode:true\">SYS@ORCL &gt; drop user perfstat cascade;\ndrop user perfstat cascade\n*\nERROR at line 1:\nORA-28014: cannot drop administrative users<\/pre>\n<h3>Alterando o par\u00e2metro _oracle_script<\/h3>\n<pre class=\"lang:plsql decode:true\">SYS@ORCL &gt; alter session set \"_oracle_script\"=TRUE;\n\nSession altered.<\/pre>\n<h3>Dropando<\/h3>\n<pre class=\"lang:plsql decode:true \">SQL&gt; drop user perfstat cascade;\nUser dropped<\/pre>\n<p>Resolvido!<\/p>\n<h3>Recomendo que volte depois o par\u00e2metro para FALSE<\/h3>\n<pre class=\"lang:default decode:true \">SYS@ORCL &gt; alter session set \"_oracle_script\"=FALSE; Session altered.<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Erro ORA-28014: cannot drop administrative users SYS@ORCL &gt; drop user perfstat cascade; drop user perfstat cascade * ERROR at line 1: ORA-28014: cannot drop administrative users Alterando o par\u00e2metro _oracle_script SYS@ORCL &gt; alter session set &#8220;_oracle_script&#8221;=TRUE; Session altered. Dropando SQL&gt; drop user perfstat cascade; User dropped Resolvido! Recomendo que volte depois o par\u00e2metro para FALSE&#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":[126],"class_list":["post-827","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-erro-ora-28014-cannot-drop-administrative-users"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/827","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=827"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/827\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}