{"id":944,"date":"2014-05-23T21:32:07","date_gmt":"2014-05-23T19:32:07","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=944"},"modified":"2014-05-22T08:43:32","modified_gmt":"2014-05-22T06:43:32","slug":"sintaxis-del-exdp-desde-comando-vs-parfile","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/sintaxis-del-exdp-desde-comando-vs-parfile\/","title":{"rendered":"Sintaxis  del EXDP desde comando vs parfile"},"content":{"rendered":"<p>Volvemos a una entrada de ayuda para dummies.<br \/>\nMuchas veces perdemos un mont\u00f3n de tiempo haciendo <em>prueba y error <\/em>con las comillas en los scripts de <strong>expdp<\/strong> e <strong>impdp <\/strong><br \/>\nEn esta entrada cortita, vamos a poner el mismo script de import en parfile y linea de comandos<\/p>\n<p><font size=+1><strong>Parfile<\/strong><\/font><\/p>\n<pre>\r\n$ORACLE_HOME\/bin\/expdp system\/blabla parfile  fichero_opciones.par \r\n<\/pre>\n<p>Donde el parfile es :<\/p>\n<pre>\r\nDIRECTORY=DATA_PUMP_DIR\r\nDUMPFILE=fichero_expdp.dmp\r\nLOGFILE=expdp.log\r\nFULL=Y\r\nEXCLUDE=TABLE:\"IN ('NOMINAS', 'CHISTES' , 'GAZAPOS')\"\r\nEXCLUDE=SCHEMA:\"IN ('BLOG','PORRA')\"\r\n<\/pre>\n<p><font size=+1><strong>L\u00ednea de comandos <\/strong><\/font><br \/>\nEn l\u00ednea de comandos, simplemente escaparemos las comillas simples y dobles (especialmente si vamos a incluirlo en alg\u00fan script)<\/p>\n<pre>\r\n$ORACLE_HOME\/bin\/expdp system\/blabla DIRECTORY=DATA_PUMP_DIR DUMPFILE=fichero_expdp.dmp LOGFILE=expdp.log FULL=Y EXCLUDE=TABLE:\\\"IN (\\'NOMINAS\\', \\'CHISTES\\' , \\'GAZAPOS\\')\\\"  EXCLUDE=SCHEMA:\\\"IN (\\'BLOG\\',\\'PORRA\\')\\\"\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Volvemos a una entrada de ayuda para dummies. Muchas veces perdemos un mont\u00f3n de tiempo haciendo prueba y error con las comillas en los scripts de expdp e impdp En esta entrada cortita, vamos a poner el mismo script de &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/sintaxis-del-exdp-desde-comando-vs-parfile\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,13],"tags":[246,248,97,106],"class_list":["post-944","post","type-post","status-publish","format-standard","hentry","category-backup","category-scripting","tag-backup","tag-dummie","tag-expdp","tag-impdp"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/944","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=944"}],"version-history":[{"count":2,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/944\/revisions"}],"predecessor-version":[{"id":946,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/944\/revisions\/946"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=944"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}