{"id":11945,"date":"2023-11-02T06:57:28","date_gmt":"2023-11-02T05:57:28","guid":{"rendered":"https:\/\/roglacup.com\/klaus62\/?p=11945"},"modified":"2023-11-10T10:28:34","modified_gmt":"2023-11-10T09:28:34","slug":"oracle-data-pump","status":"publish","type":"post","link":"https:\/\/roglacup.com\/klaus62\/2023\/11\/02\/oracle-data-pump\/","title":{"rendered":"Oracle Data Pump"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\"><\/h1>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"SUTIL-GUID-17FAE261-0972-4220-A2E4-44D479F519D4\">Overview of Oracle Data Pump<\/h2>\n\n\n\n<p>Oracle Data Pump technology enables very high-speed movement of data and metadata from one database to another.<\/p>\n\n\n\n<p>An understanding of the following topics can help you to successfully use Oracle Data Pump to its fullest advantage:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-47B26B0B-3C95-4182-ACDF-2EEDD577FC9E\">Oracle Data Pump Components<\/a><br>Oracle Data Pump is made up of three distinct components: Command-line clients,&nbsp;<code>expdp<\/code>&nbsp;and&nbsp;<code>impdp<\/code>; the&nbsp;<code>DBMS_DATAPUMP<\/code>&nbsp;PL\/SQL package (also known as the Data Pump API); and the&nbsp;<code>DBMS_METADATA<\/code>&nbsp;PL\/SQL package (also known as the Metadata API).<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-3F418F02-5FE2-455A-B5AD-C1910DB3B5E0\">How Does Oracle Data Pump Move Data?<\/a><br>There are several Oracle Data Pump methods that you can use to move data in and out of databases. You can select the method that best fits your use case.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-45B17B65-20F2-4128-9A39-B1B0F5E323BB\">Using Oracle Data Pump With CDBs<\/a><br>Oracle Data Pump can migrate all, or portions of, a database from a non-CDB into a PDB, between PDBs within the same or different CDBs, and from a PDB into a non-CDB.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-D67B76AF-C10A-4BFA-BC56-BFE03482957A\">Cloud Premigration Advisor Tool<\/a><br>The Cloud Premigration Advisor tool can assist you to migrate a database to the Oracle Cloud.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-8B6975D3-3BEC-4584-B416-280125EEC57E\">Required Roles for Oracle Data Pump Export and Import Operations<\/a><br>The roles&nbsp;<code>DATAPUMP_EXP_FULL_DATABASE<\/code>&nbsp;and&nbsp;<code>DATAPUMP_IMP_FULL_DATABASE<\/code>&nbsp;are required for many Export and Import operations.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-6BDC1CC8-8596-402D-B016-602985B97AB6\">What Happens During the Processing of an Oracle Data Pump Job?<\/a><br>Oracle Data Pump jobs use a Data Pump control job table, a Data Pump control job process, and worker processes to perform the work and keep track of progress.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-E365D74E-12CD-495C-BA23-5A55F679C7E7\">How to Monitor Status of Oracle Data Pump Jobs<\/a><br>The Oracle Data Pump Export and Import client utilities can attach to a job in either logging mode or interactive-command mode.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-A4C5E6C1-28DE-45AF-B90C-B7FEEFF62069\">How to Monitor the Progress of Executing Jobs<\/a><br>To monitor table data transfers, you can use the&nbsp;<code>V$SESSION_LONGOPS<\/code>&nbsp;dynamic performance view to monitor Oracle Data Pump jobs.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-FE7E746D-A343-463E-A4E2-A6AD1349FE4B\">File Allocation with Oracle Data Pump<\/a><br>You can modify how Oracle Data Pump allocates and handles files by using commands in interactive mode.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-BAA3B679-A758-4D55-9820-432D9EB83C68\">Exporting and Importing Between Different Oracle Database Releases<\/a><br>You can use Oracle Data Pump to migrate all or any portion of an Oracle Database between different releases of the database software.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-0DA3BECF-737A-4218-A486-11BA204C3966\">Exporting and Importing Blockchain Tables with Oracle Data Pump<\/a><br>To export or import blockchain tables, review these minimum requirements, restrictions, and guidelines.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-9030BC32-193B-4455-8DBB-4271DD44FA7A\">Managing SecureFiles Large Object Exports with Oracle Data Pump<\/a><br>Exports of SecureFiles large objects (LOBs) are affected by the content type, the&nbsp;<code>VERSION<\/code>&nbsp;parameter, and other variables.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-34D0DEE7-3530-42DC-BE01-C2588CC73CE5\">Oracle Data Pump Process Exit Codes<\/a><br>To check the status of your Oracle Data Pump export and import operations, review the process exit codes in the log file.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-4443B80B-0446-4010-B8CA-2524659516BC\">How to Monitor Oracle Data Pump Jobs with Unified Auditing<\/a><br>To monitor and record specific user database actions, perform auditing on Data Pump jobs with unified auditing.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-B437B7AE-E36F-422B-ADFF-4ED87F9C4B1B\">Encrypted Data Security Warnings for Oracle Data Pump Operations<\/a><br>Oracle Data Pump warns you when encrypted data is exported as unencrypted data.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-7EE60BAB-0D3D-46EB-8E11-4FDDA68EF14E\">How Does Oracle Data Pump Handle Timestamp Data?<\/a><br>Learn about factors that can affect successful completion of export and import jobs that involve the timestamp data types&nbsp;<code>TIMESTAMP WITH TIMEZONE<\/code>&nbsp;and&nbsp;<code>TIMESTAMP WITH LOCAL TIMEZONE<\/code>.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-72F01BF0-61F5-4775-8C7B-4E227F244866\">Character Set and Globalization Support Considerations<\/a><br>Learn about Globalization support of Oracle Data Pump Export and Import using character set conversion of user data, and data definition language (DDL).<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-B1A6BBA2-0269-48CC-8A0E-8E3955A231C0\">Oracle Data Pump Behavior with Data-Bound Collation<\/a><br>Oracle Data Pump supports data-bound collation (DBC).<\/li>\n<\/ul>\n\n\n\n<p>Posted from: <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-47B26B0B-3C95-4182-ACDF-2EEDD577FC9E\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-47B26B0B-3C95-4182-ACDF-2EEDD577FC9E<\/a><\/p>\n\n\n\n<p>You execute this command:<br><img decoding=\"async\" src=\"https:\/\/www.examtopics.com\/assets\/media\/exam-media\/04352\/0001800001.png\"><br>During the export operation, you detach from the job by using CTRL+C and then execute this command:<br><br>Export&gt; STOP_JOB=immediate &#8211;<br>Are you sure you wish to stop the job ([yes]\/no): yes<br>Which two statements are true about the job? (Choose two.)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>A.\u00a0You can no longer monitor it<\/strong><\/li>\n\n\n\n<li>B.&nbsp;You can reattach to it and monitor it<\/li>\n\n\n\n<li>C.&nbsp;It is paused and can be resumed<\/li>\n\n\n\n<li>D.&nbsp;It continues to run in the background<\/li>\n\n\n\n<li><strong>E.\u00a0It terminates<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Primer:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"385\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-2-1024x385.png\" alt=\"\" class=\"wp-image-11951\" srcset=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-2-1024x385.png 1024w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-2-300x113.png 300w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-2-768x289.png 768w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/11\/image-2.png 1224w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Overview of Oracle Data Pump Oracle Data Pump technology enables very high-speed movement of data and metadata from one database to another. An understanding of the following topics can help you to successfully use Oracle Data Pump to its fullest advantage: Posted from: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/sutil\/oracle-data-pump-overview.html#GUID-47B26B0B-3C95-4182-ACDF-2EEDD577FC9E You execute this command:During the export operation, you detach from the&hellip;&nbsp;<a href=\"https:\/\/roglacup.com\/klaus62\/2023\/11\/02\/oracle-data-pump\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Oracle Data Pump<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":11949,"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":"","footnotes":""},"categories":[1299],"tags":[1329],"class_list":["post-11945","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1z0-082","tag-oracle-data-pump"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/11945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/comments?post=11945"}],"version-history":[{"count":5,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/11945\/revisions"}],"predecessor-version":[{"id":11956,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/11945\/revisions\/11956"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media\/11949"}],"wp:attachment":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media?parent=11945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/categories?post=11945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/tags?post=11945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}