{"id":4212,"date":"2014-12-08T19:38:33","date_gmt":"2014-12-08T18:38:33","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/"},"modified":"2014-12-08T19:38:33","modified_gmt":"2014-12-08T18:38:33","slug":"sqlplus-copy-command-is-back-as-bridge","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/","title":{"rendered":"SQL*Plus COPY Command is back as BRIDGE"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nDid you ever use the COPY command in sqlplus? It’s very old, and documentation says :
\nThe COPY command is not being enhanced to handle datatypes or features introduced with, or after Oracle8i. The COPY command is likely to be deprecated in a future release.<\/p>\n

Deprecated? But it is back, with a new name, in the new SQL Developer based SQL*Plus (currently called sdsql in beta)<\/p>\n

SQL*Plus COPY<\/h3>\n

Documentation is here<\/a>. Let’s show how to copy<\/p>\n

$ sqlplus \/nolog\n\nSQL*Plus: Release 12.1.0.1.0 Production on Mon Dec 8 22:49:40 2014\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\nSQL> copy from system\/manager@\/\/192.168.78.216\/DB1 to demo\/demo@\/\/192.168.78.216\/DB1 CREATE DEMO_COPY using select * from dual;\nconnect demo\/demo@\/\/192.168.78.216\/DB1\n\nArray fetch\/bind size is 15. (arraysize is 15)\nWill commit when done. (copycommit is 0)\nMaximum long size is 80. (long is 80)\nTable DEMO_COPY created.\n\n   1 rows selected from system@\/\/192.168.78.216\/DB1.\n   1 rows inserted into DEMO_COPY.\n   1 rows committed into DEMO_COPY at demo@\/\/192.168.78.216\/DB1.\n\n<\/pre>\n
I’ve created a table DEMO_COPY in the DEMO schema from a select. And then I can check the table that has been created:<\/p>\n
SQL> connect demo\/demo@\/\/192.168.78.216\/DB1\nConnected.\n\nSQL> desc DEMO_COPY;\n Name                                      Null?    Type\n ----------------------------------------- -------- ----------------------------\n DUMMY                                              VARCHAR2(1)\n\nSQL> select * from DEMO_COPY;\n\nD\n-\nX\n\n<\/pre>\n
This is not very useful nowadays as we have Create Table as Select, Data Pump, etc. But by the way it can still be used to copy data from one database to another without having to create a database link nor move files on the database servers.<\/p>\n
And the new BRIDGE command<\/h3>\n
Here is the new feature. The new SQL Developer 4.1 Early Adopter is there before Christmas:<\/p>\n
Ho, ho, ho. Merry Christmas from the #SQLDev<\/a> team http:\/\/t.co\/4893ZUEpBv<\/a> #41<\/p>\n
\u2014 Jeff Smith (@thatjeffsmith) December 8, 2014<\/a><\/p><\/blockquote>\n
and it includes the new SQL*Plus which is a sqlplus like command line based on sqldev and is currently called ‘sdsql’:<\/p>\n
F:sd41sdsqlbin>sdsql.bat demo\/demo@\/\/192.168.78.216\/DB1\n\nsdsql: Release 4.1.0 Beta on lun. d\u00e9c. 08 23:29:58 2014\n\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\n<\/pre>\n
So I tested the BRIDGE command that looks like the old COPY one, but now with jdbc (and thus is database independant…)<\/p>\n
SQL> BRIDGE DEMO_BRIDGE as \"jdbc:oracle:thin:\/\/192.168.78.216\/DB1;user=system;password=manager\"(select * from dual);\nnull\nnull\nTable DEMO_BRIDGE : insert succeeded\n<\/pre>\n
We can check the table<\/p>\n
SQL> select * from DEMO_BRIDGE;\nDUMMY\n-----\nX\n<\/pre>\n
desc is still there but we also have INFO:<\/p>\n
SQL> info DEMO_BRIDGE\nColumns\nNAME    DATA TYPE     NULL  DEFAULT    COMMENTS\n DUMMY  VARCHAR2(1)   Yes\n\nIndexes\n\n<\/pre>\n
And we have a new command to get the DDL:<\/p>\n
SQL> ddl DEMO_BRIDGE\n\n  CREATE TABLE \"DEMO\".\"DEMO_BRIDGE\"\n   (    \"DUMMY\" VARCHAR2(1)\n   ) SEGMENT CREATION IMMEDIATE\n  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255\n NOCOMPRESS LOGGING\n  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645\n  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1\n  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)\n  TABLESPACE \"USERS\"\n<\/pre>\n
That were my first steps on the new sqlplus based on sqldeveloper. It’s still in beta, but this a nice Christmas gift to play with.<\/p>\n
Update<\/h3>\n
So it seems this is not a new feature.
\nThe fact that it is in the HELP is the new features that made me aware of it…<\/p>\n
\n@FranckPachot<\/a> @thatjeffsmith<\/a> that’s been in sqldev for a long time. Works across DB types too say MySQL to oracle.<\/p>\n
\u2014 krisrice (@krisrice) December 8, 2014<\/a>\n<\/p><\/blockquote>\n
Let’s see in previous version:<\/p>\n
\"CaptureBridge.PNG\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . Did you ever use the COPY command in sqlplus? It’s very old, and documentation says : The COPY command is not being enhanced to handle datatypes or features introduced with, or after Oracle8i. The COPY command is likely to be deprecated in a future release. Deprecated? But it is back, with […]<\/p>\n","protected":false},"author":27,"featured_media":4213,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198,59],"tags":[96],"type_dbi":[],"class_list":["post-4212","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","category-oracle","tag-oracle"],"acf":[],"yoast_head":"\nSQL*Plus COPY Command is back as BRIDGE - dbi Blog<\/title>\n<meta name=\"description\" content=\"The new sqlplus based on sqldeveloper replaces the old COPY command by the new BRIDGE one - based on jdbc.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL*Plus COPY Command is back as BRIDGE\" \/>\n<meta property=\"og:description\" content=\"The new sqlplus based on sqldeveloper replaces the old COPY command by the new BRIDGE one - based on jdbc.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-12-08T18:38:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureBridge.png\" \/>\n\t<meta property=\"og:image:width\" content=\"862\" \/>\n\t<meta property=\"og:image:height\" content=\"543\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"SQL*Plus COPY Command is back as BRIDGE\",\"datePublished\":\"2014-12-08T18:38:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/\"},\"wordCount\":351,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureBridge.png\",\"keywords\":[\"Oracle\"],\"articleSection\":[\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/\",\"name\":\"SQL*Plus COPY Command is back as BRIDGE - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureBridge.png\",\"datePublished\":\"2014-12-08T18:38:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"The new sqlplus based on sqldeveloper replaces the old COPY command by the new BRIDGE one - based on jdbc.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureBridge.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureBridge.png\",\"width\":862,\"height\":543},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL*Plus COPY Command is back as BRIDGE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL*Plus COPY Command is back as BRIDGE - dbi Blog","description":"The new sqlplus based on sqldeveloper replaces the old COPY command by the new BRIDGE one - based on jdbc.","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:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/","og_locale":"en_US","og_type":"article","og_title":"SQL*Plus COPY Command is back as BRIDGE","og_description":"The new sqlplus based on sqldeveloper replaces the old COPY command by the new BRIDGE one - based on jdbc.","og_url":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/","og_site_name":"dbi Blog","article_published_time":"2014-12-08T18:38:33+00:00","og_image":[{"width":862,"height":543,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureBridge.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"SQL*Plus COPY Command is back as BRIDGE","datePublished":"2014-12-08T18:38:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/"},"wordCount":351,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureBridge.png","keywords":["Oracle"],"articleSection":["Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/","url":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/","name":"SQL*Plus COPY Command is back as BRIDGE - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureBridge.png","datePublished":"2014-12-08T18:38:33+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"The new sqlplus based on sqldeveloper replaces the old COPY command by the new BRIDGE one - based on jdbc.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureBridge.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureBridge.png","width":862,"height":543},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sqlplus-copy-command-is-back-as-bridge\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL*Plus COPY Command is back as BRIDGE"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4212"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4212\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4213"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4212"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}