daily pastebin goal
75%
SHARE
TWEET

datapump undocumented command "desc"

ExaGridDba Jul 18th, 2016 99 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
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