{"id":13791,"date":"2019-12-02T06:48:37","date_gmt":"2019-12-02T06:48:37","guid":{"rendered":"https:\/\/dbtut.com\/?p=13791"},"modified":"2019-12-02T06:56:42","modified_gmt":"2019-12-02T06:56:42","slug":"how-to-migrate-from-basicfiles-to-securefiles","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/","title":{"rendered":"How To Migrate From BasicFiles to SecureFiles"},"content":{"rendered":"<p>SecureFiles LOB storage is one of two storage types used with Oracle databases; the other type is BasicFiles LOB storage.<\/p>\n<p>Some advanced features, including compression and deduplication and encryption, are available with SecureFiles LOB.<\/p>\n<p>SecureFiles LOB can only be created in a tablespace managed by Automated Segment Space Management (ASSM).<\/p>\n<p>SecureFiles is the default storage mechanism for LOBs since version 12c, and Oracle recommends SecureFiles instead of BasicFiles to store and manage LOBs. BasicFiles will be deprecated in a future release.<\/p>\n<h1>Migrate From Basicfile to Securefile<\/h1>\n<p>Various methods can be used to migrate from basicfile to securefile. The following methods can be used.<\/p>\n<p>1) Export the table, create a new table with the same columns with the secure file lob and import the data into the new table<\/p>\n<p>2)Add securefile column to table, update with data in basicfile column. Then drop the basicfile column and change the new column name to the existing column name.<\/p>\n<p>3)With the command\u00a0 <code>ALTER TABLE table_name MOVE \u2026<\/code><\/p>\n<h1>Examples<\/h1>\n<p>Below are some examples of these methods.<\/p>\n<h2>Example For Second Method<\/h2>\n<pre class=\"lang:default decode:true\">SQL&gt; alter table ADURUOZ.LOBTABLE add (FILE1 blob) lob (FILE1) store as securefile (tablespace TABLESPACE_NAME);\nSQL&gt; update ADURUOZ.LOBTABLE set FILE1=FILE;\nSQL&gt; commit;\nSQL&gt; ALTER TABLE ADURUOZ.LOBTABLE DROP COLUMN FILE;\nSQL&gt; ALTER TABLE ADURUOZ.LOBTABLE RENAME COLUMN LOBTABLE.FILE1 TO FILE;<\/pre>\n<h2>Example For Third Method<\/h2>\n<h3>Normal Tables:<\/h3>\n<pre class=\"lang:default decode:true\">SQL&gt; ALTER TABLE ADURUOZ.LOBTABLE MOVE LOB(FILE) STORE AS securefile (TABLESPACE TABLESPACE_NAME);<\/pre>\n<h3>Partitioned Tables:<\/h3>\n<pre class=\"lang:default decode:true\">SQL&gt; ALTER TABLE ADURUOZ.LOBTABLE MOVE PARTITION PARTITON_NAME LOB (FILE) STORE AS SECUREFILE (TABLESPACE TABLESPACE_NAME);<\/pre>\n<h3>Move All Partitioned Tables To Migrate From Basicfile to SecureFile<\/h3>\n<p>With the following query, you can create the command to move all partitions in a table.<\/p>\n<pre class=\"lang:default decode:true\">select \u2018ALTER TABLE SCHEMA_NAME.TABLE_NAME MOVE PARTITION \u2018||partition_name||\u2019 LOB (LOB_COLUMN_NAME) STORE AS SECUREFILE (TABLESPACE \u2018||tablespace_name||\u2019);\u2019 from dba_tab_partitions where table_name=\u2019TABLO_NAME\u2019;<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13791\" class=\"pvc_stats all  \" data-element-id=\"13791\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>SecureFiles LOB storage is one of two storage types used with Oracle databases; the other type is BasicFiles LOB storage. Some advanced features, including compression and deduplication and encryption, are available with SecureFiles LOB. SecureFiles LOB can only be created in a tablespace managed by Automated Segment Space Management (ASSM). SecureFiles is the default storage &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13791\" class=\"pvc_stats all  \" data-element-id=\"13791\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":13792,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[5747,5748,5749,5744,5745,5743,5742,5750,5746],"class_list":["post-13791","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-convert-basicfile-to-securefile","tag-convert-clob-from-basicfile-to-securefile","tag-convert-lob-basicfile-to-securefile","tag-migrate-basicfile-lob-to-securefile-lob","tag-migrate-basicfile-to-securefile","tag-migrate-from-basicfile-to-securefile","tag-move-all-partitioned-tables-to-migrate-from-basicfile-to-securefile","tag-oracle-12c-convert-basicfile-to-securefile","tag-oracle-migrate-basicfile-to-securefile"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Migrate From BasicFiles to SecureFiles - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Migrate From BasicFiles to SecureFiles\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Migrate From BasicFiles to SecureFiles - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Migrate From BasicFiles to SecureFiles\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-02T06:48:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-02T06:56:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-38.png\" \/>\n\t<meta property=\"og:image:width\" content=\"650\" \/>\n\t<meta property=\"og:image:height\" content=\"310\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Migrate From BasicFiles to SecureFiles\",\"datePublished\":\"2019-12-02T06:48:37+00:00\",\"dateModified\":\"2019-12-02T06:56:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/\"},\"wordCount\":213,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-38.png\",\"keywords\":[\"convert basicfile to securefile\",\"convert clob from basicfile to securefile\",\"convert lob basicfile to securefile\",\"migrate basicfile lob to securefile lob\",\"migrate basicfile to securefile\",\"migrate from basicfile to securefile\",\"Move All Partitioned Tables To Migrate From Basicfile to SecureFile\",\"oracle 12c convert basicfile to securefile\",\"oracle migrate basicfile to securefile\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/\",\"name\":\"How To Migrate From BasicFiles to SecureFiles - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-38.png\",\"datePublished\":\"2019-12-02T06:48:37+00:00\",\"dateModified\":\"2019-12-02T06:56:42+00:00\",\"description\":\"How To Migrate From BasicFiles to SecureFiles\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-38.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-38.png\",\"width\":650,\"height\":310},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Migrate From BasicFiles to SecureFiles\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Migrate From BasicFiles to SecureFiles - Database Tutorials","description":"How To Migrate From BasicFiles to SecureFiles","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:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/","og_locale":"en_US","og_type":"article","og_title":"How To Migrate From BasicFiles to SecureFiles - Database Tutorials","og_description":"How To Migrate From BasicFiles to SecureFiles","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-02T06:48:37+00:00","article_modified_time":"2019-12-02T06:56:42+00:00","og_image":[{"width":650,"height":310,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-38.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Migrate From BasicFiles to SecureFiles","datePublished":"2019-12-02T06:48:37+00:00","dateModified":"2019-12-02T06:56:42+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/"},"wordCount":213,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-38.png","keywords":["convert basicfile to securefile","convert clob from basicfile to securefile","convert lob basicfile to securefile","migrate basicfile lob to securefile lob","migrate basicfile to securefile","migrate from basicfile to securefile","Move All Partitioned Tables To Migrate From Basicfile to SecureFile","oracle 12c convert basicfile to securefile","oracle migrate basicfile to securefile"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/","name":"How To Migrate From BasicFiles to SecureFiles - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-38.png","datePublished":"2019-12-02T06:48:37+00:00","dateModified":"2019-12-02T06:56:42+00:00","description":"How To Migrate From BasicFiles to SecureFiles","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-38.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-38.png","width":650,"height":310},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/how-to-migrate-from-basicfiles-to-securefiles\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Migrate From BasicFiles to SecureFiles"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13791","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=13791"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13791\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13792"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}