dba:datapump_oracle_export_plsql
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende Überarbeitung | Letzte ÜberarbeitungBeide Seiten der Revision | ||
dba:datapump_oracle_export_plsql [2019/02/16 10:07] – [PL/SQL Code für den Start von DataPump -das komplette Schema importieren] gpipperr | dba:datapump_oracle_export_plsql [2019/02/16 10:30] – [Job in der DB wieder abbrechen] gpipperr | ||
---|---|---|---|
Zeile 586: | Zeile 586: | ||
---- | ---- | ||
+ | |||
+ | ==== Jobs in der DB kontrollieren ==== | ||
+ | |||
+ | |||
+ | siehe auch https:// | ||
+ | |||
+ | <code sql> | ||
+ | |||
+ | --============================================================================== | ||
+ | -- GPI - Gunther Pippèrr | ||
+ | -- Desc: Get Information about running data pump jobs | ||
+ | -- Date: | ||
+ | --============================================================================== | ||
+ | set linesize 130 pagesize 300 | ||
+ | |||
+ | column owner_name format a10; | ||
+ | column job_name | ||
+ | column state format a12 | ||
+ | |||
+ | column operation like state | ||
+ | column job_mode like state | ||
+ | |||
+ | ttitle | ||
+ | |||
+ | |||
+ | select owner_name | ||
+ | , job_name | ||
+ | , operation | ||
+ | , job_mode | ||
+ | , state | ||
+ | , attached_sessions | ||
+ | from dba_datapump_jobs | ||
+ | where job_name not like ' | ||
+ | order by 1,2 | ||
+ | / | ||
+ | |||
+ | ttitle | ||
+ | |||
+ | |||
+ | column status | ||
+ | column object_id | ||
+ | column object_type | ||
+ | column OBJECT_NAME | ||
+ | |||
+ | select o.status | ||
+ | , o.object_id | ||
+ | , o.object_type | ||
+ | , o.owner||' | ||
+ | from dba_objects o | ||
+ | , dba_datapump_jobs j | ||
+ | where o.owner=j.owner_name | ||
+ | and o.object_name=j.job_name | ||
+ | and j.job_name not like ' | ||
+ | / | ||
+ | |||
+ | ttitle off | ||
+ | |||
+ | prompt ... | ||
+ | prompt ... check for "NOT RUNNING" | ||
+ | prompt ... | ||
+ | </ | ||
==== Quellen ==== | ==== Quellen ==== |
dba/datapump_oracle_export_plsql.txt · Zuletzt geändert: 2019/02/16 10:53 von gpipperr