daily pastebin goal
75%
SHARE
TWEET

ambiguous data pump command "s". start/stop/status

ExaGridDba Jul 18th, 2016 88 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. What is s?
  2. Start? Stop? Status?
  3. All three?
  4.  
  5. Export> s
  6. ORA-39004: invalid state
  7. ORA-39016: Operation not supported when job is in EXECUTING state.
  8. Are you sure you wish to stop this job ([yes]/no): no
  9.  
  10. Job: SYS_EXPORT_TABLE_01
  11.   Operation: EXPORT
  12.   Mode: TABLE
  13.   State: EXECUTING
  14.   Bytes Processed: 0
  15.   Current Parallelism: 1
  16.   Job Error Count: 0
  17.   Dump File: /home/oracle/brian/sql/dpump/expdp.table.u.u.01.dat
  18.     bytes written: 4,096
  19.   Dump File: /home/oracle/brian/sql/dpump/expdp.table.u.u.%u.dat
  20.  
  21. Worker 1 Status:
  22.   Instance ID: 1
  23.   Instance name: cdb12102
  24.   Host name: stormking
  25.   Process Name: DW00
  26.   State: EXECUTING
  27.   Object Type: TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
  28.   Completed Objects: 1
  29.   Total Objects: 1
  30.   Worker Parallelism: 1
  31.  
  32.  
  33. Import> s
  34. ORA-39004: invalid state
  35. ORA-39016: Operation not supported when job is in EXECUTING state.
  36. Are you sure you wish to stop this job ([yes]/no): no
  37.  
  38. Job: SYS_IMPORT_FULL_01
  39.   Operation: IMPORT
  40.   Mode: FULL
  41.   State: EXECUTING
  42.   Bytes Processed: 0
  43.   Current Parallelism: 1
  44.   Job Error Count: 0
  45.   Dump File: /home/oracle/brian/sql/dpump/expdp.table.u.u.01.dat
  46.   Dump File: /home/oracle/brian/sql/dpump/expdp.table.u.u.%u.dat
  47.  
  48. Worker 1 Status:
  49.   Instance ID: 1
  50.   Instance name: cdb12102
  51.   Host name: stormking
  52.   Process Name: DW00
  53.   State: EXECUTING
  54.   Object Schema: U
  55.   Object Name: U
  56.   Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
  57.   Completed Objects: 1
  58.   Total Objects: 1
  59.   Completed Bytes: 999,995,832
  60.   Worker Parallelism: 1
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top