{"id":9975,"date":"2017-04-22T21:28:52","date_gmt":"2017-04-22T19:28:52","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/"},"modified":"2017-04-22T21:28:52","modified_gmt":"2017-04-22T19:28:52","slug":"data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/","title":{"rendered":"Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nData Pump is a powerful way to save data or metadata, move it, migrate, etc. Here is an example showing few new features in 12cR1 and 12cR2.
\n<\/p>\n

New parameters<\/h3>\n

Here is the result of a diff between 12.1 and 12.2 ‘imp help=y’
\n\"CaptureDataPump122\"<\/a><\/p>\n

But for this post, I’ll show the parameters that existed in 12.1 but have been enhanced in 12.2<\/p>\n

LOGTIME<\/h3>\n

This is a 12.1 feature. The parameter LOGTIME=ALL displays the system timestamp in front of the messages in at the screen and in the logfile. The default is NONE and you can also set it to STATUS for screen only and LOGFILE for logfile only.<\/p>\n

\n[oracle@vmreforanf12c01 tmp]$ expdp system\/manager@PDB01 parfile=impdp.par logfile=impdp.log\n \nExport: Release 12.2.0.1.0 - Production on Sat Apr 22 22:20:22 2017\n \nCopyright (c) 1982, 2016, Oracle and\/or its affiliates.  All rights reserved.\n \nConnected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n22-APR-17 22:20:29.671: Starting \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\":  system\/********@PDB01 parfile=impdp.par logfile=impdp.log\n22-APR-17 22:20:35.505: Processing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\n22-APR-17 22:20:36.032: Processing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\n22-APR-17 22:20:36.407: Processing object type SCHEMA_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS\n22-APR-17 22:20:43.586: Processing object type SCHEMA_EXPORT\/STATISTICS\/MARKER\n22-APR-17 22:20:44.126: Processing object type SCHEMA_EXPORT\/USER\n22-APR-17 22:20:44.199: Processing object type SCHEMA_EXPORT\/SYSTEM_GRANT\n22-APR-17 22:20:44.243: Processing object type SCHEMA_EXPORT\/ROLE_GRANT\n22-APR-17 22:20:44.296: Processing object type SCHEMA_EXPORT\/DEFAULT_ROLE\n22-APR-17 22:20:44.760: Processing object type SCHEMA_EXPORT\/PRE_SCHEMA\/PROCACT_SCHEMA\n22-APR-17 22:20:53.706: Processing object type SCHEMA_EXPORT\/TABLE\/TABLE\n22-APR-17 22:20:59.699: Processing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/CONSTRAINT\n22-APR-17 22:21:00.712: Processing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/REF_CONSTRAINT\n22-APR-17 22:21:03.494: . . exported \"SCOTT\".\"DEMO\"                              8.789 KB      14 rows\n22-APR-17 22:21:03.651: . . exported \"SCOTT\".\"EMP\"                               8.781 KB      14 rows\n22-APR-17 22:21:03.652: . . exported \"SCOTT\".\"DEPT\"                              6.031 KB       4 rows\n22-APR-17 22:21:03.654: . . exported \"SCOTT\".\"SALGRADE\"                          5.960 KB       5 rows\n22-APR-17 22:21:03.656: . . exported \"SCOTT\".\"BONUS\"                                 0 KB       0 rows\n22-APR-17 22:21:04.532: Master table \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\" successfully loaded\/unloaded\n22-APR-17 22:21:04.558: ******************************************************************************\n22-APR-17 22:21:04.559: Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:\n22-APR-17 22:21:04.569:   \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/rdbms\/log\/46EA7EF707457B4FE0531416A8C027F2\/SCOTT_20170422.01.dmp\n22-APR-17 22:21:04.622: Job \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\" successfully completed at Sat Apr 22 22:21:04 2017 elapsed 0 00:00:41\n<\/code><\/pre>\n
You will always appreciate finding timestamps in the log file. But remember that your import\/export is processed by multiple workers and it is difficult to estimate duration between the different lines. I explained this in https:\/\/www.dbi-services.com\/blog\/datapump-processing-object-type-misleading-messages\/<\/a><\/p>\n
DUMPFILE<\/h3>\n
You can see that my DUMPFILE contains also the timestamp in the file name. This is possible in 12.2  with the %T substitution variable. Here was my PARFILE where DUMPFILE mentions %U (in addition to %U if there are multiple files):<\/p>\n
[oracle@vmreforanf12c01 tmp]$ cat impdp.par\nschemas=SCOTT\nlogtime=all\ndumpfile=SCOTT_%T.%U.dmp\nreuse_dumpfiles=yes\nfilesize=1M<\/code><\/pre>\n
PARFILE parameters<\/h3>\n
I don’t usually use a PARFILE and prefer to pass all parameters on the command line, even if this requires escaping a lot of quotes, because I like to ship the log file with the DUMPFILE. And before 12.2 the LOGFILE mentions only the parameters passed on command line. In 12.2 the PARFILE parameters are mentioned into the LOGFILE (but not to the screen):<\/p>\n
\n;;;\nExport: Release 12.2.0.1.0 - Production on Sat Apr 22 22:20:22 2017\n \nCopyright (c) 1982, 2016, Oracle and\/or its affiliates.  All rights reserved.\n;;;\nConnected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n22-APR-17 22:20:24.899: ;;; **************************************************************************\n22-APR-17 22:20:24.901: ;;; Parfile values:\n22-APR-17 22:20:24.903: ;;;  parfile:  filesize=1M\n22-APR-17 22:20:24.905: ;;;  parfile:  reuse_dumpfiles=Y\n22-APR-17 22:20:24.907: ;;;  parfile:  dumpfile=SCOTT_%T.%U.dmp\n22-APR-17 22:20:24.909: ;;;  parfile:  logtime=all\n22-APR-17 22:20:24.911: ;;;  parfile:  schemas=SCOTT\n22-APR-17 22:20:24.913: ;;; **************************************************************************\n22-APR-17 22:20:29.654: Starting \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\":  system\/********@PDB01 parfile=impdp.par logfile=impdp.log\n22-APR-17 22:20:35.469: Processing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\n22-APR-17 22:20:36.032: Processing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\n22-APR-17 22:20:36.407: Processing object type SCHEMA_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS\n22-APR-17 22:20:43.535: Processing object type SCHEMA_EXPORT\/STATISTICS\/MARKER\n22-APR-17 22:20:44.126: Processing object type SCHEMA_EXPORT\/USER\n22-APR-17 22:20:44.199: Processing object type SCHEMA_EXPORT\/SYSTEM_GRANT\n22-APR-17 22:20:44.243: Processing object type SCHEMA_EXPORT\/ROLE_GRANT\n22-APR-17 22:20:44.296: Processing object type SCHEMA_EXPORT\/DEFAULT_ROLE\n22-APR-17 22:20:44.760: Processing object type SCHEMA_EXPORT\/PRE_SCHEMA\/PROCACT_SCHEMA\n22-APR-17 22:20:53.620: Processing object type SCHEMA_EXPORT\/TABLE\/TABLE\n22-APR-17 22:20:59.699: Processing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/CONSTRAINT\n22-APR-17 22:21:00.712: Processing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/REF_CONSTRAINT\n22-APR-17 22:21:03.494: . . exported \"SCOTT\".\"DEMO\"                              8.789 KB      14 rows\n22-APR-17 22:21:03.651: . . exported \"SCOTT\".\"EMP\"                               8.781 KB      14 rows\n22-APR-17 22:21:03.652: . . exported \"SCOTT\".\"DEPT\"                              6.031 KB       4 rows\n22-APR-17 22:21:03.654: . . exported \"SCOTT\".\"SALGRADE\"                          5.960 KB       5 rows\n22-APR-17 22:21:03.656: . . exported \"SCOTT\".\"BONUS\"                                 0 KB       0 rows\n22-APR-17 22:21:04.532: Master table \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\" successfully loaded\/unloaded\n22-APR-17 22:21:04.558: ******************************************************************************\n22-APR-17 22:21:04.559: Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:\n22-APR-17 22:21:04.569:   \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/rdbms\/log\/46EA7EF707457B4FE0531416A8C027F2\/SCOTT_20170422.01.dmp\n22-APR-17 22:21:04.621: Job \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\" successfully completed at Sat Apr 22 22:21:04 2017 elapsed 0 00:00:41\n<\/code><\/pre>\n
Now the LOGFILE shows all export information. Only the password is hidden.<\/p>\n
DATA_PUMP_DIR<\/h3>\n
In 12.1 multitenant, you cannot use the default DATA_PUMP_DIR. It is there, but you just cannot use it implicitly or explicitly. With my PARFILE above when DIRECTORY is not mentioned I would have the following error:<\/p>\n
\nORA-39002: invalid operation\nORA-39070: Unable to open the log file.\nORA-39087: directory name DATA_PUMP_DIR is invalid\n<\/code><\/pre>\n
This means that there is no default possible and we need to mention DIRECTORY.<\/p>\n
But in 12.2 it worked, going to \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/rdbms\/log\/46EA7EF707457B4FE0531416A8C027F2\/ which is the default DATA_PUMP_DIR:<\/p>\n
\nSYSTEM@PDB01 SQL> select * from dba_directories;\n \nOWNER  DIRECTORY_NAME          DIRECTORY_PATH                                                                      ORIGIN_CON_ID\n-----  --------------          --------------                                                                      -------------\nSYS    TSPITR_DIROBJ_DPDIR     \/u90\/tmp_data_restore                                                               3\nSYS    PREUPGRADE_DIR          \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/rdbms\/admin                                 1\nSYS    XMLDIR                  \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/rdbms\/xml                                   1\nSYS    ORA_DBMS_FCP_LOGDIR     \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/cfgtoollogs                                 1\nSYS    ORA_DBMS_FCP_ADMINDIR   \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/rdbms\/admin                                 1\nSYS    ORACLE_OCM_CONFIG_DIR   \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/ccr\/state                                   1\nSYS    ORACLE_OCM_CONFIG_DIR2  \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/ccr\/state                                   1\nSYS    XSDDIR                  \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/rdbms\/xml\/schema                            1\nSYS    DATA_PUMP_DIR           \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/rdbms\/log\/46EA7EF707457B4FE0531416A8C027F2  1\nSYS    OPATCH_INST_DIR         \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/OPatch                                      1\nSYS    OPATCH_SCRIPT_DIR       \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/QOpatch                                     1\nSYS    OPATCH_LOG_DIR          \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/QOpatch                                     1\nSYS    ORACLE_BASE             \/                                                                                   1\nSYS    ORACLE_HOME             \/                                                                                   1\n<\/code><\/pre>\n
Of course, don’t leave it under ORACLE_HOME which is on a filesystem for binaries where you don’t want to put variable size files. But it is good to have a default.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . Data Pump is a powerful way to save data or metadata, move it, migrate, etc. Here is an example showing few new features in 12cR1 and 12cR2.<\/p>\n","protected":false},"author":27,"featured_media":9976,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[984,220,240,64,96,209,66,223],"type_dbi":[],"class_list":["post-9975","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-1z0-074","tag-cdb","tag-data-pump","tag-multitenant","tag-oracle","tag-oracle-12c","tag-pdb","tag-pluggable-databases"],"acf":[],"yoast_head":"\nData Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c - dbi Blog<\/title>\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\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . Data Pump is a powerful way to save data or metadata, move it, migrate, etc. Here is an example showing few new features in 12cR1 and 12cR2.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-22T19:28:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDataPump122.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1325\" \/>\n\t<meta property=\"og:image:height\" content=\"451\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\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\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c\",\"datePublished\":\"2017-04-22T19:28:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/\"},\"wordCount\":392,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDataPump122.png\",\"keywords\":[\"1z0-074\",\"CDB\",\"Data pump\",\"multitenant\",\"Oracle\",\"Oracle 12c\",\"PDB\",\"Pluggable Databases\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/\",\"name\":\"Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDataPump122.png\",\"datePublished\":\"2017-04-22T19:28:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDataPump122.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDataPump122.png\",\"width\":1325,\"height\":451},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c\"}]},{\"@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\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c - dbi Blog","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\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/","og_locale":"en_US","og_type":"article","og_title":"Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c","og_description":"By Franck Pachot . Data Pump is a powerful way to save data or metadata, move it, migrate, etc. Here is an example showing few new features in 12cR1 and 12cR2.","og_url":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/","og_site_name":"dbi Blog","article_published_time":"2017-04-22T19:28:52+00:00","og_image":[{"width":1325,"height":451,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDataPump122.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c","datePublished":"2017-04-22T19:28:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/"},"wordCount":392,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDataPump122.png","keywords":["1z0-074","CDB","Data pump","multitenant","Oracle","Oracle 12c","PDB","Pluggable Databases"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/","url":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/","name":"Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDataPump122.png","datePublished":"2017-04-22T19:28:52+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDataPump122.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDataPump122.png","width":1325,"height":451},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/data-pump-logtime-dumpfile-parfile-data_pump_dir-in-12c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c"}]},{"@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\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9975","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\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9975"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9975\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/9976"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9975"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}