Advertisement
ExaGridDba

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

Jul 18th, 2016
263
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.52 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement