{"id":15525,"date":"2020-05-10T15:35:40","date_gmt":"2020-05-10T15:35:40","guid":{"rendered":"https:\/\/ittutorial.org\/?p=15525"},"modified":"2020-10-02T09:38:00","modified_gmt":"2020-10-02T09:38:00","slug":"content-expdp-impdp-metadata_only-data_only-parameter-in-oracle-datapump","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/content-expdp-impdp-metadata_only-data_only-parameter-in-oracle-datapump\/","title":{"rendered":"How to Use CONTENT ( DATA_ONLY , METADATA_ONLY ) Parameter in Oracle Datapump"},"content":{"rendered":"<p>Hi,<\/p>\n<p>I will explain How to Use CONTENT ( DATA_ONLY , METADATA_ONLY ) Parameter in Oracle Datapump\u00a0in this post.<\/p>\n<p><!--more--><\/p>\n<p>&nbsp;<\/p>\n<h1><span style=\"color: #ff0000;\">Expdp Content ( DATA_ONLY , METADATA_ONLY )<\/span><\/h1>\n<p>You can read the following post to learn more detail about Oracle Datapump.<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"19obKD3VBP\"><p><a href=\"https:\/\/ittutorial.org\/oracle-data-pump-export-import-expdp-impdp-tutorial-with-examples-4\/\">Oracle Data Pump &#8211; Export Import ( Expdp Impdp ) Tutorial with Examples-4<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Oracle Data Pump &#8211; Export Import ( Expdp Impdp ) Tutorial with Examples-4&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-data-pump-export-import-expdp-impdp-tutorial-with-examples-4\/embed\/#?secret=tZbjHbqEfk#?secret=19obKD3VBP\" data-secret=\"19obKD3VBP\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"t9Ttkv7NZl\"><p><a href=\"https:\/\/ittutorial.org\/table_exists_action-replace-during-impdp-in-datapump-oracle\/\">How to Use TABLE_EXISTS_ACTION During IMPDP in Oracle Datapump<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;How to Use TABLE_EXISTS_ACTION During IMPDP in Oracle Datapump&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/table_exists_action-replace-during-impdp-in-datapump-oracle\/embed\/#?secret=fU9fUJajnj#?secret=t9Ttkv7NZl\" data-secret=\"t9Ttkv7NZl\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span class=\"\" title=\"\"><span style=\"color: #ff0000;\">CONTENT:<\/span> This parameter enables you to filter what is export and import during the export &#8211; import operation.<\/span><\/p>\n<pre><\/pre>\n<pre>CONTENT={ALL | DATA_ONLY | METADATA_ONLY}\r\n<\/pre>\n<ul>\n<li><code>ALL<\/code> This is the default value and loads all data and metadata contained in the source.<\/li>\n<li><code>DATA_ONLY<\/code>\u00a0 You can load only table row data into existing tables without any metadata with this option.<\/li>\n<li><code>METADATA_ONLY<\/code> You can load only database object metadata ( definition ) without table row data.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>For example: you run the following import command, If you don&#8217;t use CONTENT parameter or use CONTENT=ALL,\u00a0 then Oracle will load all data and metadata contained in the source.<\/p>\n<p>&nbsp;<\/p>\n<pre><strong><span style=\"color: #ff0000;\">the new table = New data and new Metadata <\/span><\/strong>\r\n\r\nimpdp \\\"\/ as sysdba\\\" SCHEMAS=HR DIRECTORY=DATAPUMP LOGFILE=HR.log\r\n\r\nimpdp \\\"\/ as sysdba\\\" SCHEMAS=HR DIRECTORY=DATAPUMP LOGFILE=HR.log <strong><span style=\"color: #ff0000;\">CONTENT=ALL\r\n\r\n<\/span><\/strong><\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<h2><strong><span style=\"color: #ff0000;\">CONTENT=DATA_ONLY <\/span><\/strong><\/h2>\n<p>If you use <strong><span style=\"color: #ff0000;\">CONTENT=DATA_ONLY <\/span><\/strong>option, then Oracle will load only table row data into existing tables without any metadata with this option.<\/p>\n<pre><strong><span style=\"color: #ff0000;\">the new table= Old Metadata + New data <\/span><\/strong>\r\n\r\nimpdp \\\"\/ as sysdba\\\" SCHEMAS=HR DIRECTORY=DATAPUMP LOGFILE=HR.log <strong><span style=\"color: #ff0000;\">CONTENT=DATA_ONLY<\/span><\/strong><strong><span style=\"color: #ff0000;\">\u00a0<\/span> <\/strong><\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span style=\"color: #ff0000;\">CONTENT=METADATA_ONLY<\/span><\/strong><\/h3>\n<p>If you use <strong><span style=\"color: #ff0000;\">CONTENT=METADATA_ONLY <\/span><\/strong>, then Oracle will load only database object metadata ( definition ) without table row data.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<pre><strong><span style=\"color: #ff0000;\">the new table= Only New metadata <\/span><\/strong>\r\n\r\nimpdp \\\"\/ as sysdba\\\" SCHEMAS=HR DIRECTORY=DATAPUMP LOGFILE=HR.log <strong><span style=\"color: #ff0000;\">CONTENT=METADATA_ONLY<\/span><\/strong><\/pre>\n<p>&nbsp;<\/p>\n<pre><\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn more details about RMAN, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"NqTRE98Apx\"><p><a href=\"https:\/\/ittutorial.org\/rman-tutorial-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database\/\">RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/rman-tutorial-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database\/embed\/#?secret=3CDUmzoVxO#?secret=NqTRE98Apx\" data-secret=\"NqTRE98Apx\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain How to Use CONTENT ( DATA_ONLY , METADATA_ONLY ) Parameter in Oracle Datapump\u00a0in this post.<\/p>\n","protected":false},"author":1,"featured_media":3388,"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,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5044,1994],"tags":[10347,10348,10349,13714,10345,10346,7908,10344,10340,7914,7911,7256,10342,10326,10338,10350,10331,10339,13715,10343,10341,10332],"class_list":["post-15525","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-datapump","category-oracle","tag-contentall","tag-contentdata_only","tag-contentmetadata_only","tag-expdp-content-data_only","tag-expdp-excludestatistics","tag-expdp-excludetable","tag-expdp-flashback_time","tag-expdp-includetable","tag-expdp-metadata-only","tag-expdp-parfile","tag-expdp-query","tag-expdp-query-example-multiple-tables","tag-how-to-import-dump-file-in-oracle-12c","tag-impdp-contentdata_only","tag-impdp-contentdata_only-truncate","tag-impdp-contentmetadata_only","tag-impdp-remap_schema","tag-impdp-remap_table","tag-metadata_only","tag-oracle-data-pump-12c","tag-oracle-data-pump-tutorial","tag-table_exists_action"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/10\/data-pump-2.gif","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/15525","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=15525"}],"version-history":[{"count":3,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/15525\/revisions"}],"predecessor-version":[{"id":19525,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/15525\/revisions\/19525"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/3388"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=15525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=15525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=15525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}