{"id":2101,"date":"2019-08-24T21:44:02","date_gmt":"2019-08-24T19:44:02","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=2101"},"modified":"2020-01-24T17:58:40","modified_gmt":"2020-01-24T16:58:40","slug":"renombrando-un-pdb","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/renombrando-un-pdb\/","title":{"rendered":"renombrando un PDB"},"content":{"rendered":"<p>Hoy vamos a ver una entrada sencilla para un problema bastante comun.<br \/>\nSupongamos que queremos renombrar un PDB<br \/>\nTenemus :<\/p>\n<ul>\n<li>Nombre origina: OLDNAME\n<li> Nombre nuevo : NEWNAME\n<\/ul>\n<p>Los pasos a segir son muy sencillos<\/p>\n<pre>\r\nalter session set container=OLDNAME;\r\n\r\n-- reiniciamos en modo restrict\r\nshutdown immediate;\r\nstartup open restrict;\r\n--cambiamos nombre\r\nalter pluggable database OLDNAME rename global_name to NEWNAME;\r\n\r\n--comprobamos\r\nshow con_name;\r\nshow pdbs;\r\n\r\n--reiniciamos normal\r\nshutdown immediate;\r\nstartup;\r\n\r\n--vemos el resultado\r\nselect name,open_mode from v$pdbs;\r\n<\/pre>\n<p>Com podeis ver, altamente sencillo<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a ver una entrada sencilla para un problema bastante comun. Supongamos que queremos renombrar un PDB Tenemus : Nombre origina: OLDNAME Nombre nuevo : NEWNAME Los pasos a segir son muy sencillos alter session set container=OLDNAME; &#8212; reiniciamos &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/renombrando-un-pdb\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[567,921,975,744],"tags":[982,903,901],"class_list":["post-2101","post","type-post","status-publish","format-standard","hentry","category-12c-en","category-18c","category-19c","category-cdbpdb","tag-multiteenant","tag-rename","tag-renombrar"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=2101"}],"version-history":[{"count":4,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2101\/revisions"}],"predecessor-version":[{"id":2105,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2101\/revisions\/2105"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=2101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=2101"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=2101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}