{"id":369,"date":"2013-05-29T17:21:22","date_gmt":"2013-05-29T20:21:22","guid":{"rendered":"http:\/\/dev.dbarj.com.br\/?p=369"},"modified":"2022-01-04T14:08:51","modified_gmt":"2022-01-04T17:08:51","slug":"run-expdp-compression-oracle-10g-11g","status":"publish","type":"post","link":"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/","title":{"rendered":"Howto run expdp with data compression in Oracle 10g and 11g"},"content":{"rendered":"<p>Many people are still reluctant to use the Oracle export Data Pump (<strong>expdp<\/strong>) in 10g because there is no effective method of compression via pipe as there is in simple export command (<strong>exp<\/strong>). Starting in version 11g, Oracle added the parameter &#8220;<strong>COMPRESS=ALL<\/strong>&#8221; that helps in compressing the dump file generated, but still uses the internal mechanisms for compression without allowing the user to choose the best form of compression.\u00a0It also requires you to have\u00a0the Advanced Compression Option.<\/p>\n<p>To solve this, I developed a script that performs a parallel compression of the files generated by expdp dumps, doing efficiently as the pipe and using the parameter of maximum dump file size of the expdp, also taking advantage of the parallelism parameter.<\/p>\n<h2>1) How the script works?<\/h2>\n<p>When calling the expdp, we define a value for the parameter &#8220;FILESIZE&#8221;, for example, of <strong><span style=\"color: #ff0000;\">1GB<\/span><\/strong>:<br \/>\n<strong>eg:<\/strong> expdp full=Y directory=&#8230; dumpfile=expfile.%u.dmp logfile=expfile.log filesize=<strong><span style=\"color: #ff0000;\">1G<\/span><\/strong><\/p>\n<p>Thus, assuming that its total dump\u00a0file is 30 GBs, the expdp will generate the first 1GB file and when finished, will start to record the second file. At this time, a parallel compression script will act in the first file generated while the second file is being recorded by the database. Compression script can use bzip2, gzip or any other algorithm of your choice and existing on your server.<\/p>\n<p>The script can also take advantage of the &#8220;PARALLEL&#8221; parameter and start recording several files in parallel. As they are coming to the defined &#8220;FILESIZE&#8221;, compression will be performed in the background making the export much faster:<br \/>\neg: expdp full=Y directory=&#8230; dumpfile=expfile.%u.dmp logfile=expfile.log filesize=1G parallel=8<\/p>\n<p>This script, support specific schema export. He\u00a0performs as default a FULL database with one of the following commands (depending on the chosen parameterization):<\/p>\n<ul>\n<li><span style=\"color: #0000ff;\"><strong>EXPDP:<\/strong><\/span>\u00a0expdp full=y directory=&#8230; dumpfile=&#8230; logfile=&#8230; filesize=&#8230; parallel=&#8230;<\/li>\n<li><span style=\"color: #0000ff;\"><strong>EXP:<\/strong><\/span> \u00a0 \u00a0 \u00a0exp file=&#8230; log=&#8230; full=y consistent=y compress=n buffer=9999999 statistics=none direct=y<\/li>\n<\/ul>\n<h2>2) Requirements<\/h2>\n<ul>\n<li>The script has been tested on Linux, HP-UX and Solaris. Actually, the basic requirement is that there are primary unix commands (cd, mktemp, mkfifo, awk, head, etc).<\/li>\n<li>Necessary that the database to be backed up is registered in the oratab file (for exp and expdp) or in TNSNAMES file (for remote exp).<\/li>\n<li>The compression tool desired must be installed (gzip, bzip2, zip, compress, &#8230;).<\/li>\n<\/ul>\n<h2>3) How to install?<\/h2>\n<p>Download it <a href=\"https:\/\/github.com\/dbarj\/expdpcomp\" target=\"_blank\" rel=\"noopener\">here<\/a>!<\/p>\n<p>Unzip the directory &#8220;exp&#8221; in the folder you want to configure Data Pump. Subdirectories will only have shell scripts, configuration files and logs. The dumps will be generated on a configurable destination.<\/p>\n<p><a href=\"http:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2013\/05\/exp-tree.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-361\" src=\"http:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2013\/05\/exp-tree-300x104.png\" alt=\"exp-tree\" width=\"300\" height=\"104\" srcset=\"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2013\/05\/exp-tree-300x104.png 300w, https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2013\/05\/exp-tree.png 573w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>The folder has 3 basic subdirectories:<\/p>\n<ul>\n<li>SH folder &#8211; Contains the shells responsible for export and compression. It is not necessary to change them.<\/li>\n<li>CFG folder &#8211; Contains the configuration files for each instance parameterized.<\/li>\n<li>LOG folder &#8211; Contains the logs of executions.<\/li>\n<\/ul>\n<p>The <strong>SH<\/strong> folder contains 4 shells:<\/p>\n<ul>\n<li>expcron.sh &#8211; This shell only centralizes the execution of everything and saves the log. This is the script that will be called.<\/li>\n<li>expfull.sh &#8211; This shell has the entire Oracle export logic process.<\/li>\n<li>expdpcompress.sh &#8211; This shell has all Oracle dumps logic compression.<\/li>\n<li>expfunctions.sh &#8211; This shell has all methods and functions that will be used by the other scripts.<\/li>\n<\/ul>\n<p>The <strong>CFG<\/strong> folder contains the configuration file of the instance:<\/p>\n<ul>\n<li>orcl.cfg &#8211; The file name should be exactly the same as the instance name you are backing up in the oratab file, appending &#8220;.cfg&#8221;. If this file does not exist, the process attempts to find a file named &#8220;default.cfg&#8221; in that same directory.<\/li>\n<\/ul>\n<p>The <strong>LOG<\/strong> folder is initially empty and contains the executions logs.<\/p>\n<p>Set the permissions on the directories and files according to the below:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[oracle@ec12mntrjr001 exp]$ ls -laR .\/\r\n.\/:\r\ntotal 24\r\ndrwxr-x---  5 oracle dba      4096 Mar 24 12:09 .\r\ndrwx------ 15 oracle oinstall 4096 Mar 24 12:08 ..\r\ndrwx------  2 oracle dba      4096 Mar 24 12:08 cfg\r\ndrwxr-x---  2 oracle dba      4096 Mar 24 12:08 log\r\ndr-xr-x---  2 oracle dba      4096 Mar 24 12:08 sh\r\n\r\n.\/cfg:\r\ntotal 12\r\ndrwx------ 2 oracle dba 4096 Mar 24 12:08 .\r\ndrwxr-x--- 5 oracle dba 4096 Mar 24 12:09 ..\r\n-rw------- 1 oracle dba 1138 Aug 23  2013 default.cfg\r\n\r\n.\/log:\r\ntotal 8\r\ndrwxr-x--- 2 oracle dba 4096 Mar 24 12:08 .\r\ndrwxr-x--- 5 oracle dba 4096 Mar 24 12:09 ..\r\n\r\n.\/sh:\r\ntotal 36\r\ndr-xr-x--- 2 oracle dba 4096 Mar 24 12:08 .\r\ndrwxr-x--- 5 oracle dba 4096 Mar 24 12:09 ..\r\n-r-xr-x--- 1 oracle dba 2268 Aug 28  2013 expcron.sh\r\n-r-xr-x--- 1 oracle dba 4885 Nov 28 11:25 expdpcompress.sh\r\n-r-xr-x--- 1 oracle dba 8818 Aug 29  2013 expfull.sh\r\n-r-xr-x--- 1 oracle dba 3699 Nov 28 11:35 expfunctions.sh\r\n[oracle@ec12mntrjr001 exp]$<\/pre>\n<h2>4) Configuring<\/h2>\n<p>The configuration file &#8220;oracle_sid.cfg&#8221; existing in the cfg folder (where oracle_sid is the SID of the instance to be backed up) requires the following parameters:<\/p>\n<h4>&#8211; EXPTYPE<\/h4>\n<p>Optional parameter that specifies the type of export and Oracle binary to be called (&#8220;exp&#8221; or &#8220;expdp&#8221;). Accepts the values \u200b\u200b&#8221;EXP&#8221; or &#8220;EXPDP&#8221;. If omitted, the default value &#8220;EXP&#8221; will be used.<br \/>\nEg: EXPTYPE=EXPDP<\/p>\n<h4>&#8211; EXPRETENTION<\/h4>\n<p>Mandatory parameter that determines the retention time of the old backups, in days. After the end of the process, dump files before &#8220;EXPRETENTION&#8221; days will be deleted.<br \/>\nEg: EXPRETENTION=3<\/p>\n<h4>&#8211; EXPUSER<\/h4>\n<p>Mandatory parameter that defines the user and password that will connect the database to perform the export. It is recommended to create a user exclusive for this purpose, giving the user only the grants required, as follows:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">create user expuser identified by asb378 default tablespace USERS temporary tablespace TEMP profile DEFAULT quota unlimited on users;\r\ngrant exp_full_database to expuser;\r\ngrant create session to expuser;\r\ngrant create table to expuser;<\/pre>\n<p>Eg: EXPUSER=expuser\/asb378<\/p>\n<h4>&#8211; EXPDEST<\/h4>\n<p>Mandatory parameter that defines the folder where the dump will be written. This folder must also exist within the instance if the variable &#8220;EXPTYPE&#8221; is &#8220;expdp&#8221;, as follows:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">create or replace directory EXPDP1 as '\/u02\/export\/dump';\r\ngrant read,write on directory EXPDP1 to expuser;<\/pre>\n<p>Eg: EXPDEST=\/u02\/export\/dump<\/p>\n<h4>&#8211; COMPALG<\/h4>\n<p>Mandatory parameter that determines the command line to run the compression tool. Currently, only supports Gzip or Bzip2.<br \/>\nBzip2 is slower but the file is much smaller. If the export type is &#8220;expdp&#8221;, this compression will occur in the background at the end of each part. If &#8220;exp&#8221;, the compression will run through PIPE.<br \/>\nEg: COMPALG=&#8221;bzip2 -9&#8243;<\/p>\n<h4>&#8211; EXPPARALLEL<\/h4>\n<p>Mandatory parameter if the value of &#8220;EXPTYPE&#8221; variable is &#8220;EXPDP&#8221;. Specifies the amount of jobs that will run parallel export, being passed to the parameter &#8220;PARALLEL&#8221; of &#8220;expdp&#8221; command. Do not exceed 2x the number of CPUs. If you are generating a small dump, leave as &#8220;1&#8221;. If the variable &#8220;EXPTYPE&#8221; is &#8220;EXP&#8221; or null, this parameter is ignored.<br \/>\nEg: EXPPARALLEL=2<\/p>\n<h4>&#8211; EXPFILESIZE<\/h4>\n<p>Mandatory parameter if the value of &#8220;EXPTYPE&#8221; variable is &#8220;EXPDP&#8221;. Specifies the maximum size of each dump file being passed to the parameter &#8220;FILESIZE&#8221; of &#8220;expdp&#8221; command. Do not leave too small because the maximum limit are 99 files. The size must be specified in the format of GBs. If the variable &#8220;EXPTYPE&#8221; is &#8220;EXP&#8221; or null, this parameter is ignored.<br \/>\nEg: EXPFILESIZE=3G<\/p>\n<h4>&#8211; TARCOMPACT<\/h4>\n<p>Mandatory parameter if the value of &#8220;EXPTYPE&#8221; variable is &#8220;EXPDP&#8221;. Specifies whether in the end of the process, all the export files compressed will be joined into a single TAR (1= Yes, 0=No). If the variable &#8220;EXPTYPE&#8221; is &#8220;EXP&#8221; or null, this parameter is ignored.<br \/>\nEg: TARCOMPACT=0<\/p>\n<h4>&#8211; RESOLVTNS<\/h4>\n<p>Optional parameter and only applies if the value of &#8220;EXPTYPE&#8221; variable is &#8220;EXP&#8221; or null. Specifies the database connection string inside TNSNAMES file, if you wish to run backup of a remote server. Only works for &#8220;exp&#8221;, not &#8220;expdp&#8221;. If the variable &#8220;EXPTYPE&#8221; is &#8220;EXPDP&#8221; and this parameter is specified, the process will show\u00a0an alert and stops.<br \/>\nEg: RESOLVTNS=orcl.world<\/p>\n<h4>&#8211; EXPPARAM<\/h4>\n<p>Optional parameter that alters the default call of &#8220;exp&#8221; and &#8220;expdp&#8221; commands. If omitted, the default value will be:<\/p>\n<ul>\n<li><strong><span style=\"color: #0000ff;\">EXPDP:<\/span><\/strong>EXPPARAM=&#8221;full=Y flashback_time=systimestamp&#8221;<\/li>\n<li><strong><span style=\"color: #0000ff;\">EXP:<\/span><\/strong> EXPPARAM=&#8221;full=y consistent=y compress=n statistics=none direct=y buffer=9999999&#8243;<\/li>\n<\/ul>\n<p>Eg:\u00a0EXPPARAM=&#8221;full=y consistent=y compress=n statistics=none direct=y buffer=9999999 rows=n&#8221;<\/p>\n<h4>&#8211; EXPDEBUG<\/h4>\n<p>Optional parameter that will generate all the execution trace inside the log file. If omitted, the default value will be 0 (OFF).<br \/>\nEg: EXPDEBUG=1<\/p>\n<div style=\"width: 100%; height: 2px; background: #000000;\"><\/div>\n<h4><span style=\"color: #800000;\">Scenarios samples:<\/span><\/h4>\n<p>a) Example configuration to export data pump (expdp) with no executions in parallel, maximum size for each dump is 3 GBs.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">EXPTYPE=EXPDP\r\nEXPRETENTION=7\r\nEXPUSER=expuser\/asb378\r\nEXPDEST=\/u02\/export\/dump\r\nCOMPALG=\"bzip2 -9\"\r\nEXPPARALLEL=1\r\nEXPFILESIZE=3G\r\nTARCOMPACT=0<\/pre>\n<p>b) Example configuration to export data pump (expdp) with 8 executions in parallel, maximum size for each dump is 2 GBs.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">EXPTYPE=EXPDP\r\nEXPRETENTION=7\r\nEXPUSER=expuser\/asb378\r\nEXPDEST=\/u02\/export\/dump\r\nCOMPALG=\"bzip2 -9\"\r\nEXPPARALLEL=8\r\nEXPFILESIZE=2G\r\nTARCOMPACT=0<\/pre>\n<p>c) Example configuration for simple export (exp).<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">EXPTYPE=EXP\r\nEXPRETENTION=7\r\nEXPUSER=expuser\/asb378\r\nEXPDEST=\/u02\/export\/dump\r\nCOMPALG=\"bzip2 -9\"<\/pre>\n<p>d) Example configuration for simple structure export (exp) of SCOTT schema.<\/p>\n<pre>EXPTYPE=EXP\r\nEXPRETENTION=7\r\nEXPUSER=expuser\/asb378\r\nEXPDEST=\/u02\/export\/dump\r\nCOMPALG=\"bzip2 -9\"\r\nEXPPARAM=\"owner=scott consistent=y compress=n statistics=none direct=y buffer=9999999 rows=n\"<\/pre>\n<p>e) Example configuration for simple remote export (exp) through TNSNAMES.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">EXPTYPE=EXP\r\nEXPRETENTION=7\r\nEXPUSER=expuser\/asb378\r\nEXPDEST=\/u02\/export\/dump\r\nCOMPALG=\"bzip2 -9\"\r\nRESOLVTNS=orcl.world<\/pre>\n<h2>5) Running<\/h2>\n<p>To execute the export script, we run the shell expcron.sh passing as a parameter the instance sid exactly as written in the oratab file.<br \/>\nThus, the script will fetch the configuration folder for the file &#8220;oracle_sid.cfg&#8221; or the file &#8220;default.cfg&#8221;, if the first one does not exist.<\/p>\n<p>Example of punctual execution:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[oracle@orasrv ~]$ cat \/etc\/oratab\r\n#\r\norcldb:\/u01\/app\/oracle\/product\/11.2.3\/db_1:Y\r\n[oracle@orasrv ~]$ $EXPORT_HOME\/sh\/expcron.sh orcldb &amp;\r\n[1] 17637$<\/pre>\n<p>The execution log is written in the log folder &#8220;$EXPORT_HOME\/log&#8221;.<\/p>\n<p>Example of backup scheduled in crontab (most common), running every day at 21h:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[oracle@orasrv ~]$ crontab -l\r\n00 21 * * * \/u02\/export\/exp\/sh\/expcron.sh orcldb<\/pre>\n<p><span style=\"color: #ff0000;\">NOTE 1<\/span>: The script does not run on servers that have two identical ORACLE_SID in different ORACLE_HOME&#8217;s. The script also does not accept to run as root, for security reasons.<\/p>\n<p><span style=\"color: #ff0000;\">NOTE 2<\/span>: If the export method is simple remote export (exp) via TNSNAMES, obviously there is no requirement for the presence of the SID in oratab file. The single\u00a0parameter of the &#8220;expcron.sh&#8221; command will only be used to locate the configuration file &#8220;oracle_sid.cfg&#8221; and it will read the string name inside TNSNAMES files.<\/p>\n<h2><strong>6) Script output<\/strong><\/h2>\n<p>In addition to the log file generated in the directory &#8220;$EXPORT_HOME\/log&#8221;, the output of the script is obviously a compressed DUMP file (if &#8220;exp&#8221;) or multiple compressed DUMPS files inserted into a folder created by the process (if &#8220;expdp&#8221;). If the variable &#8220;TARCOMPACT&#8221; has been set to &#8220;1&#8221;, the entire directory will be placed in a container &#8220;.tar&#8221; file.<br \/>\nThe log of the export output will also be generated along with the dump file.<\/p>\n<h2><strong>7) Conclusion<\/strong><\/h2>\n<p>Now we can run the expdp with in a efficient way, compressing files. If the compression is too slow, try changing the second parameter of the &#8220;gzip&#8221; tool (or &#8220;bzip2&#8221;) to &#8220;&#8211; fast&#8221; (or &#8220;-1&#8221;). If the files are too big, do the opposite, switch to &#8220;&#8211; best&#8221; (or &#8220;-9&#8221;).<\/p>\n<p>Try it and leave below any questions or suggestions.<br \/>\nDownload it <a href=\"https:\/\/github.com\/dbarj\/expdpcomp\" target=\"_blank\" rel=\"noopener\">here<\/a>!<\/p>\n<b>Have you enjoyed? Please leave a comment or give a ?!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-369 jlk' href='javascript:void(0)' data-task='like' data-post_id='369' data-nonce='b7aaf4ff99' rel='nofollow'><img class='wti-pixel' src='https:\/\/dev.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-369 lc'>+8<\/span><\/a><\/div><\/div> <div class='status-369 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Many people are still reluctant to use the Oracle export Data Pump (expdp) in 10g because there is no effective method of compression via pipe as there is in simple export command (exp). Starting in version 11g, Oracle added the parameter &#8220;COMPRESS=ALL&#8221; that helps in compressing the dump file generated, but still uses the internal &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-369","post","type-post","status-publish","format-standard","hentry","category-database-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Howto run expdp with data compression in Oracle 10g and 11g - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"How to run expdp with data compression in Oracle 10g equivalent to compression=all.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Howto run expdp with data compression in Oracle 10g and 11g\",\"datePublished\":\"2013-05-29T20:21:22+00:00\",\"dateModified\":\"2022-01-04T17:08:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/\"},\"wordCount\":1565,\"commentCount\":40,\"publisher\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/exp-tree-300x104.png\",\"articleSection\":[\"Oracle Database General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/\",\"name\":\"Howto run expdp with data compression in Oracle 10g and 11g - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/exp-tree-300x104.png\",\"datePublished\":\"2013-05-29T20:21:22+00:00\",\"dateModified\":\"2022-01-04T17:08:51+00:00\",\"description\":\"How to run expdp with data compression in Oracle 10g equivalent to compression=all.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/#primaryimage\",\"url\":\"http:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/exp-tree-300x104.png\",\"contentUrl\":\"http:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/exp-tree-300x104.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2013\\\/05\\\/run-expdp-compression-oracle-10g-11g\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Howto run expdp with data compression in Oracle 10g and 11g\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Howto run expdp with data compression in Oracle 10g and 11g - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"How to run expdp with data compression in Oracle 10g equivalent to compression=all.","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:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/#article","isPartOf":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/"},"author":{"name":"DBA RJ","@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Howto run expdp with data compression in Oracle 10g and 11g","datePublished":"2013-05-29T20:21:22+00:00","dateModified":"2022-01-04T17:08:51+00:00","mainEntityOfPage":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/"},"wordCount":1565,"commentCount":40,"publisher":{"@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/#primaryimage"},"thumbnailUrl":"http:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2013\/05\/exp-tree-300x104.png","articleSection":["Oracle Database General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/","url":"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/","name":"Howto run expdp with data compression in Oracle 10g and 11g - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/dev.dbarj.com.br\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/#primaryimage"},"image":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/#primaryimage"},"thumbnailUrl":"http:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2013\/05\/exp-tree-300x104.png","datePublished":"2013-05-29T20:21:22+00:00","dateModified":"2022-01-04T17:08:51+00:00","description":"How to run expdp with data compression in Oracle 10g equivalent to compression=all.","breadcrumb":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/#primaryimage","url":"http:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2013\/05\/exp-tree-300x104.png","contentUrl":"http:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2013\/05\/exp-tree-300x104.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dev.dbarj.com.br\/en\/2013\/05\/run-expdp-compression-oracle-10g-11g\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dev.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Howto run expdp with data compression in Oracle 10g and 11g"}]},{"@type":"WebSite","@id":"https:\/\/dev.dbarj.com.br\/en\/#website","url":"https:\/\/dev.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dev.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=369"}],"version-history":[{"count":2,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/369\/revisions"}],"predecessor-version":[{"id":14778,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/369\/revisions\/14778"}],"wp:attachment":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}