Advertisement
ExaGridDba

datapump undocumented command "desc"

Jul 18th, 2016
200
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.40 KB | None | 0 0
  1. [oracle@stormking cdb12102 dpump]$ expdp attach= "U"."SYS_EXPORT_TABLE_01"
  2.  
  3. Export: Release 12.1.0.2.0 - Production on Mon Jul 18 22:06:21 2016
  4.  
  5. Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
  6.  
  7. Username: u/u@//stormking:1521/pdbm
  8.  
  9. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
  10. With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
  11. and Real Application Testing options
  12.  
  13.  
  14. Job: SYS_EXPORT_TABLE_01
  15. Owner: U
  16. Operation: EXPORT
  17. Creator Privs: TRUE
  18. GUID: 37F48589F45C6E50E0537901A8C02DBC
  19. Start Time: Monday, 18 July, 2016 22:05:44
  20. Mode: TABLE
  21. Instance: cdb12102
  22. Max Parallelism: 1
  23. Timezone: -07:00
  24. Timezone version: 18
  25. Endianness: LITTLE
  26. NLS character set: AL32UTF8
  27. NLS NCHAR character set: AL16UTF16
  28. EXPORT Job Parameters:
  29. Parameter Name Parameter Value:
  30. CLIENT_COMMAND u/********@//stormking:1521/pdbm parfile=expdp.table.u.u.par
  31. State: EXECUTING
  32. Bytes Processed: 0
  33. Current Parallelism: 1
  34. Job Error Count: 0
  35. Dump File: /home/oracle/brian/sql/dpump/expdp.table.u.u.01.dat
  36. bytes written: 4,096
  37. Dump File: /home/oracle/brian/sql/dpump/expdp.table.u.u.%u.dat
  38.  
  39. Worker 1 Status:
  40. Instance ID: 1
  41. Instance name: cdb12102
  42. Host name: stormking
  43. Process Name: DW00
  44. State: EXECUTING
  45. Object Schema: U
  46. Object Name: U_UK
  47. Object Type: TABLE_EXPORT/TABLE/INDEX/INDEX
  48. Completed Objects: 1
  49. Worker Parallelism: 1
  50.  
  51. Export>
  52. Export> desc
  53.  
  54. Job: SYS_EXPORT_TABLE_01
  55. Owner: U
  56. Operation: EXPORT
  57. Creator Privs: TRUE
  58. GUID: 37F48589F45C6E50E0537901A8C02DBC
  59. Start Time: Monday, 18 July, 2016 22:05:44
  60. Mode: TABLE
  61. Instance: cdb12102
  62. Max Parallelism: 1
  63. Timezone: -07:00
  64. Timezone version: 18
  65. Endianness: LITTLE
  66. NLS character set: AL32UTF8
  67. NLS NCHAR character set: AL16UTF16
  68. EXPORT Job Parameters:
  69. Parameter Name Parameter Value:
  70. CLIENT_COMMAND u/********@//stormking:1521/pdbm parfile=expdp.table.u.u.par
  71.  
  72. [oracle@stormking cdb12102 dpump]$ impdp u/u@//stormking:1521/pdbm parfile=impdp.table.u.u.par
  73.  
  74. Import: Release 12.1.0.2.0 - Production on Mon Jul 18 22:14:35 2016
  75.  
  76. Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
  77.  
  78. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
  79. With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
  80. and Real Application Testing options
  81. Master table "U"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
  82. Starting "U"."SYS_IMPORT_FULL_01": u/********@//stormking:1521/pdbm parfile=impdp.table.u.u.par
  83. Processing object type TABLE_EXPORT/TABLE/TABLE
  84. ^C
  85. Import> desc
  86.  
  87. Job: SYS_IMPORT_FULL_01
  88. Owner: U
  89. Operation: IMPORT
  90. Creator Privs: TRUE
  91. GUID: 37F4A57EAE536EFDE0537901A8C0328C
  92. Start Time: Monday, 18 July, 2016 22:14:38
  93. Mode: FULL
  94. Instance: cdb12102
  95. Max Parallelism: 1
  96. Timezone: -07:00
  97. Timezone version: 18
  98. Endianness: LITTLE
  99. NLS character set: AL32UTF8
  100. NLS NCHAR character set: AL16UTF16
  101. EXPORT Job Parameters:
  102. Parameter Name Parameter Value:
  103. CLIENT_COMMAND u/********@//stormking:1521/pdbm parfile=expdp.table.u.u.par
  104. IMPORT Job Parameters:
  105. Parameter Name Parameter Value:
  106. CLIENT_COMMAND u/********@//stormking:1521/pdbm parfile=impdp.table.u.u.par
  107. TABLE_EXISTS_ACTION REPLACE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement