{"id":2949,"date":"2013-02-18T03:42:00","date_gmt":"2013-02-18T02:42:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/"},"modified":"2013-02-18T03:42:00","modified_gmt":"2013-02-18T02:42:00","slug":"wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/","title":{"rendered":"Wie kann ich Indexes und Daten mittels Data Pump trennen?"},"content":{"rendered":"<p>Diese Frage habe ich in den letzten Jahren \u00f6fters geh\u00f6rt. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export\/Import Tools.\u00a0Angeblich war es fr\u00fcher mit dem Import-Parameter-Tool \u201eINDEXFILE\u201c viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch leichter!<\/p>\n<p>Dies m\u00f6chte ich anhand eines ganz normalen Datapump-Export\u2013Files verdeutlichen. In folgendem Beispiel handelt es sich um einen einfachen Schema-Export, der wie folgt erzeugt wurde:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@vmoel58:\/u00\/app\/oracle\/admin\/DB112\/etc\/ [DB112] cat expdp_SalesApp.par \nSCHEMAS=sh\nDIRECTORY=data_pump_dir\nDUMPFILE=expdp_SH_2013-02-17.dmp\nLOGFILE=expdp_SH_2013-02-17.log\nPARALLEL=4\noracle@vmoel58:\/u00\/app\/oracle\/admin\/DB112\/etc\/ [DB112] expdp parfile=expdp_SalesApp.par\nExport: Release 11.2.0.3.0 - Production on Sun Feb 17 16:08:27 2013\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.\u00a0 All rights reserved.\nUsername: system\nPassword:\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\nStarting \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\":\u00a0 system\/******** parfile=expdp_SalesApp.par \nEstimate in progress using BLOCKS method...\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\nTotal estimation using BLOCKS method: 273.8 MB\n. . exported \"SH\".\"CUSTOMERS\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9.853 MB\u00a0\u00a0 55500 rows\n... [Aus Formatierungsgr\u00fcnden wurde dieser Teil herausgefiltert]\n\n. . exported \"SH\".\"SALES\":\"SALES_Q4_2003\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 rows\nMaster table \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\" successfully loaded\/unloaded\n******************************************************************************\nDump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:\n\u00a0 \/u00\/app\/oracle\/admin\/DB112\/dpdump\/expdp_SH_2013-02-17.dmp\nJob \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\" successfully completed at 16:09:00\nZuerst sollten die gesamten Daten und alle anderen Objekte, ausser die Indexes importiert werden. In diesem Fall ist der Parameter EXCLUDE der Schl\u00fcssel zum Erfolg:\noracle@vmoel58:\/u00\/app\/oracle\/admin\/DB112\/etc\/ [DB112] impdp parfile=expdp_SalesApp.par remap_schema=sh:sh_v2 exclude=INDEX\nImport: Release 11.2.0.3.0 - Production on Sun Feb 17 16:15:42 2013\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.\u00a0 All rights reserved.\nUsername: system\nPassword:\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\nMaster table \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\" successfully loaded\/unloaded\nStarting \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\":\u00a0 system\/******** parfile=expdp_SalesApp.par remap_schema=sh:sh_v2 exclude=INDEXProcessing object type SCHEMA_EXPORT\/USER\nProcessing object type SCHEMA_EXPORT\/SYSTEM_GRANT\nProcessing object type SCHEMA_EXPORT\/ROLE_GRANT\nProcessing object type SCHEMA_EXPORT\/DEFAULT_ROLE\n... (Aus Formatierungs-Gr\u00fcnd wurde dieser Teil herausgefiltert)<\/pre>\n<p>In einem zweiten Schritt m\u00fcssen die Indexes importiert werden. Der INCLUDE Parameter enth\u00e4lt den INDEX-Schl\u00fcssel, dieser umfasst die Index-Statistiken.\u00a0Die Tablespace-\u00c4nderung erfolgt durch den REMAP_TABLESPACE Parameter:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@vmoel58:\/u00\/app\/oracle\/admin\/DB112\/etc\/ [DB112] impdp parfile=expdp_SalesApp.par remap_schema=sh:sh_v2 include=INDEX remap_tablespace=SH_DATA:SH_IDX\nImport: Release 11.2.0.3.0 - Production on Sun Feb 17 16:23:58 2013\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.\u00a0 All rights reserved.\nUsername: system\nPassword:\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\nMaster table \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\" successfully loaded\/unloaded\nStarting \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\":\u00a0 system\/******** parfile=expdp_SalesApp.par remap_schema=sh:sh_v2 include=INDEX remap_tablespace=USERS:SH_IDX \nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/INDEX\nORA-31684: Object type INDEX:\"SH_V2\".\"PROMO_PK\" already exists\nORA-31684: Object type INDEX:\"SH_V2\".\"CUSTOMERS_PK\" already exists\nORA-31684: Object type INDEX:\"SH_V2\".\"PRODUCTS_PK\" already exists\nORA-31684: Object type INDEX:\"SH_V2\".\"TIMES_PK\" already exists\nORA-31684: Object type INDEX:\"SH_V2\".\"CHANNELS_PK\" already exists\nORA-31684: Object type INDEX:\"SH_V2\".\"COUNTRIES_PK\" already exists\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\nORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:\"SH_V2\".\"TIMES_PK\" already exists\nORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:\"SH_V2\".\"PRODUCTS_PK\" already exists\nORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:\"SH_V2\".\"CHANNELS_PK\" already exists\nORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:\"SH_V2\".\"PROMO_PK\" already exists\nORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:\"SH_V2\".\"CUSTOMERS_PK\" already exists\nORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:\"SH_V2\".\"COUNTRIES_PK\" already exists\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/BITMAP_INDEX\/INDEX\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/BITMAP_INDEX\/INDEX_STATISTICS\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/DOMAIN_INDEX\/INDEX\nJob \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\" completed with 12 error(s) at 16:24:05<\/pre>\n<p>Die Prim\u00e4r Schl\u00fcssen Indexes sind durch den EXLUDE Paramater wegen dem &#8220;Constraint&#8221; nicht beeinflusst. Deswegen muss ebenso jeweils in EXCLUDE und INCLUDE der Schl\u00fcssel CONSTRAINT mitangegeben werden:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@vmoel58:\/u00\/app\/oracle\/admin\/DB112\/etc\/ [DB112] impdp parfile=expdp_SalesApp.par remap_schema=sh:sh_v2 include=INDEX,CONSTRAINT remap_tablespace=SH_DATA:SH_IDX\nImport: Release 11.2.0.3.0 - Production on Sun Feb 17 17:08:50 2013\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.\u00a0 All rights reserved.\n...<\/pre>\n<p>Folgendes SQL-Statement stellt die Objekttrennung dar:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; SELECT segment_type,tablespace_name FROM dba_segments \nWHERE owner='SH_V2' AND segment_type IN ('TABLE','INDEX') GROUP BY segment_type,tablespace_name;SEGMENT_TYPE\u00a0\u00a0\u00a0 \u00a0\u00a0 TABLESPACE_NAME\n------------------ ------------------------------\nTABLE\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0 SH_DATA\nINDEX\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0 SH_IDX<\/pre>\n<p>Et voila, das wars! \u00dcbrigens mit anderen Data-Pump-Parametern wie zum Beispiel TABLE_EXISTS_ACTION kann man vieles mehr erreichen. Ein Blick in der Oracle Dokumentation \u201eOracle Database Utilities\u201c lohnt sich hier sehr.<\/p>\n<p>Bei Anmerkungen oder Fragen freue ich mich auf einen Kommentar.<br \/>\nViel Spass mit Oracle Data Pump!<\/p>\n<p>J\u00e9r\u00f4me<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Diese Frage habe ich in den letzten Jahren \u00f6fters geh\u00f6rt. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export\/Import Tools.\u00a0Angeblich war es fr\u00fcher mit dem Import-Parameter-Tool \u201eINDEXFILE\u201c viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch leichter! Dies m\u00f6chte ich anhand eines ganz normalen Datapump-Export\u2013Files verdeutlichen. In folgendem Beispiel handelt es [&hellip;]<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[240,23,17,36],"type_dbi":[],"class_list":["post-2949","post","type-post","status-publish","format-standard","hentry","category-database-management","tag-data-pump","tag-dba","tag-oracle-11g","tag-tablespaces"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Wie kann ich Indexes und Daten mittels Data Pump trennen? - dbi Blog<\/title>\n<meta name=\"description\" content=\"Diese Frage habe ich in den letzten Jahren \u00f6fters geh\u00f6rt. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export\/Import Tools. Angeblich war es fr\u00fcher mit dem Import-Parameter-Tool \u201eINDEXFILE\u201c viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch leichter! Dies m\u00f6chte ich anhand eines ganz normalen Datapump-Export\u2013Files verdeutlichen.\" \/>\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\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie kann ich Indexes und Daten mittels Data Pump trennen?\" \/>\n<meta property=\"og:description\" content=\"Diese Frage habe ich in den letzten Jahren \u00f6fters geh\u00f6rt. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export\/Import Tools. Angeblich war es fr\u00fcher mit dem Import-Parameter-Tool \u201eINDEXFILE\u201c viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch leichter! Dies m\u00f6chte ich anhand eines ganz normalen Datapump-Export\u2013Files verdeutlichen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-18T02:42:00+00:00\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Witt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00f4me Witt\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Witt\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7\"},\"headline\":\"Wie kann ich Indexes und Daten mittels Data Pump trennen?\",\"datePublished\":\"2013-02-18T02:42:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/\"},\"wordCount\":199,\"commentCount\":0,\"keywords\":[\"Data pump\",\"DBA\",\"Oracle 11g\",\"Tablespaces\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/\",\"name\":\"Wie kann ich Indexes und Daten mittels Data Pump trennen? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2013-02-18T02:42:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7\"},\"description\":\"Diese Frage habe ich in den letzten Jahren \u00f6fters geh\u00f6rt. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export\/Import Tools. Angeblich war es fr\u00fcher mit dem Import-Parameter-Tool \u201eINDEXFILE\u201c viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch leichter! Dies m\u00f6chte ich anhand eines ganz normalen Datapump-Export\u2013Files verdeutlichen.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie kann ich Indexes und Daten mittels Data Pump trennen?\"}]},{\"@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\/a2d3ecddaf732850101a39b9d62c31b7\",\"name\":\"J\u00e9r\u00f4me Witt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"caption\":\"J\u00e9r\u00f4me Witt\"},\"description\":\"J\u00e9rome Witt started his Consultant career a few years ago. He is specialized in database and infrastructure management, engineering, and optimization. He is very skilled in Oracle high availability, backup &amp; recovery, and tuning technologies. His expertise also includes the open source field (Linux\/Unix), advanced Perl, Shell, Windows PowerShell programming, and Automation tools (UC4). J\u00e9r\u00f4me Witt is Oracle Certified Professional 11g (OCP 11g), Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certified. Prior to joining dbi services, J\u00e9r\u00f4me Witt was Consultant at Trivadis in Basel. He also worked as a Junior Automation specialist at Selmoni AG in Basel. J\u00e9r\u00f4me Witt holds a BTS degree in Information Systems and Industrial Networks from France. His branch-related experience covers Pharma, Health Care, Banking &amp; Financial Services, Energy, Automotive etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/jerome-witt\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Wie kann ich Indexes und Daten mittels Data Pump trennen? - dbi Blog","description":"Diese Frage habe ich in den letzten Jahren \u00f6fters geh\u00f6rt. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export\/Import Tools. Angeblich war es fr\u00fcher mit dem Import-Parameter-Tool \u201eINDEXFILE\u201c viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch leichter! Dies m\u00f6chte ich anhand eines ganz normalen Datapump-Export\u2013Files verdeutlichen.","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\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/","og_locale":"en_US","og_type":"article","og_title":"Wie kann ich Indexes und Daten mittels Data Pump trennen?","og_description":"Diese Frage habe ich in den letzten Jahren \u00f6fters geh\u00f6rt. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export\/Import Tools. Angeblich war es fr\u00fcher mit dem Import-Parameter-Tool \u201eINDEXFILE\u201c viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch leichter! Dies m\u00f6chte ich anhand eines ganz normalen Datapump-Export\u2013Files verdeutlichen.","og_url":"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/","og_site_name":"dbi Blog","article_published_time":"2013-02-18T02:42:00+00:00","author":"J\u00e9r\u00f4me Witt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Witt","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/"},"author":{"name":"J\u00e9r\u00f4me Witt","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7"},"headline":"Wie kann ich Indexes und Daten mittels Data Pump trennen?","datePublished":"2013-02-18T02:42:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/"},"wordCount":199,"commentCount":0,"keywords":["Data pump","DBA","Oracle 11g","Tablespaces"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/","url":"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/","name":"Wie kann ich Indexes und Daten mittels Data Pump trennen? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2013-02-18T02:42:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7"},"description":"Diese Frage habe ich in den letzten Jahren \u00f6fters geh\u00f6rt. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export\/Import Tools. Angeblich war es fr\u00fcher mit dem Import-Parameter-Tool \u201eINDEXFILE\u201c viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch leichter! Dies m\u00f6chte ich anhand eines ganz normalen Datapump-Export\u2013Files verdeutlichen.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/wie-kann-ich-indexes-und-daten-mittels-data-pump-trennen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Wie kann ich Indexes und Daten mittels Data Pump trennen?"}]},{"@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\/a2d3ecddaf732850101a39b9d62c31b7","name":"J\u00e9r\u00f4me Witt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","caption":"J\u00e9r\u00f4me Witt"},"description":"J\u00e9rome Witt started his Consultant career a few years ago. He is specialized in database and infrastructure management, engineering, and optimization. He is very skilled in Oracle high availability, backup &amp; recovery, and tuning technologies. His expertise also includes the open source field (Linux\/Unix), advanced Perl, Shell, Windows PowerShell programming, and Automation tools (UC4). J\u00e9r\u00f4me Witt is Oracle Certified Professional 11g (OCP 11g), Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certified. Prior to joining dbi services, J\u00e9r\u00f4me Witt was Consultant at Trivadis in Basel. He also worked as a Junior Automation specialist at Selmoni AG in Basel. J\u00e9r\u00f4me Witt holds a BTS degree in Information Systems and Industrial Networks from France. His branch-related experience covers Pharma, Health Care, Banking &amp; Financial Services, Energy, Automotive etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-witt\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2949","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\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2949"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2949\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2949"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}