{"id":1568,"date":"2015-02-23T10:38:16","date_gmt":"2015-02-23T08:38:16","guid":{"rendered":"https:\/\/zoharelkayam.me\/?p=1568"},"modified":"2015-02-23T10:41:55","modified_gmt":"2015-02-23T08:41:55","slug":"manage-datapump-jobs","status":"publish","type":"post","link":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/","title":{"rendered":"\u05e0\u05d9\u05d4\u05d5\u05dc \u05d2'\u05d5\u05d1\u05d9\u05dd \u05e9\u05dc datapump"},"content":{"rendered":"<p>\u05d9\u05e9 \u05dc\u05d9 \u05dc\u05e7\u05d5\u05d7 \u05e9\u05de\u05e8\u05d9\u05e5 \u05e1\u05e7\u05e8\u05d9\u05e4\u05d8\u05d9\u05dd \u05e9\u05de\u05d2\u05d1\u05d9\u05dd \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05de\u05e8\u05db\u05d6\u05d9\u05d5\u05ea \u05d1\u05de\u05e2\u05e8\u05db\u05ea \u05e9\u05dc\u05d5 \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea \u05e9\u05d9\u05de\u05e9 \u05d1-data pump. \u05d6\u05d4 \u05e4\u05ea\u05e8\u05d5\u05df \u05dc\u05d0 \u05e8\u05e2 \u05d1\u05db\u05dc\u05dc \u05db\u05d3\u05d9 \u05dc\u05e9\u05de\u05d5\u05e8 \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05dc\u05e6\u05e8\u05db\u05d9 \u05e9\u05d7\u05d6\u05d5\u05e8 \u05de\u05d4\u05d9\u05e8 \u05d0\u05d5 \u05dc\u05d4\u05e2\u05d1\u05e8\u05d4 \u05dc\u05e1\u05d1\u05d9\u05d1\u05d5\u05ea \u05d4\u05e4\u05d9\u05ea\u05d5\u05d7. \u05d4\u05d1\u05e2\u05d9\u05d4 \u05d4\u05d9\u05d0 \u05e9\u05d4\u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05e9\u05d0\u05d5\u05ea\u05df \u05de\u05d2\u05d1\u05d4 \u05d4\u05dc\u05e7\u05d5\u05d7 \u05d4\u05df \u05d2\u05d3\u05d5\u05dc\u05d5\u05ea \u05de\u05d0\u05d5\u05d3 \u05d5\u05d4-export \u05dc\u05d5\u05e7\u05d7 \u05d4\u05de\u05d5\u05df \u05d6\u05de\u05df (\u05db\u05de\u05d4 \u05e9\u05e2\u05d5\u05ea \u05d8\u05d5\u05d1\u05d5\u05ea).<\/p>\n<p>\u05dc\u05e4\u05e2\u05de\u05d9\u05dd, \u05e0\u05d5\u05e6\u05e8 \u05dc\u05e0\u05d5 \u05e6\u05d5\u05e8\u05da \u05dc&quot;\u05d4\u05e6\u05d9\u05e5&quot; \u05dc\u05ea\u05d5\u05da \u05d4\u05ea\u05d4\u05dc\u05d9\u05da \u05e9\u05dc \u05d4-export \u05d5\u05dc\u05e8\u05d0\u05d5\u05ea \u05de\u05d4 \u05e7\u05d5\u05e8\u05d4 \u05d0\u05d9\u05ea\u05d5 \u2013 \u05d1\u05d0\u05d9\u05d6\u05d4 \u05de\u05e6\u05d1 \u05d4\u05d5\u05d0 \u05e0\u05de\u05e6\u05d0, \u05d0\u05d9\u05d6\u05d4 \u05d8\u05d1\u05dc\u05d4 \u05d4\u05d5\u05d0 \u05de\u05d9\u05d9\u05e6\u05d0 \u05d1\u05e0\u05e7\u05d5\u05d3\u05d4 \u05de\u05e1\u05d5\u05d9\u05d9\u05de\u05ea \u05d5\u05e2\u05d5\u05d3 \u05db\u05de\u05d4 \u05d6\u05de\u05df \u05e0\u05e9\u05d0\u05e8 \u05dc\u05ea\u05d4\u05dc\u05d9\u05da. \u05e2\u05e7\u05e8\u05d5\u05e0\u05d9\u05ea, \u05d4\u05e1\u05e7\u05e8\u05d9\u05e4\u05d8 \u05e9\u05dc\u05e0\u05d5 \u05e8\u05e5 \u05d1\u05e8\u05e7\u05e2 (\u05de\u05ea\u05d5\u05da cron) \u05d5\u05d4\u05d5\u05d0 \u05d1\u05d0\u05de\u05ea \u05e9\u05d5\u05de\u05e8 \u05d0\u05ea \u05d4-output \u05dc\u05ea\u05d5\u05da \u05e7\u05d5\u05d1\u05e5 log \u05d0\u05d1\u05dc \u05d6\u05d4 \u05dc\u05d0 \u05de\u05e1\u05e4\u05d9\u05e7 \u05db\u05d3\u05d9 \u05dc\u05e2\u05e0\u05d5\u05ea \u05e2\u05dc \u05db\u05dc \u05d4\u05e9\u05d0\u05dc\u05d5\u05ea \u05e9\u05d9\u05e9 \u05dc\u05dc\u05e7\u05d5\u05d7.<\/p>\n<p>\u05e2\u05d5\u05d3 \u05de\u05e7\u05e8\u05d4 \u05e9\u05e2\u05dc\u05d5\u05dc \u05dc\u05d4\u05d9\u05d5\u05d5\u05e6\u05e8 \u05d6\u05d4 export (\u05dc\u05d3\u05d5\u05d2\u05de\u05d4 full) \u05e9\u05d0\u05e0\u05d7\u05e0\u05d5 \u05de\u05d1\u05e6\u05e2\u05d9\u05dd \u05d0\u05d1\u05dc \u05d4\u05d7\u05dc\u05d5\u05df \u05e9\u05e2\u05d1\u05d3\u05e0\u05d5 \u05d1\u05d5 \u05e0\u05e1\u05d2\u05e8 \u05de\u05d0\u05d9\u05d6\u05d5\u05e9\u05d4\u05d9 \u05e1\u05d9\u05d1\u05d4 \u2013 \u05d4\u05e1\u05d9\u05d1\u05d4 \u05d4\u05e0\u05e4\u05d5\u05e6\u05d4 \u05e9\u05dc\u05d9 \u05d4\u05d9\u05d0 ssh \u05e9\u05e0\u05e1\u05d2\u05e8 \u05d1\u05d2\u05dc\u05dc \u05d0\u05d5\u05d1\u05d3\u05df \u05ea\u05e7\u05e9\u05d5\u05e8\u05ea \u05d0\u05d1\u05dc \u05d6\u05d5 \u05d9\u05db\u05d5\u05dc\u05d4 \u05dc\u05d4\u05d9\u05d5\u05ea \u05db\u05dc \u05e1\u05d9\u05d1\u05d4 \u05d0\u05d7\u05e8\u05ea.<\/p>\n<p>\u05d4\u05e9\u05d0\u05dc\u05d4 \u05d4\u05d9\u05d0 \u05de\u05d4 \u05e2\u05d5\u05e9\u05d9\u05dd \u05d1\u05de\u05e7\u05e8\u05d4 \u05d4\u05d6\u05d4 \u05d5\u05d3\u05d5\u05d5\u05e7\u05d0 \u05d4\u05e9\u05d9\u05de\u05d5\u05e9 \u05d1-data pump jobs \u05d4\u05d5\u05e4\u05da \u05d0\u05ea \u05d4\u05e2\u05e0\u05d9\u05d9\u05e0\u05d9\u05dd \u05dc\u05e4\u05e9\u05d5\u05d8\u05d9\u05dd \u05d1\u05de\u05d9\u05d5\u05d7\u05d3.<\/p>\n<p><!--more--><\/p>\n<h2>\u05de\u05e6\u05d9\u05d0\u05ea \u05e9\u05dd \u05d4\u05d2'\u05d5\u05d1 \u05e9\u05e8\u05e5<\/h2>\n<p>\u05db\u05d0\u05e9\u05e8 \u05d0\u05e0\u05d7\u05e0\u05d5 \u05de\u05d1\u05e6\u05e2\u05d9\u05dd \u05d0\u05ea \u05d4\u05e4\u05e7\u05d5\u05d3\u05d4 expdp (\u05d0\u05d5 impdp) \u05d0\u05e0\u05d7\u05e0\u05d5 \u05d1\u05e2\u05e6\u05dd \u05de\u05e9\u05ea\u05de\u05e9\u05d9\u05dd \u05d1\u05de\u05e2\u05d8\u05e4\u05ea \u05e9\u05d0\u05d5\u05de\u05e8\u05ea \u05dc\u05d1\u05e1\u05d9\u05e1 \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05dc\u05d9\u05e6\u05d5\u05e8 \u05d2'\u05d5\u05d1 \u05e9\u05dc scheduler jobs \u05d1\u05ea\u05d5\u05da \u05d1\u05e1\u05d9\u05e1 \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05db\u05d3\u05d9 \u05dc\u05d1\u05e6\u05e2 \u05d0\u05ea \u05d4-export. \u05db\u05d0\u05e9\u05e8 \u05d4\u05d2\u05d9\u05d1\u05d5\u05d9 \u05e9\u05dc\u05e0\u05d5 \u05de\u05ea\u05d7\u05d9\u05dc \u05d4\u05d5\u05d0 \u05e8\u05d5\u05e9\u05dd \u05d1\u05d4\u05ea\u05d7\u05dc\u05ea \u05d4\u05ea\u05d4\u05dc\u05d9\u05da \u05d0\u05ea \u05e9\u05dd \u05d4\u05d2'\u05d5\u05d1 \u05e9\u05d4\u05d5\u05d0 \u05d9\u05e6\u05e8 \u05d5\u05d0\u05e0\u05d7\u05e0\u05d5 \u05d9\u05db\u05d5\u05dc\u05d9\u05dd \u05dc\u05d4\u05e9\u05ea\u05de\u05e9 \u05d1\u05d5 \u05db\u05d3\u05d9 \u05dc\u05d7\u05d6\u05d5\u05e8 \u05d5\u05dc\u05d4\u05ea\u05d7\u05d1\u05e8 \u05dc\u05de\u05de\u05e9\u05e7 \u05d4\u05e0\u05d9\u05d4\u05d5\u05dc \u05e9\u05dc \u05d4\u05d2'\u05d5\u05d1 (\u05d1\u05de\u05e7\u05e8\u05d4 \u05d4\u05d6\u05d4, \u05dc\u05d2'\u05d5\u05d1 \u05e7\u05d5\u05e8\u05d0\u05d9\u05dd SYS_EXPORT_FULL_01). \u05d0\u05dc \u05de\u05de\u05e9\u05e7 \u05d4\u05e0\u05d9\u05d4\u05d5\u05dc \u05d0\u05e4\u05e9\u05e8 \u05d2\u05dd \u05dc\u05d7\u05d6\u05d5\u05e8 \u05d0\u05dd \u05de\u05d1\u05e6\u05e2\u05d9\u05dd ctrl+c \u05d1\u05d6\u05de\u05df \u05d4\u05e8\u05d9\u05e6\u05d4:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n&#x5B;oracle@lnx-oracle66-db11g ~]$ expdp full=y directory=DATA_PUMP_DIR dumpfile=zohar.dmp logfile=zohar.log\r\n\r\nExport: Release 11.2.0.4.0 - Production on Thu Feb 19 11:12:37 2015\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nUsername: zohar\r\nPassword:\r\n\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nStarting &quot;ZOHAR&quot;.&quot;SYS_EXPORT_FULL_01&quot;:  zohar\/******** full=y directory=DATA_PUMP_DIR dumpfile=zohar.dmp logfile=zohar.log\r\n<\/pre>\n<p>\u05d0\u05ea \u05d0\u05d5\u05ea\u05d5 \u05d4\u05e4\u05dc\u05d8 \u05e0\u05d5\u05db\u05dc \u05dc\u05de\u05e6\u05d5\u05d0 \u05d2\u05dd \u05d1\u05e7\u05d5\u05d1\u05e5 \u05d4\u05dc\u05d5\u05d2 \u05e9\u05dc\u05e0\u05d5 (zohar.log) \u05d1\u05de\u05d9\u05d3\u05d4 \u05d5\u05d4\u05d7\u05dc\u05d5\u05df \u05e9\u05dc\u05e0\u05d5 \u05db\u05d1\u05e8 \u05dc\u05d0 \u05de\u05e6\u05d9\u05d2 \u05d0\u05ea \u05d4\u05e4\u05dc\u05d8 \u05e9\u05dc \u05d4\u05e4\u05e7\u05d5\u05d3\u05d4.<\/p>\n<p>\u05d0\u05dd \u05d0\u05d9\u05df \u05dc\u05e0\u05d5 \u05e7\u05d5\u05d1\u05e5 \u05dc\u05d5\u05d2, \u05e0\u05d5\u05db\u05dc \u05dc\u05de\u05e6\u05d5\u05d0 \u05d0\u05ea \u05e9\u05dd \u05d4\u05d2'\u05d5\u05d1 \u05d2\u05dd \u05d1\u05e9\u05dc\u05d9\u05e4\u05d4 \u05de\u05ea\u05d5\u05da \u05d1\u05e1\u05d9\u05e1 \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd:<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSQL&gt; SELECT owner_name, job_name, operation, job_mode, state\r\n  2  FROM dba_datapump_jobs;\r\n\r\nOWNER_NAME                     JOB_NAME                       OPERATION                      JOB_MODE                       STATE\r\n------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------\r\nZOHAR                          SYS_EXPORT_FULL_01             EXPORT                         FULL                           EXECUTING\r\n<\/pre>\n<h2>\u05d4\u05ea\u05d7\u05d1\u05e8\u05d5\u05ea \u05d1\u05d7\u05d6\u05e8\u05d4 \u05dc\u05d2'\u05d5\u05d1 \u05e9\u05e8\u05e5<\/h2>\n<p>\u05e2\u05db\u05e9\u05d9\u05d5 \u05e9\u05d9\u05e9 \u05dc\u05e0\u05d5 \u05d0\u05ea \u05e9\u05dd \u05d4\u05d2'\u05d5\u05d1 \u05e9\u05e8\u05e5, \u05d0\u05e0\u05d7\u05e0\u05d5 \u05d9\u05db\u05d5\u05dc\u05d9\u05dd \u05dc\u05d4\u05ea\u05d7\u05d1\u05e8 \u05d0\u05dc\u05d9\u05d5 \u05d1\u05d7\u05d6\u05e8\u05d4. \u05db\u05d3\u05d9 \u05dc\u05d1\u05e6\u05e2 \u05d0\u05ea \u05d6\u05d4 \u05d0\u05e0\u05d7\u05e0\u05d5 \u05e6\u05e8\u05d9\u05db\u05d9\u05dd \u05dc\u05d4\u05e4\u05e2\u05d9\u05dc \u05de\u05d7\u05d3\u05e9 \u05d0\u05ea \u05d4\u05e4\u05e7\u05d5\u05d3\u05d4 \u05e9\u05dc \u05d4-expdp \u05d5\u05dc\u05d1\u05e6\u05e2 \u05e4\u05e7\u05d5\u05d3\u05ea attach:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n&#x5B;oracle@lnx-oracle66-db11g ~]$ expdp zohar attach=SYS_EXPORT_FULL_01\r\n<\/pre>\n<p>\u05d4\u05e4\u05e7\u05d5\u05d3\u05d4 \u05d4\u05d6\u05d5 \u05ea\u05d7\u05d1\u05e8 \u05d0\u05d5\u05ea\u05e0\u05d5 \u05dc\u05de\u05de\u05e9\u05e7 \u05d4\u05e0\u05d9\u05d4\u05d5\u05dc \u05d5\u05ea\u05d1\u05e6\u05e2 \u05e4\u05e7\u05d5\u05d3\u05d4 \u05e8\u05d0\u05e9\u05d5\u05e0\u05d9\u05ea \u05e9\u05dc \u05e1\u05d8\u05d8\u05d5\u05e1:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n&#x5B;oracle@lnx-oracle66-db11g ~]$ expdp zohar attach=SYS_EXPORT_FULL_01\r\n\r\nExport: Release 11.2.0.4.0 - Production on Thu Feb 19 11:19:20 2015\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\nPassword:\r\n\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nJob: SYS_EXPORT_FULL_01\r\n  Owner: ZOHAR\r\n  Operation: EXPORT\r\n  Creator Privs: TRUE\r\n  GUID: 0F6E661235961287E0530100007FB4DA\r\n  Start Time: Thursday, 19 February, 2015 11:17:03\r\n  Mode: FULL\r\n  Instance: orcldg\r\n  Max Parallelism: 1\r\n  EXPORT Job Parameters:\r\n  Parameter Name      Parameter Value:\r\n     CLIENT_COMMAND        zohar\/******** full=y directory=DATA_PUMP_DIR dumpfile=zohar.dmp logfile=zohar.log\r\n  State: EXECUTING\r\n  Bytes Processed: 0\r\n  Current Parallelism: 1\r\n  Job Error Count: 0\r\n  Dump File: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_11204\/rdbms\/log\/zohar.dmp\r\n    bytes written: 4,096\r\n\r\nWorker 1 Status:\r\n  Process Name: DW00\r\n  State: EXECUTING\r\n  Object Schema: SYSMAN\r\n  Object Name: EM_TARGET\r\n  Object Type: DATABASE_EXPORT\/SCHEMA\/PACKAGE_BODIES\/PACKAGE\/PACKAGE_BODY\r\n  Completed Objects: 76\r\n  Worker Parallelism: 1\r\n\r\nExport&gt;\r\n<\/pre>\n<p>\u05d1\u05e9\u05dc\u05d1 \u05d4\u05d6\u05d4 \u05e0\u05d5\u05db\u05dc \u05dc\u05d1\u05e6\u05e2 \u05de\u05d1\u05d7\u05e8 \u05e4\u05e7\u05d5\u05d3\u05d5\u05ea: \u05e9\u05d9\u05e0\u05d5\u05d9 \u05d7\u05dc\u05e7\u05d9\u05dd \u05d1\u05e4\u05e7\u05d5\u05d3\u05d4 \u05d4\u05de\u05e7\u05d5\u05e8\u05d9\u05ea \u05db\u05de\u05d5 \u05d4\u05d5\u05e1\u05e4\u05ea parallel processes \u05d0\u05d5 \u05d4\u05d5\u05e1\u05e4\u05ea \u05e7\u05d1\u05e6\u05d9 dump file, \u05d1\u05d9\u05e6\u05d5\u05e2 \u05ea\u05d7\u05e7\u05d5\u05e8 \u05e2\u05dc \u05d4\u05de\u05e6\u05d1 \u05d4\u05e0\u05d5\u05db\u05d7\u05d9, \u05d4\u05e4\u05e1\u05e7\u05ea \u05ea\u05d4\u05dc\u05d9\u05da \u05d4-export \u05d0\u05d5 \u05d0\u05e4\u05d9\u05dc\u05d5 \u05d4\u05ea\u05d7\u05d1\u05e8\u05d5\u05ea \u05de\u05d7\u05d3\u05e9 \u05dc\u05de\u05de\u05e9\u05e7 \u05d4-client.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nExport&gt; help\r\n------------------------------------------------------------------------------\r\n\r\nThe following commands are valid while in interactive mode.\r\nNote: abbreviations are allowed.\r\n\r\nADD_FILE\r\nAdd dumpfile to dumpfile set.\r\n\r\nCONTINUE_CLIENT\r\nReturn to logging mode. Job will be restarted if idle.\r\n\r\nEXIT_CLIENT\r\nQuit client session and leave job running.\r\n\r\nFILESIZE\r\nDefault filesize (bytes) for subsequent ADD_FILE commands.\r\n\r\nHELP\r\nSummarize interactive commands.\r\n\r\nKILL_JOB\r\nDetach and delete job.\r\n\r\nPARALLEL\r\nChange the number of active workers for current job.\r\n\r\nREUSE_DUMPFILES\r\nOverwrite destination dump file if it exists &#x5B;N].\r\n\r\nSTART_JOB\r\nStart or resume current job.\r\nValid keyword values are: SKIP_CURRENT.\r\n\r\nSTATUS\r\nFrequency (secs) job status is to be monitored where\r\nthe default &#x5B;0] will show new status when available.\r\n\r\nSTOP_JOB\r\nOrderly shutdown of job execution and exits the client.\r\nValid keyword values are: IMMEDIATE.\r\n<\/pre>\n<h2>\u05e2\u05e6\u05d9\u05e8\u05ea \u05ea\u05d4\u05dc\u05d9\u05da \u05d4-export<\/h2>\n<p>\u05d1\u05de\u05d9\u05d3\u05d4 \u05d5\u05d0\u05e0\u05d7\u05e0\u05d5 \u05e8\u05d5\u05e6\u05d9\u05dd \u05dc\u05e2\u05e6\u05d5\u05e8 \u05d0\u05ea \u05ea\u05d4\u05dc\u05d9\u05da \u05d4-export \u05d0\u05e0\u05d7\u05e0\u05d5 \u05de\u05d1\u05d7\u05d9\u05e0\u05d9\u05dd \u05d1\u05d9\u05df \u05e9\u05e0\u05d9 \u05e1\u05d5\u05d2\u05d9\u05dd \u05e9\u05dc \u05e2\u05e6\u05d9\u05e8\u05d4. \u05d4\u05e8\u05d0\u05e9\u05d5\u05df \u05d4\u05d9\u05d0 \u05e2\u05e6\u05d9\u05e8\u05d4 \u05de\u05e1\u05d5\u05d3\u05e8\u05ea (stop_job) \u05e9\u05de\u05de\u05e0\u05d4 \u05e0\u05d5\u05db\u05dc \u05dc\u05d4\u05de\u05e9\u05d9\u05da \u05d0\u05ea \u05d4\u05e4\u05e7\u05d5\u05d3\u05d4 \u05de\u05d0\u05d5\u05d7\u05e8 \u05d9\u05d5\u05ea\u05e8 \u05d5\u05d4\u05e9\u05e0\u05d9\u05d4 \u05d4\u05d9\u05d0 \u05e2\u05e6\u05d9\u05e8\u05d4 \u05de\u05d5\u05d7\u05dc\u05d8\u05ea \u05e9\u05dc \u05d4\u05ea\u05d4\u05dc\u05d9\u05da \u05e2\u05dc \u05d9\u05d3\u05d9 &quot;\u05d4\u05e8\u05d9\u05d2\u05ea\u05d5&quot; (kill_job \u05d0\u05d5 stop_job=immediate). \u05d1\u05e8\u05d2\u05e2 \u05e9\u05e0\u05e8\u05d9\u05e5 \u05d0\u05ea \u05d4\u05e4\u05e7\u05d5\u05d3\u05d4, \u05d4\u05d5\u05d0 \u05d9\u05d5\u05d5\u05d3\u05d0 \u05e9\u05d0\u05e0\u05d7\u05e0\u05d5 \u05e8\u05d5\u05e6\u05d9\u05dd \u05d1\u05d0\u05de\u05ea \u05dc\u05e2\u05e6\u05d5\u05e8 \u05d0\u05ea \u05d4-export \u05d5\u05d4\u05ea\u05d4\u05dc\u05d9\u05da \u05d9\u05e2\u05e6\u05d5\u05e8 \u2013 \u05d1\u05d9\u05df \u05d0\u05dd \u05de\u05d9\u05d3\u05d9\u05ea \u05d0\u05d5 \u05d0\u05d7\u05e8\u05d9 \u05db\u05de\u05d4 \u05d3\u05e7\u05d5\u05ea. \u05dc\u05d3\u05d5\u05d2\u05de\u05d4:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nExport&gt; kill\r\nAre you sure you wish to stop this job (&#x5B;yes]\/no): y\r\n<\/pre>\n<h2>\u05d4\u05e4\u05e2\u05dc\u05ea \u05ea\u05d4\u05dc\u05d9\u05da \u05d4-export \u05de\u05d7\u05d3\u05e9<\/h2>\n<p>\u05d0\u05dd \u05d1\u05d9\u05e6\u05e2\u05e0\u05d5 \u05e2\u05e6\u05d9\u05e8\u05d4 \u05de\u05e1\u05d5\u05d3\u05e8\u05ea \u05e9\u05dc \u05d4\u05ea\u05d4\u05dc\u05d9\u05da (\u05d1\u05e2\u05e6\u05dd \u05d1\u05d9\u05e6\u05e2\u05e0\u05d5 \u05e1\u05d5\u05d2 \u05e9\u05dc suspend) \u05d0\u05d6 \u05e0\u05d5\u05db\u05dc \u05dc\u05d4\u05ea\u05d7\u05d1\u05e8 \u05de\u05d7\u05d3\u05e9 \u05dc\u05ea\u05d4\u05dc\u05d9\u05da \u05d5\u05dc\u05d4\u05e4\u05e2\u05d9\u05dc \u05d0\u05d5\u05ea\u05d5 \u05de\u05d7\u05d3\u05e9. \u05e0\u05d0\u05ea\u05e8 \u05d0\u05ea \u05e9\u05dd \u05d4\u05d2'\u05d5\u05d1 \u05e9\u05e2\u05e6\u05e8\u05e0\u05d5 &#8211; \u05e9\u05d9\u05de\u05d5 \u05dc\u05d1 \u05d1\u05e4\u05e7\u05d5\u05d3\u05d4 \u05d4\u05d1\u05d0\u05d4 \u05dc-state \u05e9\u05d4\u05d5\u05d0 NOT RUNNING:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nSQL&gt; r\r\n1* SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs\r\n\r\nOWNER_NAME                     JOB_NAME                       OPERATION                      JOB_MODE                       STATE\r\n------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------\r\nZOHAR                          SYS_EXPORT_FULL_01             EXPORT                         FULL                           NOT RUNNING\r\n<\/pre>\n<p>\u05e0\u05d1\u05e6\u05e2 attach \u05de\u05d7\u05d3\u05e9 \u05dc\u05d2'\u05d5\u05d1:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n&#x5B;oracle@lnx-oracle66-db11g ~]$ expdp attach=SYS_EXPORT_FULL_01\r\n\r\nExport: Release 11.2.0.4.0 - Production on Thu Feb 19 11:33:06 2015\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nUsername: zohar\r\nPassword:\r\n\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nJob: SYS_EXPORT_FULL_01\r\n  Owner: ZOHAR\r\n  Operation: EXPORT\r\n  Creator Privs: TRUE\r\n  GUID: 0F6E8EA07E7A1310E0530100007F8CBB\r\n  Start Time: Thursday, 19 February, 2015 11:32:17\r\n  Mode: FULL\r\n  Instance: orcldg\r\n  Max Parallelism: 1\r\n  EXPORT Job Parameters:\r\n  Parameter Name      Parameter Value:\r\n     CLIENT_COMMAND        zohar\/******** full=y directory=DATA_PUMP_DIR dumpfile=zohar.dmp logfile=zohar.log\r\n  State: IDLING\r\n  Bytes Processed: 0\r\n  Current Parallelism: 1\r\n  Job Error Count: 0\r\n  Dump File: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_11204\/rdbms\/log\/zohar.dmp\r\n    bytes written: 4,096\r\n\r\nWorker 1 Status:\r\n  Process Name: DW00\r\n  State: UNDEFINED\r\n\r\nExport&gt;\r\n<\/pre>\n<p>\u05e0\u05e4\u05e2\u05d9\u05dc \u05de\u05d7\u05d3\u05e9 \u05d0\u05ea \u05d4\u05d2'\u05d5\u05d1 \u05d5\u05e0\u05d1\u05d3\u05d5\u05e7 \u05e9\u05d4\u05d5\u05d0 \u05d4\u05ea\u05d7\u05d9\u05dc \u05dc\u05e2\u05d1\u05d5\u05d3 (state \u05d9\u05d4\u05d9\u05d4 \u05d1-executing):<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nExport&gt; start\r\n\r\nExport&gt; status\r\n\r\nJob: SYS_EXPORT_FULL_01\r\n  Operation: EXPORT\r\n  Mode: FULL\r\n  State: EXECUTING\r\n  Bytes Processed: 0\r\n  Current Parallelism: 1\r\n  Job Error Count: 0\r\n  Dump File: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_11204\/rdbms\/log\/zohar.dmp\r\n    bytes written: 94,208\r\n\r\nWorker 1 Status:\r\n  Process Name: DW00\r\n  State: EXECUTING\r\n\r\nExport&gt;\r\n<\/pre>\n<p>\u05d1\u05e8\u05d2\u05e2 \u05e9\u05d1\u05d9\u05e6\u05e2\u05e0\u05d5 \u05d0\u05ea \u05d4\u05d4\u05e4\u05e2\u05dc\u05d4, \u05e0\u05d5\u05db\u05dc \u05dc\u05d7\u05d3\u05e9 \u05d0\u05ea \u05d4\u05d2\u05d9\u05e9\u05d4 \u05de\u05d7\u05d3\u05e9 \u05dc-client:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nExport&gt; cont\r\nRestarting &quot;ZOHAR&quot;.&quot;SYS_EXPORT_FULL_01&quot;:  zohar\/******** full=y directory=DATA_PUMP_DIR dumpfile=zohar.dmp logfile=zohar.log\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PUBLIC_SYNONYM\/SYNONYM\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/SYNONYM\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TYPE\/TYPE_SPEC\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TYPE\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\r\n<\/pre>\n<h2>\u05e9\u05d9\u05de\u05d5\u05e9 \u05d1-impdp:<\/h2>\n<p>\u05db\u05dc \u05d4\u05d3\u05d1\u05e8\u05d9\u05dd \u05e9\u05d4\u05e8\u05d0\u05d9\u05ea\u05d9 \u05e4\u05d4 \u05e0\u05d9\u05ea\u05df \u05dc\u05d1\u05e6\u05e2 \u05d2\u05dd \u05e2\u05dd \u05e4\u05e7\u05d5\u05d3\u05d5\u05ea \u05e9\u05dc impdp:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nImport&gt; help\r\n------------------------------------------------------------------------------\r\n\r\nThe following commands are valid while in interactive mode.\r\nNote: abbreviations are allowed.\r\n\r\nCONTINUE_CLIENT\r\nReturn to logging mode. Job will be restarted if idle.\r\n\r\nEXIT_CLIENT\r\nQuit client session and leave job running.\r\n\r\nHELP\r\nSummarize interactive commands.\r\n\r\nKILL_JOB\r\nDetach and delete job.\r\n\r\nPARALLEL\r\nChange the number of active workers for current job.\r\n\r\nSTART_JOB\r\nStart or resume current job.\r\nValid keywords are: SKIP_CURRENT.\r\n\r\nSTATUS\r\nFrequency (secs) job status is to be monitored where\r\nthe default &#x5B;0] will show new status when available.\r\n\r\nSTOP_JOB\r\nOrderly shutdown of job execution and exits the client.\r\nValid keywords are: IMMEDIATE.\r\n<\/pre>\n<p>\u05e1\u05d8\u05d8\u05d5\u05e1 \u05e9\u05dc import:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nImport&gt; stat\r\n\r\nJob: SYS_IMPORT_SCHEMA_01\r\n  Operation: IMPORT\r\n  Mode: SCHEMA\r\n  State: EXECUTING\r\n  Bytes Processed: 0\r\n  Current Parallelism: 1\r\n  Job Error Count: 0\r\n  Dump File: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_11204\/rdbms\/log\/zohar.dmp\r\n\r\nWorker 1 Status:\r\n  Process Name: DW00\r\n  State: EXECUTING\r\n  Object Schema: ZOHAR2\r\n  Object Name: MGMT_METRIC_DETAILS_ARRAY\r\n  Object Type: DATABASE_EXPORT\/SCHEMA\/TYPE\/TYPE_SPEC\r\n  Completed Objects: 312\r\n  Worker Parallelism: 1\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u05d9\u05e9 \u05dc\u05d9 \u05dc\u05e7\u05d5\u05d7 \u05e9\u05de\u05e8\u05d9\u05e5 \u05e1\u05e7\u05e8\u05d9\u05e4\u05d8\u05d9\u05dd \u05e9\u05de\u05d2\u05d1\u05d9\u05dd \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05de\u05e8\u05db\u05d6\u05d9\u05d5\u05ea \u05d1\u05de\u05e2\u05e8\u05db\u05ea \u05e9\u05dc\u05d5 \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea \u05e9\u05d9\u05de\u05e9 \u05d1-data pump. \u05d6\u05d4 \u05e4\u05ea\u05e8\u05d5\u05df \u05dc\u05d0 \u05e8\u05e2 \u05d1\u05db\u05dc\u05dc \u05db\u05d3\u05d9 \u05dc\u05e9\u05de\u05d5\u05e8 \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05dc\u05e6\u05e8\u05db\u05d9 \u05e9\u05d7\u05d6\u05d5\u05e8 \u05de\u05d4\u05d9\u05e8 \u05d0\u05d5 \u05dc\u05d4\u05e2\u05d1\u05e8\u05d4 \u05dc\u05e1\u05d1\u05d9\u05d1\u05d5\u05ea \u05d4\u05e4\u05d9\u05ea\u05d5\u05d7. \u05d4\u05d1\u05e2\u05d9\u05d4 \u05d4\u05d9\u05d0 \u05e9\u05d4\u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05e9\u05d0\u05d5\u05ea\u05df \u05de\u05d2\u05d1\u05d4 \u05d4\u05dc\u05e7\u05d5\u05d7 \u05d4\u05df \u05d2\u05d3\u05d5\u05dc\u05d5\u05ea \u05de\u05d0\u05d5\u05d3 \u05d5\u05d4-export \u05dc\u05d5\u05e7\u05d7 \u05d4\u05de\u05d5\u05df \u05d6\u05de\u05df (\u05db\u05de\u05d4 \u05e9\u05e2\u05d5\u05ea \u05d8\u05d5\u05d1\u05d5\u05ea). \u05dc\u05e4\u05e2\u05de\u05d9\u05dd, \u05e0\u05d5\u05e6\u05e8 \u05dc\u05e0\u05d5 \u05e6\u05d5\u05e8\u05da \u05dc&quot;\u05d4\u05e6\u05d9\u05e5&quot; \u05dc\u05ea\u05d5\u05da \u05d4\u05ea\u05d4\u05dc\u05d9\u05da \u05e9\u05dc \u05d4-export \u05d5\u05dc\u05e8\u05d0\u05d5\u05ea [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1572,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"\u05d1\u05dc\u05d5\u05d2: \u05e0\u05d9\u05d4\u05d5\u05dc \u05d2'\u05d5\u05d1\u05d9\u05dd \u05e9\u05dc datapump http:\/\/wp.me\/p5e40u-pi #blog #aced #oracle","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6],"tags":[56,65],"class_list":["post-1568","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-expdp","tag-impdp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u05e0\u05d9\u05d4\u05d5\u05dc \u05d2&#039;\u05d5\u05d1\u05d9\u05dd \u05e9\u05dc datapump - Real Time DBA Magic<\/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.realdbamagic.com\/he\/manage-datapump-jobs\/\" \/>\n<meta property=\"og:locale\" content=\"he_IL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u05e0\u05d9\u05d4\u05d5\u05dc \u05d2&#039;\u05d5\u05d1\u05d9\u05dd \u05e9\u05dc datapump - Real Time DBA Magic\" \/>\n<meta property=\"og:description\" content=\"\u05d9\u05e9 \u05dc\u05d9 \u05dc\u05e7\u05d5\u05d7 \u05e9\u05de\u05e8\u05d9\u05e5 \u05e1\u05e7\u05e8\u05d9\u05e4\u05d8\u05d9\u05dd \u05e9\u05de\u05d2\u05d1\u05d9\u05dd \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05de\u05e8\u05db\u05d6\u05d9\u05d5\u05ea \u05d1\u05de\u05e2\u05e8\u05db\u05ea \u05e9\u05dc\u05d5 \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea \u05e9\u05d9\u05de\u05e9 \u05d1-data pump. \u05d6\u05d4 \u05e4\u05ea\u05e8\u05d5\u05df \u05dc\u05d0 \u05e8\u05e2 \u05d1\u05db\u05dc\u05dc \u05db\u05d3\u05d9 \u05dc\u05e9\u05de\u05d5\u05e8 \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05dc\u05e6\u05e8\u05db\u05d9 \u05e9\u05d7\u05d6\u05d5\u05e8 \u05de\u05d4\u05d9\u05e8 \u05d0\u05d5 \u05dc\u05d4\u05e2\u05d1\u05e8\u05d4 \u05dc\u05e1\u05d1\u05d9\u05d1\u05d5\u05ea \u05d4\u05e4\u05d9\u05ea\u05d5\u05d7. \u05d4\u05d1\u05e2\u05d9\u05d4 \u05d4\u05d9\u05d0 \u05e9\u05d4\u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05e9\u05d0\u05d5\u05ea\u05df \u05de\u05d2\u05d1\u05d4 \u05d4\u05dc\u05e7\u05d5\u05d7 \u05d4\u05df \u05d2\u05d3\u05d5\u05dc\u05d5\u05ea \u05de\u05d0\u05d5\u05d3 \u05d5\u05d4-export \u05dc\u05d5\u05e7\u05d7 \u05d4\u05de\u05d5\u05df \u05d6\u05de\u05df (\u05db\u05de\u05d4 \u05e9\u05e2\u05d5\u05ea \u05d8\u05d5\u05d1\u05d5\u05ea). \u05dc\u05e4\u05e2\u05de\u05d9\u05dd, \u05e0\u05d5\u05e6\u05e8 \u05dc\u05e0\u05d5 \u05e6\u05d5\u05e8\u05da \u05dc&quot;\u05d4\u05e6\u05d9\u05e5&quot; \u05dc\u05ea\u05d5\u05da \u05d4\u05ea\u05d4\u05dc\u05d9\u05da \u05e9\u05dc \u05d4-export \u05d5\u05dc\u05e8\u05d0\u05d5\u05ea [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/\" \/>\n<meta property=\"og:site_name\" content=\"Real Time DBA Magic\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/zohare\" \/>\n<meta property=\"article:author\" content=\"https:\/\/facebook.com\/zohare\" \/>\n<meta property=\"article:published_time\" content=\"2015-02-23T08:38:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-02-23T08:41:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.realdbamagic.com\/wp-content\/uploads\/2015\/02\/waterpump-vandens-siurblys.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2064\" \/>\n\t<meta property=\"og:image:height\" content=\"2321\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@realmgic\" \/>\n<meta name=\"twitter:site\" content=\"@realmgic\" \/>\n<meta name=\"twitter:label1\" content=\"\u05e0\u05db\u05ea\u05d1 \u05e2\u05dc \u05d9\u05d3\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u05d6\u05de\u05df \u05e7\u05e8\u05d9\u05d0\u05d4 \u05de\u05d5\u05e2\u05e8\u05da\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u05d3\u05e7\u05d5\u05ea\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/\"},\"author\":{\"name\":\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/fef9c8983df7a5ec53d0e2c733148334\"},\"headline\":\"\u05e0\u05d9\u05d4\u05d5\u05dc \u05d2'\u05d5\u05d1\u05d9\u05dd \u05e9\u05dc datapump\",\"datePublished\":\"2015-02-23T08:38:16+00:00\",\"dateModified\":\"2015-02-23T08:41:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/\"},\"wordCount\":946,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/13e6cf68689bd7ea5f6556f5246e6175\"},\"image\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.realdbamagic.com\\\/wp-content\\\/uploads\\\/2015\\\/02\\\/waterpump-vandens-siurblys.png\",\"keywords\":[\"expdp\",\"impdp\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"he-IL\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/\",\"url\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/\",\"name\":\"\u05e0\u05d9\u05d4\u05d5\u05dc \u05d2'\u05d5\u05d1\u05d9\u05dd \u05e9\u05dc datapump - Real Time DBA Magic\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.realdbamagic.com\\\/wp-content\\\/uploads\\\/2015\\\/02\\\/waterpump-vandens-siurblys.png\",\"datePublished\":\"2015-02-23T08:38:16+00:00\",\"dateModified\":\"2015-02-23T08:41:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/#breadcrumb\"},\"inLanguage\":\"he-IL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"he-IL\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.realdbamagic.com\\\/wp-content\\\/uploads\\\/2015\\\/02\\\/waterpump-vandens-siurblys.png\",\"contentUrl\":\"https:\\\/\\\/www.realdbamagic.com\\\/wp-content\\\/uploads\\\/2015\\\/02\\\/waterpump-vandens-siurblys.png\",\"width\":2064,\"height\":2321,\"caption\":\"Green water pump\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/manage-datapump-jobs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u05e0\u05d9\u05d4\u05d5\u05dc \u05d2'\u05d5\u05d1\u05d9\u05dd \u05e9\u05dc datapump\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#website\",\"url\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/\",\"name\":\"Real Time DBA Magic\",\"description\":\"Doing Real Time DBA Magics\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/13e6cf68689bd7ea5f6556f5246e6175\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"he-IL\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/13e6cf68689bd7ea5f6556f5246e6175\",\"name\":\"Zohar Elkayam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"he-IL\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g\",\"caption\":\"Zohar Elkayam\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g\"},\"sameAs\":[\"https:\\\/\\\/zoharelkayam.me\",\"https:\\\/\\\/facebook.com\\\/zohare\",\"https:\\\/\\\/x.com\\\/realmgic\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/fef9c8983df7a5ec53d0e2c733148334\",\"name\":\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"he-IL\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g\",\"caption\":\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\"},\"sameAs\":[\"https:\\\/\\\/zoharelkayam.me\",\"https:\\\/\\\/facebook.com\\\/zohare\",\"https:\\\/\\\/x.com\\\/realmgic\"],\"url\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/author\\\/zohar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u05e0\u05d9\u05d4\u05d5\u05dc \u05d2'\u05d5\u05d1\u05d9\u05dd \u05e9\u05dc datapump - Real Time DBA Magic","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.realdbamagic.com\/he\/manage-datapump-jobs\/","og_locale":"he_IL","og_type":"article","og_title":"\u05e0\u05d9\u05d4\u05d5\u05dc \u05d2'\u05d5\u05d1\u05d9\u05dd \u05e9\u05dc datapump - Real Time DBA Magic","og_description":"\u05d9\u05e9 \u05dc\u05d9 \u05dc\u05e7\u05d5\u05d7 \u05e9\u05de\u05e8\u05d9\u05e5 \u05e1\u05e7\u05e8\u05d9\u05e4\u05d8\u05d9\u05dd \u05e9\u05de\u05d2\u05d1\u05d9\u05dd \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05de\u05e8\u05db\u05d6\u05d9\u05d5\u05ea \u05d1\u05de\u05e2\u05e8\u05db\u05ea \u05e9\u05dc\u05d5 \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea \u05e9\u05d9\u05de\u05e9 \u05d1-data pump. \u05d6\u05d4 \u05e4\u05ea\u05e8\u05d5\u05df \u05dc\u05d0 \u05e8\u05e2 \u05d1\u05db\u05dc\u05dc \u05db\u05d3\u05d9 \u05dc\u05e9\u05de\u05d5\u05e8 \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05dc\u05e6\u05e8\u05db\u05d9 \u05e9\u05d7\u05d6\u05d5\u05e8 \u05de\u05d4\u05d9\u05e8 \u05d0\u05d5 \u05dc\u05d4\u05e2\u05d1\u05e8\u05d4 \u05dc\u05e1\u05d1\u05d9\u05d1\u05d5\u05ea \u05d4\u05e4\u05d9\u05ea\u05d5\u05d7. \u05d4\u05d1\u05e2\u05d9\u05d4 \u05d4\u05d9\u05d0 \u05e9\u05d4\u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05e9\u05d0\u05d5\u05ea\u05df \u05de\u05d2\u05d1\u05d4 \u05d4\u05dc\u05e7\u05d5\u05d7 \u05d4\u05df \u05d2\u05d3\u05d5\u05dc\u05d5\u05ea \u05de\u05d0\u05d5\u05d3 \u05d5\u05d4-export \u05dc\u05d5\u05e7\u05d7 \u05d4\u05de\u05d5\u05df \u05d6\u05de\u05df (\u05db\u05de\u05d4 \u05e9\u05e2\u05d5\u05ea \u05d8\u05d5\u05d1\u05d5\u05ea). \u05dc\u05e4\u05e2\u05de\u05d9\u05dd, \u05e0\u05d5\u05e6\u05e8 \u05dc\u05e0\u05d5 \u05e6\u05d5\u05e8\u05da \u05dc&quot;\u05d4\u05e6\u05d9\u05e5&quot; \u05dc\u05ea\u05d5\u05da \u05d4\u05ea\u05d4\u05dc\u05d9\u05da \u05e9\u05dc \u05d4-export \u05d5\u05dc\u05e8\u05d0\u05d5\u05ea [&hellip;]","og_url":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/","og_site_name":"Real Time DBA Magic","article_publisher":"https:\/\/facebook.com\/zohare","article_author":"https:\/\/facebook.com\/zohare","article_published_time":"2015-02-23T08:38:16+00:00","article_modified_time":"2015-02-23T08:41:55+00:00","og_image":[{"width":2064,"height":2321,"url":"https:\/\/www.realdbamagic.com\/wp-content\/uploads\/2015\/02\/waterpump-vandens-siurblys.png","type":"image\/png"}],"author":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd","twitter_card":"summary_large_image","twitter_creator":"@realmgic","twitter_site":"@realmgic","twitter_misc":{"\u05e0\u05db\u05ea\u05d1 \u05e2\u05dc \u05d9\u05d3":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd","\u05d6\u05de\u05df \u05e7\u05e8\u05d9\u05d0\u05d4 \u05de\u05d5\u05e2\u05e8\u05da":"5 \u05d3\u05e7\u05d5\u05ea"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/#article","isPartOf":{"@id":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/"},"author":{"name":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd","@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/fef9c8983df7a5ec53d0e2c733148334"},"headline":"\u05e0\u05d9\u05d4\u05d5\u05dc \u05d2'\u05d5\u05d1\u05d9\u05dd \u05e9\u05dc datapump","datePublished":"2015-02-23T08:38:16+00:00","dateModified":"2015-02-23T08:41:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/"},"wordCount":946,"commentCount":0,"publisher":{"@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/13e6cf68689bd7ea5f6556f5246e6175"},"image":{"@id":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.realdbamagic.com\/wp-content\/uploads\/2015\/02\/waterpump-vandens-siurblys.png","keywords":["expdp","impdp"],"articleSection":["Oracle"],"inLanguage":"he-IL","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/","url":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/","name":"\u05e0\u05d9\u05d4\u05d5\u05dc \u05d2'\u05d5\u05d1\u05d9\u05dd \u05e9\u05dc datapump - Real Time DBA Magic","isPartOf":{"@id":"https:\/\/www.realdbamagic.com\/he\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/#primaryimage"},"image":{"@id":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.realdbamagic.com\/wp-content\/uploads\/2015\/02\/waterpump-vandens-siurblys.png","datePublished":"2015-02-23T08:38:16+00:00","dateModified":"2015-02-23T08:41:55+00:00","breadcrumb":{"@id":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/#breadcrumb"},"inLanguage":"he-IL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/"]}]},{"@type":"ImageObject","inLanguage":"he-IL","@id":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/#primaryimage","url":"https:\/\/www.realdbamagic.com\/wp-content\/uploads\/2015\/02\/waterpump-vandens-siurblys.png","contentUrl":"https:\/\/www.realdbamagic.com\/wp-content\/uploads\/2015\/02\/waterpump-vandens-siurblys.png","width":2064,"height":2321,"caption":"Green water pump"},{"@type":"BreadcrumbList","@id":"https:\/\/www.realdbamagic.com\/he\/manage-datapump-jobs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.realdbamagic.com\/he\/"},{"@type":"ListItem","position":2,"name":"\u05e0\u05d9\u05d4\u05d5\u05dc \u05d2'\u05d5\u05d1\u05d9\u05dd \u05e9\u05dc datapump"}]},{"@type":"WebSite","@id":"https:\/\/www.realdbamagic.com\/he\/#website","url":"https:\/\/www.realdbamagic.com\/he\/","name":"Real Time DBA Magic","description":"Doing Real Time DBA Magics","publisher":{"@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/13e6cf68689bd7ea5f6556f5246e6175"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.realdbamagic.com\/he\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"he-IL"},{"@type":["Person","Organization"],"@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/13e6cf68689bd7ea5f6556f5246e6175","name":"Zohar Elkayam","image":{"@type":"ImageObject","inLanguage":"he-IL","@id":"https:\/\/secure.gravatar.com\/avatar\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g","caption":"Zohar Elkayam"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g"},"sameAs":["https:\/\/zoharelkayam.me","https:\/\/facebook.com\/zohare","https:\/\/x.com\/realmgic"]},{"@type":"Person","@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/fef9c8983df7a5ec53d0e2c733148334","name":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd","image":{"@type":"ImageObject","inLanguage":"he-IL","@id":"https:\/\/secure.gravatar.com\/avatar\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g","caption":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd"},"sameAs":["https:\/\/zoharelkayam.me","https:\/\/facebook.com\/zohare","https:\/\/x.com\/realmgic"],"url":"https:\/\/www.realdbamagic.com\/he\/author\/zohar\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.realdbamagic.com\/wp-content\/uploads\/2015\/02\/waterpump-vandens-siurblys.png","jetpack_shortlink":"https:\/\/wp.me\/p5e40u-pi","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/posts\/1568","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/comments?post=1568"}],"version-history":[{"count":5,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/posts\/1568\/revisions"}],"predecessor-version":[{"id":1576,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/posts\/1568\/revisions\/1576"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/media\/1572"}],"wp:attachment":[{"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/media?parent=1568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/categories?post=1568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/tags?post=1568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}