{"id":9867,"date":"2019-09-29T17:38:14","date_gmt":"2019-09-29T15:38:14","guid":{"rendered":"http:\/\/arumel.com\/?p=9867"},"modified":"2019-09-29T17:49:22","modified_gmt":"2019-09-29T15:49:22","slug":"conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl","status":"publish","type":"post","link":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/","title":{"rendered":"Conectando a \u00abfree oracle cloud\u00bb con instant client y sqlcl"},"content":{"rendered":"\n

Tal vez te hayas animado a crearte una cuenta \u00abalways free\u00bb en la nube de Oracle tras su anuncio de \u00abFree Autonomous Oracle Cloud\u00bb tras el Oracle Open World 2019.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Para crearte la cuenta y la base de datos, mi recomendaci\u00f3n es que sigas los pasos 1 y 2 de Dimitri Gielis en su entrada de blog:<\/p>\n\n\n\n

https:\/\/dgielis.blogspot.com\/2019\/09\/best-and-cheapest-oracle-apex-hosting.html<\/a><\/p>\n\n\n\n

En el paso 3 te explica como conectar desde sqldeveloper.<\/p>\n\n\n\n

Nosotros te vamos a ense\u00f1ar a conectar con instant client y sqlcl desde tu ordenador.<\/p>\n\n\n\n

Tras la creaci\u00f3n de la instancia, tienes que bajarte el wallet para poder conectarte desde tu equipo.<\/p>\n\n\n\n

Eliges el apartado de DB Connection:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Y luego \u00abDownload\u00bb:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Para la conexi\u00f3n con instant client, descomprimimes el fichero en la ruta $TNS_ADMIN de tu instalaci\u00f3n.<\/p>\n\n\n\n

En mi caso es en: \/home\/sergio\/instantclient_19_3\/network\/admin<\/p>\n\n\n\n

Se te crear\u00e1n estos ficheros:<\/p>\n\n\n

sergio@sergio-pc:~\/.instantclient_19_3\/network\/admin$ ls -l
\ntotal 40
\n-rw——- 1 sergio sergio 6661 sep 26 10:48 cwallet.sso
\n-rw——- 1 sergio sergio 6616 sep 26 10:48 ewallet.p12
\n-rw——- 1 sergio sergio 3241 sep 26 10:48 keystore.jks
\n-rw——- 1 sergio sergio 87 sep 26 10:48 ojdbc.properties
\n-rw——- 1 sergio sergio 502 abr 17 08:38 README
\n-rw——- 1 sergio sergio 114 sep 26 10:48 sqlnet.ora
\n-rw——- 1 sergio sergio 1811 sep 26 10:48 tnsnames.ora
\n-rw——- 1 sergio sergio 3335 sep 26 10:48 truststore.jks<\/p>\n\n\n\n

En mi fichero .bashrc tengo a\u00f1adidas las siguientes entradas:<\/p>\n\n\n

export LD_LIBRARY_PATH=\/home\/sergio\/instantclient_19_3\/:$LD_LIBRARY_PATH
\nexport PATH=\/home\/sergio\/instantclient_19_3\/:$PATH
\nexport TNS_ADMIN=\/home\/sergio\/instantclient_19_3\/network\/admin\/<\/p>\n\n\n\n

Y ahora solo tienes que conectarte:<\/p>\n\n\n

sergio@sergio-pc:~$ sqlplus admin\/\u00bbxxxxx\u00bb@dboraclesm_high<\/p>\n

SQL*Plus: Release 19.0.0.0.0 – Production on Thu Sep 26 11:08:16 2019
\nVersion 19.3.0.0.0<\/p>\n

Copyright (c) 1982, 2019, Oracle. All rights reserved.<\/p>\n

Last Successful login time: Thu Sep 26 2019 10:58:56 +02:00<\/p>\n

Connected to:
\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production
\nVersion 18.4.0.0.0<\/p>\n

SQL><\/p>\n\n\n\n

Para conectar desde sqlcl, una vez tienes configurada tu variable TNS_ADMIN, en modo oci<\/em> lo haces as\u00ed:<\/p>\n\n\n

sergio@sergio-pc:~$ sql -oci admin\/\u00bbxxxxx\u00bb@dboraclesm_high<\/p>\n

SQLcl: Versi\u00f3n 19.2.1 Production en jue sep 26 11:13:37 2019<\/p>\n

Copyright (c) 1982, 2019, Oracle. Todos los derechos reservados.<\/p>\n

Last Successful login time: Jue Sep 26 2019 11:13:39 +02:00<\/p>\n

Conectado a:
\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production
\nVersion 18.4.0.0.0<\/p>\n

SQL><\/p>\n\n\n\n

Para conectarte desde el sqlcl en modo jdbc<\/em>, tienes que configurar el fichero wallet (.zip) descargado de la web, como para el sqldeveloper:<\/p>\n\n\n

sergio@sergio-pc:~$ sql \/nolog<\/p>\n

SQLcl: Versi\u00f3n 19.2.1 Production en jue sep 26 11:15:16 2019<\/p>\n

Copyright (c) 1982, 2019, Oracle. Todos los derechos reservados.<\/p>\n

SQL> set cloudconfig \/datos\/ARUMEL\/oracle_cloud_free_tier\/Wallet_dboraclesm.zip
\nLa operaci\u00f3n se ha realizado correctamente.
\nLa operaci\u00f3n se ha realizado correctamente.
\nUsing temp directory:\/tmp\/oracle_cloud_config4697460182522377315
\nSQL> connect admin\/\u00bbxxxxx\u00bb@dboraclesm_high
\nConectado.
\nSQL><\/p>\n\n\n\n

A\u00f1adiendo valor con Arumel<\/a>!!<\/p>\n","protected":false},"excerpt":{"rendered":"

Tal vez te hayas animado a crearte una cuenta \u00abalways free\u00bb en la nube de Oracle tras su anuncio de \u00abFree Autonomous Oracle Cloud\u00bb 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 Dimitri Gielis en su entrada […]<\/p>\n","protected":false},"author":11,"featured_media":7824,"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":[62],"tags":[427,428,429,408],"class_list":["post-9867","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-cloud","tag-free","tag-instant-client","tag-sqlcl"],"yoast_head":"\nConectando a "free oracle cloud" con instant client y sqlcl - 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\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conectando a "free oracle cloud" con instant client y sqlcl - Arumel\" \/>\n<meta property=\"og:description\" content=\"Tal vez te hayas animado a crearte una cuenta \u00abalways free\u00bb en la nube de Oracle tras su anuncio de \u00abFree Autonomous Oracle Cloud\u00bb 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 Dimitri Gielis en su entrada […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/\" \/>\n<meta property=\"og:site_name\" content=\"Arumel\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-29T15:38:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-29T15:49: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=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"sm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/\"},\"author\":{\"name\":\"sm\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/e270e777d900dcd47f8eb3895c076b64\"},\"headline\":\"Conectando a \u00abfree oracle cloud\u00bb con instant client y sqlcl\",\"datePublished\":\"2019-09-29T15:38:14+00:00\",\"dateModified\":\"2019-09-29T15:49:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/\"},\"wordCount\":443,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/arumel_xenia.jpeg?fit=635%2C900&ssl=1\",\"keywords\":[\"cloud\",\"free\",\"instant client\",\"SQLcl\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/arumel.com\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/\",\"url\":\"https:\\\/\\\/arumel.com\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/\",\"name\":\"Conectando a \\\"free oracle cloud\\\" con instant client y sqlcl - Arumel\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/arumel_xenia.jpeg?fit=635%2C900&ssl=1\",\"datePublished\":\"2019-09-29T15:38:14+00:00\",\"dateModified\":\"2019-09-29T15:49:22+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/e270e777d900dcd47f8eb3895c076b64\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/arumel.com\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/#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\\\/es\\\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/arumel.com\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Conectando a \u00abfree oracle cloud\u00bb con instant client y sqlcl\"}]},{\"@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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/e270e777d900dcd47f8eb3895c076b64\",\"name\":\"sm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\\\/es\\\/author\\\/sergio\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Conectando a \"free oracle cloud\" con instant client y sqlcl - 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\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/","og_locale":"es_ES","og_type":"article","og_title":"Conectando a \"free oracle cloud\" con instant client y sqlcl - Arumel","og_description":"Tal vez te hayas animado a crearte una cuenta \u00abalways free\u00bb en la nube de Oracle tras su anuncio de \u00abFree Autonomous Oracle Cloud\u00bb 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 Dimitri Gielis en su entrada […]","og_url":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/","og_site_name":"Arumel","article_published_time":"2019-09-29T15:38:14+00:00","article_modified_time":"2019-09-29T15:49: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":{"Escrito por":"sm","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/#article","isPartOf":{"@id":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/"},"author":{"name":"sm","@id":"http:\/\/arumel.com\/#\/schema\/person\/e270e777d900dcd47f8eb3895c076b64"},"headline":"Conectando a \u00abfree oracle cloud\u00bb con instant client y sqlcl","datePublished":"2019-09-29T15:38:14+00:00","dateModified":"2019-09-29T15:49:22+00:00","mainEntityOfPage":{"@id":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/"},"wordCount":443,"commentCount":0,"image":{"@id":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1","keywords":["cloud","free","instant client","SQLcl"],"articleSection":["Oracle"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/","url":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/","name":"Conectando a \"free oracle cloud\" con instant client y sqlcl - Arumel","isPartOf":{"@id":"http:\/\/arumel.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/#primaryimage"},"image":{"@id":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1","datePublished":"2019-09-29T15:38:14+00:00","dateModified":"2019-09-29T15:49:22+00:00","author":{"@id":"http:\/\/arumel.com\/#\/schema\/person\/e270e777d900dcd47f8eb3895c076b64"},"breadcrumb":{"@id":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/arumel.com\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/#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\/es\/conectando-a-free-oracle-cloud-con-instant-client-y-sqlcl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/arumel.com\/es\/"},{"@type":"ListItem","position":2,"name":"Conectando a \u00abfree oracle cloud\u00bb con instant client y sqlcl"}]},{"@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":"es"},{"@type":"Person","@id":"http:\/\/arumel.com\/#\/schema\/person\/e270e777d900dcd47f8eb3895c076b64","name":"sm","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/sergio\/"}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9uvW6-2z9","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":9867,"position":0},"title":"SQLcl – \u00abCreate Table As Select\u00bb entre bases de datos con \u00abbridge\u00bb y sin dblinks","author":"sm","date":"19 de julio de 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":"En "Oracle"","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":9602,"url":"https:\/\/arumel.com\/en\/sqlcl-create-table-as-select-between-databases-with-bridge-and-without-dblinks\/","url_meta":{"origin":9867,"position":1},"title":"SQLcl \u2013 \u00abCreate Table As Select\u00bb between databases with \u00abbridge\u00bb and without dblinks","author":"sm","date":"19 de julio de 2019","format":false,"excerpt":"I'm pretty fan of SQLcl and lately, I'm using it for creating tables in development from production. I query the table in production: SYS@172.20.0.64\/DBPRO>select owner,object_name,object_type from dba_objects where object_name like '%TLOCATIONID%' and owner='USER'; OWNER OBJECT_NAME OBJECT_TYPE ------------- --------------------------- ------------------- USER TLOCATIONID_EXPORT TABLE USER IDX_TLOCATIONID1 INDEX After that, while I'm connected\u2026","rel":"","context":"En "Oracle"","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\/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":9867,"position":2},"title":"Base de datos con Oracle Container Registry","author":"sm","date":"12 de enero de 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":"En "Sin categorizar"","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":9563,"url":"https:\/\/arumel.com\/es\/es-19c-la-muerte-de-rac-en-standard-edition\/","url_meta":{"origin":9867,"position":3},"title":"\u00bfEs 19c la muerte de RAC en Standard Edition?","author":"Alberto Pereiro","date":"11 de abril de 2019","format":false,"excerpt":"Seg\u00fan la documentaci\u00f3n 19c, SE2 dejar\u00eda de contar con RAC","rel":"","context":"En "Oracle"","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/04\/photo-1527311257265-eb6c944f8c63.jpg?fit=1000%2C667&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/04\/photo-1527311257265-eb6c944f8c63.jpg?fit=1000%2C667&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/04\/photo-1527311257265-eb6c944f8c63.jpg?fit=1000%2C667&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/04\/photo-1527311257265-eb6c944f8c63.jpg?fit=1000%2C667&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":7585,"url":"https:\/\/arumel.com\/es\/mitos-y-realidades-de-la-virtualizacion-oracle-con-y-sin-vmware\/","url_meta":{"origin":9867,"position":4},"title":"Virtualizaci\u00f3n Oracle: Mitos y realidades (con y sin VMWare)","author":"Alberto Pereiro","date":"28 de junio de 2017","format":false,"excerpt":"","rel":"","context":"En "Oracle"","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/06\/Radiohead_Paranoid_Android_Magnus_Carlsson.jpg?fit=640%2C360&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/06\/Radiohead_Paranoid_Android_Magnus_Carlsson.jpg?fit=640%2C360&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/06\/Radiohead_Paranoid_Android_Magnus_Carlsson.jpg?fit=640%2C360&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":7636,"url":"https:\/\/arumel.com\/eu\/mitos-y-realidades-de-la-virtualizacion-oracle-con-y-sin-vmware\/","url_meta":{"origin":9867,"position":5},"title":"Virtualizaci\u00f3n Oracle: Mitos y realidades (con y sin VMWare)","author":"Alberto Pereiro","date":"28 de junio de 2017","format":false,"excerpt":"","rel":"","context":"En "Oracle"","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/eu\/oracle-eu\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/06\/Radiohead_Paranoid_Android_Magnus_Carlsson.jpg?fit=640%2C360&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/06\/Radiohead_Paranoid_Android_Magnus_Carlsson.jpg?fit=640%2C360&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/06\/Radiohead_Paranoid_Android_Magnus_Carlsson.jpg?fit=640%2C360&ssl=1&resize=525%2C300 1.5x"},"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\/es\/wp-json\/wp\/v2\/posts\/9867","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/comments?post=9867"}],"version-history":[{"count":14,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/9867\/revisions"}],"predecessor-version":[{"id":9897,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/9867\/revisions\/9897"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/media\/7824"}],"wp:attachment":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/media?parent=9867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/categories?post=9867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/tags?post=9867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}