{"id":53720,"date":"2023-01-24T09:53:46","date_gmt":"2023-01-24T09:53:46","guid":{"rendered":"https:\/\/dbtut.com\/?p=53720"},"modified":"2023-01-24T09:54:15","modified_gmt":"2023-01-24T09:54:15","slug":"export-import-job-attach","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/","title":{"rendered":"Export\/Import Job Attach"},"content":{"rendered":"

We can monitor the status of an export\/import operation running in the background by attaching it with the ATTACH parameter.<\/p>\n

For this, we first need to know the owner of the running process.<\/p>\n

The owner of the running process can be seen by querying the DBA_DATAPUMP_JOBS view.<\/p>\n

SQL> desc dba_datapump_jobs;\r\n<\/pre>\n
\"\"<\/p>\n
In order to see the query results in a single line, the set linesize command is run.<\/p>\n
SQL> set linesize 9000;\r\n\r\nSQL> select OWNER_NAME, JOB_NAME, OPERATION, JOB_MODE, STATE from dba_datapump_jobs;\r\n\r\n<\/pre>\n
\"\"<\/p>\n
So:<\/p>\n
It is stated that the job that exports a schema named SYS_EXPORT_SCHEMA_02, whose owner is SYS user, is running.<\/p>\n
As seen above, since the owner of the job is SYS, we will do the ATTACH transaction to him.<\/p>\n
-bash-3.2$ expdp \"'\/ as sysdba'\" attach=sys.SYS_EXPORT_SCHEMA_02\r\n<\/pre>\n
\"\"<\/p>\n
You exit the interactive mode with exit or exit_client.<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
We can monitor the status of an export\/import operation running in the background by attaching it with the ATTACH parameter. For this, we first need to know the owner of the running process. The owner of the running process can be seen by querying the DBA_DATAPUMP_JOBS view. SQL> desc dba_datapump_jobs; In order to see the …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":53724,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-53720","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nExport\/Import Job Attach - Database Tutorials<\/title>\n<meta name=\"description\" content=\"We can monitor the status of an export\/import operation running in the background by attaching it with the ATTACH parameter.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Export\/Import Job Attach - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"We can monitor the status of an export\/import operation running in the background by attaching it with the ATTACH parameter.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-24T09:53:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-24T09:54:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-24-125310.png\" \/>\n\t<meta property=\"og:image:width\" content=\"712\" \/>\n\t<meta property=\"og:image:height\" content=\"326\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Export\/Import Job Attach\",\"datePublished\":\"2023-01-24T09:53:46+00:00\",\"dateModified\":\"2023-01-24T09:54:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/\"},\"wordCount\":122,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-24-125310.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/\",\"name\":\"Export\/Import Job Attach - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-24-125310.png\",\"datePublished\":\"2023-01-24T09:53:46+00:00\",\"dateModified\":\"2023-01-24T09:54:15+00:00\",\"description\":\"We can monitor the status of an export\/import operation running in the background by attaching it with the ATTACH parameter.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-24-125310.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-24-125310.png\",\"width\":712,\"height\":326},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Export\/Import Job Attach\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Export\/Import Job Attach - Database Tutorials","description":"We can monitor the status of an export\/import operation running in the background by attaching it with the ATTACH parameter.","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:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/","og_locale":"en_US","og_type":"article","og_title":"Export\/Import Job Attach - Database Tutorials","og_description":"We can monitor the status of an export\/import operation running in the background by attaching it with the ATTACH parameter.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/","og_site_name":"Database Tutorials","article_published_time":"2023-01-24T09:53:46+00:00","article_modified_time":"2023-01-24T09:54:15+00:00","og_image":[{"width":712,"height":326,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-24-125310.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Export\/Import Job Attach","datePublished":"2023-01-24T09:53:46+00:00","dateModified":"2023-01-24T09:54:15+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/"},"wordCount":122,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-24-125310.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/","url":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/","name":"Export\/Import Job Attach - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-24-125310.png","datePublished":"2023-01-24T09:53:46+00:00","dateModified":"2023-01-24T09:54:15+00:00","description":"We can monitor the status of an export\/import operation running in the background by attaching it with the ATTACH parameter.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-24-125310.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-24-125310.png","width":712,"height":326},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/24\/export-import-job-attach\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Export\/Import Job Attach"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=53720"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53720\/revisions"}],"predecessor-version":[{"id":53725,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53720\/revisions\/53725"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/53724"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=53720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=53720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=53720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}