{"id":5763,"date":"2015-10-09T12:31:06","date_gmt":"2015-10-09T10:31:06","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/"},"modified":"2015-10-09T12:31:06","modified_gmt":"2015-10-09T10:31:06","slug":"how-to-use-sqldevelopercart-for-loading-data-into-dbaas","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/","title":{"rendered":"How to use sqldeveloper&#8217;cart for loading data into DBaaS"},"content":{"rendered":"<p>Here we will show you how to unload data from a database on premise Oracle Database 12c PDB and how to load it into the table on the DBaaS Oracle Database 12c PDB.<\/p>\n<p>We will use a SQL Developer to unload data from tables of the CDB_MY_PDP_PREMISE PDB of the on-premises PDB MY_PDB, and to load data into table of the existing PDB1 PDB of the DBaaS ORCL CDB.<\/p>\n<h2>How to Export Cart using insert<\/h2>\n<p>We use here a Cart method\u00a0 where you add selected objects to be loaded into the DBaaS database (non-CDB or PDB).<\/p>\n<p>In a first step you must create a connection into your on-premise database.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/connect_on_premise1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4302\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/connect_on_premise1.png\" alt=\"connect_on_premise1\" width=\"731\" height=\"272\" \/><\/a><\/p>\n<p style=\"text-align: left\">Now we take a sqldeveloper&#8217;cart and you navigate on View menu<\/p>\n<p style=\"text-align: left\">Click <strong>View<\/strong> and then\u00a0<strong>Cart<\/strong><\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/cart.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-4303 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/cart.png\" alt=\"cart\" width=\"221\" height=\"135\" \/><\/a><\/p>\n<p style=\"text-align: left\">Click <strong>New Cart<\/strong> icone<\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/cart11.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-4305 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/cart11.png\" alt=\"cart1\" width=\"237\" height=\"146\" \/><\/a><\/p>\n<p style=\"text-align: left\">From your database schema you must expand the users for to find your table that you want to export. We take a HR user and the\u00a0MARTLOS_FACT_LIMLVL table.<\/p>\n<p style=\"text-align: left\">Once selected click on <strong>Add To Cart<\/strong><\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/export.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-4313 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/export.png\" alt=\"export\" width=\"266\" height=\"308\" \/><\/a><\/p>\n<p style=\"text-align: left\">The new box appeared on the sqldeveloper. You must select Data<\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/data-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4316\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/data-2.png\" alt=\"data\" width=\"811\" height=\"122\" \/><\/a><\/p>\n<p style=\"text-align: left\">The selected objects of the cart\u00a0 have generated DDL and DML statements for recreating the table and dependent objects and reloading data into the DBaaS database<\/p>\n<p style=\"text-align: left\">Clik the <strong>Export Cart<\/strong><\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/exportcart.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4317\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/exportcart.png\" alt=\"exportcart\" width=\"397\" height=\"152\" \/><\/a><\/p>\n<p style=\"text-align: left\">You can select the options that will create supplementary DDL statements in the c:\\poub1\\export.sql script file.<\/p>\n<p style=\"text-align: left\">Here we have selected Dependents and Grant for CREATE INDEX and GRANT statements if indexes exist on the table and DROP table statement.<\/p>\n<p style=\"text-align: left\">There is the possibility\u00a0to define how often a COMMIT statement will occur, here\u00a0when 100 rows will be inserted in tables.<\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/ddl.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4318\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/ddl.png\" alt=\"ddl\" width=\"489\" height=\"522\" \/><\/a><\/p>\n<p style=\"text-align: left\">Running Export<\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Runing.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4319\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Runing.png\" alt=\"Runing\" width=\"327\" height=\"135\" \/><\/a><\/p>\n<p style=\"text-align: left\">Once executed we get a text file<\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/file.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4321\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/file.png\" alt=\"file\" width=\"405\" height=\"194\" \/><\/a><\/p>\n<h2>How to Import Cart using insert<\/h2>\n<p>We are going to connect to\u00a0the DBaas PDB and we launch the\u00a0 script to import data<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/import.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4325\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/import.png\" alt=\"import\" width=\"628\" height=\"259\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/insert.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4326\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/insert.png\" alt=\"insert\" width=\"583\" height=\"183\" \/><\/a><\/p>\n<p>End execution<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/end-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4327\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/end-1.png\" alt=\"end\" width=\"314\" height=\"195\" \/><\/a><\/p>\n<p>All DDL and DML statements are successfully executed in the DBaaS PDB1 by using the export.sql SQL file<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here we will show you how to unload data from a database on premise Oracle Database 12c PDB and how to load it into the table on the DBaaS Oracle Database 12c PDB. We will use a SQL Developer to unload data from tables of the CDB_MY_PDP_PREMISE PDB of the on-premises PDB MY_PDB, and to&hellip;&nbsp;<\/p>\n","protected":false},"author":27,"featured_media":5776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[],"class_list":["post-5763","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to use sqldeveloper&#039;cart for loading data into DBaaS - dbi services | Blog<\/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:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use sqldeveloper&#039;cart for loading data into DBaaS\" \/>\n<meta property=\"og:description\" content=\"Here we will show you how to unload data from a database on premise Oracle Database 12c PDB and how to load it into the table on the DBaaS Oracle Database 12c PDB. We will use a SQL Developer to unload data from tables of the CDB_MY_PDP_PREMISE PDB of the on-premises PDB MY_PDB, and to&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-09T10:31:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/connect_on_premise.png\" \/>\n\t<meta property=\"og:image:width\" content=\"202\" \/>\n\t<meta property=\"og:image:height\" content=\"139\" \/>\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:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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=\"2 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\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\"},\"headline\":\"How to use sqldeveloper&#8217;cart for loading data into DBaaS\",\"datePublished\":\"2015-10-09T10:31:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/\"},\"wordCount\":338,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/connect_on_premise.png\",\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/\",\"name\":\"How to use sqldeveloper'cart for loading data into DBaaS - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/connect_on_premise.png\",\"datePublished\":\"2015-10-09T10:31:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/connect_on_premise.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/connect_on_premise.png\",\"width\":202,\"height\":139},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use sqldeveloper&#8217;cart for loading data into DBaaS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"caption\":\"Oracle Team\"},\"description\":\"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to use sqldeveloper'cart for loading data into DBaaS - dbi services | Blog","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\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/","og_locale":"en_US","og_type":"article","og_title":"How to use sqldeveloper'cart for loading data into DBaaS","og_description":"Here we will show you how to unload data from a database on premise Oracle Database 12c PDB and how to load it into the table on the DBaaS Oracle Database 12c PDB. We will use a SQL Developer to unload data from tables of the CDB_MY_PDP_PREMISE PDB of the on-premises PDB MY_PDB, and to&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2015-10-09T10:31:06+00:00","og_image":[{"width":202,"height":139,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/connect_on_premise.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5"},"headline":"How to use sqldeveloper&#8217;cart for loading data into DBaaS","datePublished":"2015-10-09T10:31:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/"},"wordCount":338,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/connect_on_premise.png","articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/","url":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/","name":"How to use sqldeveloper'cart for loading data into DBaaS - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/connect_on_premise.png","datePublished":"2015-10-09T10:31:06+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/connect_on_premise.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/connect_on_premise.png","width":202,"height":139},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-use-sqldevelopercart-for-loading-data-into-dbaas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to use sqldeveloper&#8217;cart for loading data into DBaaS"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","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":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","caption":"Oracle Team"},"description":"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.","url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5763","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=5763"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5763\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5776"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}