{"id":10246,"date":"2017-06-13T08:58:02","date_gmt":"2017-06-13T06:58:02","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/"},"modified":"2017-06-13T08:58:02","modified_gmt":"2017-06-13T06:58:02","slug":"oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/","title":{"rendered":"Oracle 12.2 – How to run a consistent full database export with dbms_datapump and parallel degree of 8"},"content":{"rendered":"

By William Sescu<\/h2>\n

Nowadays, since the cloud is becoming more and more important, the PL\/SQL API’s become more and more important too. Fortunately, Oracle has quite a lot of them. E.g. How do you run a Data Pump export if you have no ssh connectivity to the server? You could use the old exp tool, which is still available even with Oracle 12.2, or you can use DBMS_DATAPUMP. The Data Pump API is quite good documented in the following books:<\/p>\n

Database Utilities
\nhttps:\/\/docs.oracle.com\/database\/122\/SUTIL\/using-ORACLE_DATAPUMP-api.htm#SUTIL600<\/a><\/p>\n

Database PL\/SQL Packages and Types Reference
\nhttps:\/\/docs.oracle.com\/database\/122\/ARPLS\/DBMS_DATAPUMP.htm#ARPLS66050<\/a><\/p>\n

But you might find some useful stuff in the $ORACLE_HOME\/rdbms\/admin\/dbmsdp.sql as well.<\/p>\n

In this little how to, I would like to show how to create a consistent full database export (parallel 8) with
\nthe Data Pump API.<\/p>\n

There are a only a few steps involved to get the job done.<\/p>\n

1. Create a directory and grant the necessary privileges to user HR
\n2. Grant the DATAPUMP_EXP_FULL_DATABASE role to user HR
\n3. Execute the Data Pump job with DBMS_DATAPUMP
\n4. Monitor the Data Pump job
\n5. Optionally, do some cleanup<\/p>\n

 <\/p>\n

1.) Let’s start with the directory.<\/p>\n

SQL> CREATE OR REPLACE DIRECTORY DATAPUMP_DIR AS '\/u01\/app\/oracle\/admin\/DBIT122\/dpdump';\n\nDirectory created.\n\nSQL> GRANT READ, WRITE ON DIRECTORY DATAPUMP_DIR TO HR;\n\nGrant succeeded.<\/pre>\n
2.) Now we grant the DATAPUMP_EXP_FULL_DATABASE role to the HR user<\/p>\n
SQL> GRANT DATAPUMP_EXP_FULL_DATABASE TO HR;\n\nGrant succeeded.<\/pre>\n
Please be aware that the DATAPUMP_EXP_FULL_DATABASE role affects only export operations. It allows the user HR to run these operations:<\/p>\n
    \n
  • Perform the operation outside of the scope of their schema<\/li>\n
  • Monitor jobs that were initiated by another user<\/li>\n
  • Export objects (for example, TABLESPACE definitions) that unprivileged users cannot reference<\/li>\n<\/ul>\n
    Without this role, you might run into the following error when doing a full export:<\/p>\n
    ERROR at line 1:\nORA-31631: privileges are required\nORA-06512: at \"SYS.DBMS_SYS_ERROR\", line 79\nORA-06512: at \"SYS.DBMS_DATAPUMP\", line 4932\nORA-06512: at \"SYS.DBMS_DATAPUMP\", line 6844\nORA-06512: at line 6<\/pre>\n
     <\/p>\n
    3.) Now it’s time to run the Data Pump job. Be aware, that for a consistent export, you need to specify the FLASHBACK_TIME or FLASHBACK_SCN. In my case, I use the FLASHBACK_TIME and set it to the current SYSTIMESTAMP.<\/p>\n
    Ok. Let’s give it a try.<\/p>\n
    SQL> connect hr\/hr\nConnected.\n\nSQL> @exp_datapump.sql\nSQL> declare\n  2        l_datapump_handle    NUMBER;  -- Data Pump job handle\n  3        l_datapump_dir       VARCHAR2(20) := 'DATAPUMP_DIR';  -- Data Pump Directory\n  4        l_status             varchar2(200); -- Data Pump Status\n  5    BEGIN\n  6        l_datapump_handle := dbms_datapump.open(operation => 'EXPORT',  -- operation = EXPORT, IMPORT, SQL_FILE\n  7                                                job_mode =>'FULL',  -- job_mode = FULL, SCHEMA, TABLE, TABLESPACE, TRANSPORTABLE\n  8                                                job_name => 'DBIT122 EXPORT JOB RUN 003',  -- job_name = NULL (default) or: job name (max 30 chars)\n  9                                                version => '12'); -- version = COMPATIBLE (default), LATEST (dbversion), a value (11.0.0 or 12)\n 10\n 11            dbms_datapump.add_file(handle    => l_datapump_handle,\n 12                               filename  => 'exp_DBIT122_%U.dmp',\n 13                               directory => l_datapump_dir);\n 14\n 15        dbms_datapump.add_file(handle    => l_datapump_handle,\n 16                               filename  => 'exp_DBIT122.log' ,\n 17                               directory => l_datapump_dir ,\n 18                               filetype  => DBMS_DATAPUMP.ku$_file_type_log_file);\n 19\n 20        dbms_datapump.set_parameter(l_datapump_handle,'CLIENT_COMMAND','Full Consistent Data Pump Export of DBIT122 with PARALLEL 8');\n 21\n 22            dbms_datapump.set_parameter(l_datapump_handle,'FLASHBACK_TIME','SYSTIMESTAMP');\n 23\n 24        dbms_datapump.set_parallel(l_datapump_handle,8);\n 25\n 26        dbms_datapump.start_job(handle => l_datapump_handle);\n 27\n 28        dbms_datapump.wait_for_job(handle => l_datapump_handle,\n 29                                   job_state => l_status );\n 30\n 31        dbms_output.put_line( l_status );\n 32\n 33        end;\n 34  \/\n\nPL\/SQL procedure successfully completed.\n\nSQL><\/pre>\n
    4.) In another window, you might want to monitor the status of your export job.<\/p>\n
    SQL> r\n  1  select owner_name, job_name, rtrim(operation) \"OPERATION\",\n  2         rtrim(job_mode) \"JOB_MODE\", state, attached_sessions\n  3    from dba_datapump_jobs\n  4   where job_name not like 'BIN$%'\n  5*  order by 1,2\n\nOWNER_NAME JOB_NAME                         OPERATION    JOB_MODE     STATE        ATTACHED_SESSIONS\n---------- -------------------------------- ------------ ------------ ------------ -----------------\nHR         DBIT122 EXPORT JOB RUN 003       EXPORT       FULL         EXECUTING                    1<\/pre>\n
    Cool. If the job finished successfully, you will see 8 dump files, because we specified exp_DBIT122_%U.dmp as the file name, and one log file.<\/p>\n
    oracle@dbidg01:\/u01\/app\/oracle\/admin\/DBIT122\/dpdump\/ [DBIT122] ls -l\ntotal 4752\n-rw-r----- 1 oracle oinstall  630784 Jun 13 10:29 exp_DBIT122_01.dmp\n-rw-r----- 1 oracle oinstall 3321856 Jun 13 10:29 exp_DBIT122_02.dmp\n-rw-r----- 1 oracle oinstall  180224 Jun 13 10:29 exp_DBIT122_03.dmp\n-rw-r----- 1 oracle oinstall   57344 Jun 13 10:29 exp_DBIT122_04.dmp\n-rw-r----- 1 oracle oinstall  430080 Jun 13 10:28 exp_DBIT122_05.dmp\n-rw-r----- 1 oracle oinstall   20480 Jun 13 10:29 exp_DBIT122_06.dmp\n-rw-r----- 1 oracle oinstall   28672 Jun 13 10:29 exp_DBIT122_07.dmp\n-rw-r----- 1 oracle oinstall  176128 Jun 13 10:28 exp_DBIT122_08.dmp\n-rw-r--r-- 1 oracle oinstall   11966 Jun 13 10:29 exp_DBIT122.log<\/pre>\n
    5.) Finally, you might want to do some cleanup, in case you don’t need the dump files and the log files anymore. Or you start your export job with the REUSE_DUMPFILES=YES option. This option overwrites the destination dump files if they exist. In case you want to do the cleanup manually, you can use the ULT_FILE package.<\/p>\n
    SQL> exec utl_file.fremove( 'DATAPUMP_DIR', 'exp_DBIT122.log' );\n\nPL\/SQL procedure successfully completed.\n\nSQL> exec utl_file.fremove( 'DATAPUMP_DIR', 'exp_DBIT122_01.dmp' );\n\nPL\/SQL procedure successfully completed.\n\nSQL> exec utl_file.fremove( 'DATAPUMP_DIR', 'exp_DBIT122_02.dmp' );\n\nPL\/SQL procedure successfully completed.\n\nSQL> exec utl_file.fremove( 'DATAPUMP_DIR', 'exp_DBIT122_03.dmp' );\n\nPL\/SQL procedure successfully completed.\n\nSQL> exec utl_file.fremove( 'DATAPUMP_DIR', 'exp_DBIT122_04.dmp' );\n\nPL\/SQL procedure successfully completed.\n\nSQL> exec utl_file.fremove( 'DATAPUMP_DIR', 'exp_DBIT122_05.dmp' );\n\nPL\/SQL procedure successfully completed.\n\nSQL> exec utl_file.fremove( 'DATAPUMP_DIR', 'exp_DBIT122_06.dmp' );\n\nPL\/SQL procedure successfully completed.\n\nSQL> exec utl_file.fremove( 'DATAPUMP_DIR', 'exp_DBIT122_07.dmp' );\n\nPL\/SQL procedure successfully completed.\n\nSQL> exec utl_file.fremove( 'DATAPUMP_DIR', 'exp_DBIT122_08.dmp' );\n\nPL\/SQL procedure successfully completed.\n\nSQL><\/pre>\n
    Conclusion<\/h3>\n
    The PL\/SQL API’s becomes more and more important, especially in cloud environments. It makes quite a lot of sense, from my point of view, to look closer into the one or the other. Especially the DBMS_DATAPUMP is an important one for moving data around.<\/p>\n
     <\/p>\n
     <\/p>\n","protected":false},"excerpt":{"rendered":"
    By William Sescu Nowadays, since the cloud is becoming more and more important, the PL\/SQL API’s become more and more important too. Fortunately, Oracle has quite a lot of them. E.g. How do you run a Data Pump export if you have no ssh connectivity to the server? You could use the old exp tool, […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[988],"type_dbi":[],"class_list":["post-10246","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-oracle-12-2"],"acf":[],"yoast_head":"\nOracle 12.2 - How to run a consistent full database export with dbms_datapump and parallel degree of 8 - 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\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 12.2 - How to run a consistent full database export with dbms_datapump and parallel degree of 8\" \/>\n<meta property=\"og:description\" content=\"By William Sescu Nowadays, since the cloud is becoming more and more important, the PL\/SQL API’s become more and more important too. Fortunately, Oracle has quite a lot of them. E.g. How do you run a Data Pump export if you have no ssh connectivity to the server? You could use the old exp tool, […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-13T06:58:02+00:00\" \/>\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\\\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 12.2 – How to run a consistent full database export with dbms_datapump and parallel degree of 8\",\"datePublished\":\"2017-06-13T06:58:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\\\/\"},\"wordCount\":508,\"commentCount\":0,\"keywords\":[\"Oracle 12.2\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\\\/\",\"name\":\"Oracle 12.2 - How to run a consistent full database export with dbms_datapump and parallel degree of 8 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2017-06-13T06:58:02+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 12.2 – How to run a consistent full database export with dbms_datapump and parallel degree of 8\"}]},{\"@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":"Oracle 12.2 - How to run a consistent full database export with dbms_datapump and parallel degree of 8 - 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\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 12.2 - How to run a consistent full database export with dbms_datapump and parallel degree of 8","og_description":"By William Sescu Nowadays, since the cloud is becoming more and more important, the PL\/SQL API’s become more and more important too. Fortunately, Oracle has quite a lot of them. E.g. How do you run a Data Pump export if you have no ssh connectivity to the server? You could use the old exp tool, […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/","og_site_name":"dbi Blog","article_published_time":"2017-06-13T06:58:02+00:00","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\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 12.2 – How to run a consistent full database export with dbms_datapump and parallel degree of 8","datePublished":"2017-06-13T06:58:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/"},"wordCount":508,"commentCount":0,"keywords":["Oracle 12.2"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/","name":"Oracle 12.2 - How to run a consistent full database export with dbms_datapump and parallel degree of 8 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-06-13T06:58:02+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-how-to-run-a-consistent-full-database-export-with-dbms_datapump-and-parallel-degree-of-8\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 12.2 – How to run a consistent full database export with dbms_datapump and parallel degree of 8"}]},{"@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\/10246","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=10246"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10246\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10246"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}