{"id":9602,"date":"2019-07-19T18:42:13","date_gmt":"2019-07-19T16:42:13","guid":{"rendered":"http:\/\/arumel.com\/?p=9602"},"modified":"2019-07-19T18:42:22","modified_gmt":"2019-07-19T16:42:22","slug":"sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks","status":"publish","type":"post","link":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/","title":{"rendered":"SQLcl \u2013 \u00abCreate Table As Select\u00bb between databases with \u00abbridge\u00bb and without dblinks"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">I&#8217;m pretty fan of SQLcl and lately, I&#8217;m using it for creating tables in development from production.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I query the table in production:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SYS@172.20.0.64\/DBPRO&gt;select owner,object_name,object_type from dba_objects where object_name like '%TLOCATIONID%' and owner='USER';\n\nOWNER         OBJECT_NAME                 OBJECT_TYPE       \n------------- --------------------------- -------------------\nUSER          TLOCATIONID_EXPORT          TABLE             \nUSER          IDX_TLOCATIONID1            INDEX             \n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">After that, while I&#8217;m connected to development, I use the bridge command for creating the table (like CTAS in sqlplus):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>USER@172.20.0.45\/DBPRE&gt;bridge TLOCATIONID_EXPORT as \"jdbc:oracle:thin:USER\/USER@172.20.0.64:1521\/DBPRO\"(select * from TLOCATIONID_EXPORT);\n\nSe ha creado la tabla TLOCATIONID_EXPORT y se han insertado 246.872 filas<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">At the end, I query the new table:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>USER@172.20.0.45\/DBPRE&gt;select count(*) from TLOCATIONID_EXPORT;\n\n  COUNT(*)\n----------\n    246872<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;m pretty fan of SQLcl and lately, I&#8217;m using it for creating tables in development from production. I query the table in production: After that, while I&#8217;m connected to development, I use the bridge command for creating the table (like CTAS in sqlplus): At the end, I query the new table:<\/p>\n","protected":false},"author":11,"featured_media":7827,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"off","_et_pb_old_content":"","_et_gb_content_width":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[76],"tags":[410,409,411,408],"class_list":["post-9602","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-en","tag-bridge","tag-ctas","tag-dblink","tag-sqlcl"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQLcl \u2013 \u00abCreate Table As Select\u00bb between databases with \u00abbridge\u00bb and without dblinks - Arumel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLcl \u2013 \u00abCreate Table As Select\u00bb between databases with \u00abbridge\u00bb and without dblinks - Arumel\" \/>\n<meta property=\"og:description\" content=\"I&#8217;m pretty fan of SQLcl and lately, I&#8217;m using it for creating tables in development from production. I query the table in production: After that, while I&#8217;m connected to development, I use the bridge command for creating the table (like CTAS in sqlplus): At the end, I query the new table:\" \/>\n<meta property=\"og:url\" content=\"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/\" \/>\n<meta property=\"og:site_name\" content=\"Arumel\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-19T16:42:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-19T16:42:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"635\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"sm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/\"},\"author\":{\"name\":\"sm\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/e270e777d900dcd47f8eb3895c076b64\"},\"headline\":\"SQLcl \u2013 \u00abCreate Table As Select\u00bb between databases with \u00abbridge\u00bb and without dblinks\",\"datePublished\":\"2019-07-19T16:42:13+00:00\",\"dateModified\":\"2019-07-19T16:42:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/\"},\"wordCount\":66,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/arumel_xenia.jpeg?fit=635%2C900&ssl=1\",\"keywords\":[\"bridge\",\"CTAS\",\"dblink\",\"SQLcl\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/\",\"url\":\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/\",\"name\":\"SQLcl \u2013 \u00abCreate Table As Select\u00bb between databases with \u00abbridge\u00bb and without dblinks - Arumel\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/arumel_xenia.jpeg?fit=635%2C900&ssl=1\",\"datePublished\":\"2019-07-19T16:42:13+00:00\",\"dateModified\":\"2019-07-19T16:42:22+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/e270e777d900dcd47f8eb3895c076b64\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/arumel_xenia.jpeg?fit=635%2C900&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/arumel_xenia.jpeg?fit=635%2C900&ssl=1\",\"width\":635,\"height\":900},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"http:\\\/\\\/arumel.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLcl \u2013 \u00abCreate Table As Select\u00bb between databases with \u00abbridge\u00bb and without dblinks\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\",\"url\":\"http:\\\/\\\/arumel.com\\\/\",\"name\":\"Arumel\",\"description\":\"Outro sitio WordPress m\u00e1is\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/arumel.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/e270e777d900dcd47f8eb3895c076b64\",\"name\":\"sm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6207cd8b9baaee6c4cff92251bb20e4b48ce165f93e926218da90832d9f334f9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6207cd8b9baaee6c4cff92251bb20e4b48ce165f93e926218da90832d9f334f9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6207cd8b9baaee6c4cff92251bb20e4b48ce165f93e926218da90832d9f334f9?s=96&d=mm&r=g\",\"caption\":\"sm\"},\"url\":\"https:\\\/\\\/arumel.com\\\/en\\\/author\\\/sergio\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQLcl \u2013 \u00abCreate Table As Select\u00bb between databases with \u00abbridge\u00bb and without dblinks - Arumel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/","og_locale":"en_US","og_type":"article","og_title":"SQLcl \u2013 \u00abCreate Table As Select\u00bb between databases with \u00abbridge\u00bb and without dblinks - Arumel","og_description":"I&#8217;m pretty fan of SQLcl and lately, I&#8217;m using it for creating tables in development from production. I query the table in production: After that, while I&#8217;m connected to development, I use the bridge command for creating the table (like CTAS in sqlplus): At the end, I query the new table:","og_url":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/","og_site_name":"Arumel","article_published_time":"2019-07-19T16:42:13+00:00","article_modified_time":"2019-07-19T16:42:22+00:00","og_image":[{"width":635,"height":900,"url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1","type":"image\/jpeg"}],"author":"sm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sm","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/#article","isPartOf":{"@id":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/"},"author":{"name":"sm","@id":"http:\/\/arumel.com\/#\/schema\/person\/e270e777d900dcd47f8eb3895c076b64"},"headline":"SQLcl \u2013 \u00abCreate Table As Select\u00bb between databases with \u00abbridge\u00bb and without dblinks","datePublished":"2019-07-19T16:42:13+00:00","dateModified":"2019-07-19T16:42:22+00:00","mainEntityOfPage":{"@id":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/"},"wordCount":66,"commentCount":0,"image":{"@id":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1","keywords":["bridge","CTAS","dblink","SQLcl"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/","url":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/","name":"SQLcl \u2013 \u00abCreate Table As Select\u00bb between databases with \u00abbridge\u00bb and without dblinks - Arumel","isPartOf":{"@id":"http:\/\/arumel.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/#primaryimage"},"image":{"@id":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1","datePublished":"2019-07-19T16:42:13+00:00","dateModified":"2019-07-19T16:42:22+00:00","author":{"@id":"http:\/\/arumel.com\/#\/schema\/person\/e270e777d900dcd47f8eb3895c076b64"},"breadcrumb":{"@id":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/#primaryimage","url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1","contentUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1","width":635,"height":900},{"@type":"BreadcrumbList","@id":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"http:\/\/arumel.com\/en\/"},{"@type":"ListItem","position":2,"name":"SQLcl \u2013 \u00abCreate Table As Select\u00bb between databases with \u00abbridge\u00bb and without dblinks"}]},{"@type":"WebSite","@id":"http:\/\/arumel.com\/#website","url":"http:\/\/arumel.com\/","name":"Arumel","description":"Outro sitio WordPress m\u00e1is","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/arumel.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/arumel.com\/#\/schema\/person\/e270e777d900dcd47f8eb3895c076b64","name":"sm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/6207cd8b9baaee6c4cff92251bb20e4b48ce165f93e926218da90832d9f334f9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6207cd8b9baaee6c4cff92251bb20e4b48ce165f93e926218da90832d9f334f9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6207cd8b9baaee6c4cff92251bb20e4b48ce165f93e926218da90832d9f334f9?s=96&d=mm&r=g","caption":"sm"},"url":"https:\/\/arumel.com\/en\/author\/sergio\/"}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9uvW6-2uS","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":9599,"url":"https:\/\/arumel.com\/es\/sqlcl-create-table-as-select-entre-bases-de-datos-con-bridge-y-sin-dblinks\/","url_meta":{"origin":9602,"position":0},"title":"SQLcl &#8211; &#8220;Create Table As Select&#8221; entre bases de datos con &#8220;bridge&#8221; y sin dblinks","author":"sm","date":"19 July, 2019","format":false,"excerpt":"Soy fan del SQLcl y hace ya tiempo lo uso sin problemas para copiar datos entre bases de datos sin dblinks. Suelen ser peticiones de desarrollo para hacer validaciones en entornos de desarrollo, as\u00ed que miro la tabla en producci\u00f3n: SYS@172.20.0.64\/DBPRO>select owner,object_name,object_type from dba_objects where object_name like '%TLOCATIONID%' and owner='USER';\u2026","rel":"","context":"In &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":9867,"url":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/","url_meta":{"origin":9602,"position":1},"title":"Conectando a &#8220;free oracle cloud&#8221; con instant client y sqlcl","author":"sm","date":"29 September, 2019","format":false,"excerpt":"Tal vez te hayas animado a crearte una cuenta \"always free\" en la nube de Oracle tras su anuncio de \"Free Autonomous Oracle Cloud\" tras el Oracle Open World 2019. Para crearte la cuenta y la base de datos, mi recomendaci\u00f3n es que sigas los pasos 1 y 2 de\u2026","rel":"","context":"In &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":8807,"url":"https:\/\/arumel.com\/es\/base-de-datos-oracle-container-registry\/","url_meta":{"origin":9602,"position":2},"title":"Base de datos con Oracle Container Registry","author":"sm","date":"12 January, 2018","format":false,"excerpt":"Montar una base de datos Oracle en Docker con el Oracle Container Registry \u00a0 Nos propusimos crear una nueva base de datos Oracle en Docker viendo el siguiente post: https:\/\/technology.amis.nl\/2017\/12\/30\/oracle-database-in-a-docker-container-from-oracle-container-registry\/ \u00a0 La verdad es que en la documentaci\u00f3n del Oracle Container Registry da muchas pautas de como hacerlo tambi\u00e9n, as\u00ed\u2026","rel":"","context":"In &quot;Sin categorizar&quot;","block_context":{"text":"Sin categorizar","link":"https:\/\/arumel.com\/es\/sin-categorizar\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":9029,"url":"https:\/\/arumel.com\/en\/performance-tuning-with-null-indexing-in-oracle-database\/","url_meta":{"origin":9602,"position":3},"title":"Performance tuning with NULL indexing in Oracle Database","author":"Alberto Pereiro","date":"19 April, 2018","format":false,"excerpt":"","rel":"","context":"In &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/en\/oracle-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7900,"url":"https:\/\/arumel.com\/en\/stored-outlines-en-standard-edition\/","url_meta":{"origin":9602,"position":4},"title":"Stored Outlines en Standard Edition","author":"Alberto Pereiro","date":"12 July, 2017","format":false,"excerpt":"","rel":"","context":"In &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/en\/oracle-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":8988,"url":"https:\/\/arumel.com\/mellora-de-rendemendo-con-indexacion-de-valores-null-en-oracle\/","url_meta":{"origin":9602,"position":5},"title":"Mellora de rendemendo con indexaci\u00f3n de valores NULL en Oracle","author":"Alberto Pereiro","date":"19 April, 2018","format":false,"excerpt":"","rel":"","context":"In &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/oracle-2\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_-e1524149239453.jpg?fit=1200%2C674&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_-e1524149239453.jpg?fit=1200%2C674&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_-e1524149239453.jpg?fit=1200%2C674&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_-e1524149239453.jpg?fit=1200%2C674&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_-e1524149239453.jpg?fit=1200%2C674&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1","_links":{"self":[{"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/posts\/9602","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/comments?post=9602"}],"version-history":[{"count":2,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/posts\/9602\/revisions"}],"predecessor-version":[{"id":9604,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/posts\/9602\/revisions\/9604"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/media\/7827"}],"wp:attachment":[{"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/media?parent=9602"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/categories?post=9602"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/tags?post=9602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}