{"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;&nbsp;<\/p>\n","protected":false},"author":25,"featured_media":0,"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":[240,23,17,36],"class_list":["post-2949","post","type-post","status-publish","format-standard","hentry","category-database","tag-data-pump","tag-dba","tag-oracle-11g","tag-tablespaces"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Wie kann ich Indexes und Daten mittels Data Pump trennen? - dbi services | 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 services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\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: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=\"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\\\/ee31feb6f100473958f6f8193c36f427\"},\"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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"keywords\":[\"Data Pump\",\"DBA\",\"Oracle 11g\",\"Tablespaces\"],\"articleSection\":[\"Database\"],\"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 services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2013-02-18T02:42:00+00:00\",\"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 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\\\/ee31feb6f100473958f6f8193c36f427\",\"name\":\"J\u00e9r\u00f4me Witt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JEW_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JEW_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JEW_web-min-scaled.jpg\",\"caption\":\"J\u00e9r\u00f4me Witt\"},\"description\":\"J\u00e9r\u00f4me Witt leads the entire Oracle consulting team in Basel, having started his consulting career in 2008. He specializes in database and infrastructure management, Oracle high availability, backup and recovery, and performance tuning, alongside open-source technologies (Linux\\\/Unix), Perl, Shell, and Windows PowerShell, with a recent focus on automation using Ansible. He holds Oracle 12c\\\/11g Certified Professional, Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certifications, and leads the Oracle DBA Essentials, Multitenant, and Ansible workshops. Prior to dbi services, he was a Consultant at Trivadis in Basel. His industry experience covers pharma, healthcare, banking and financial services, energy, and automotive.\",\"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 services | 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 services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2013-02-18T02:42:00+00:00","author":"J\u00e9r\u00f4me Witt","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","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\/ee31feb6f100473958f6f8193c36f427"},"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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"keywords":["Data Pump","DBA","Oracle 11g","Tablespaces"],"articleSection":["Database"],"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 services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2013-02-18T02:42:00+00:00","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 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\/ee31feb6f100473958f6f8193c36f427","name":"J\u00e9r\u00f4me Witt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JEW_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JEW_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JEW_web-min-scaled.jpg","caption":"J\u00e9r\u00f4me Witt"},"description":"J\u00e9r\u00f4me Witt leads the entire Oracle consulting team in Basel, having started his consulting career in 2008. He specializes in database and infrastructure management, Oracle high availability, backup and recovery, and performance tuning, alongside open-source technologies (Linux\/Unix), Perl, Shell, and Windows PowerShell, with a recent focus on automation using Ansible. He holds Oracle 12c\/11g Certified Professional, Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certifications, and leads the Oracle DBA Essentials, Multitenant, and Ansible workshops. Prior to dbi services, he was a Consultant at Trivadis in Basel. His industry experience covers pharma, healthcare, banking and financial services, energy, and automotive.","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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}