Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [oracle@stormking cdb12102 dpump]$ expdp attach= "U"."SYS_EXPORT_TABLE_01"
- Export: Release 12.1.0.2.0 - Production on Mon Jul 18 22:06:21 2016
- Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
- Username: u/u@//stormking:1521/pdbm
- Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
- and Real Application Testing options
- Job: SYS_EXPORT_TABLE_01
- Owner: U
- Operation: EXPORT
- Creator Privs: TRUE
- GUID: 37F48589F45C6E50E0537901A8C02DBC
- Start Time: Monday, 18 July, 2016 22:05:44
- Mode: TABLE
- Instance: cdb12102
- Max Parallelism: 1
- Timezone: -07:00
- Timezone version: 18
- Endianness: LITTLE
- NLS character set: AL32UTF8
- NLS NCHAR character set: AL16UTF16
- EXPORT Job Parameters:
- Parameter Name Parameter Value:
- CLIENT_COMMAND u/********@//stormking:1521/pdbm parfile=expdp.table.u.u.par
- State: EXECUTING
- Bytes Processed: 0
- Current Parallelism: 1
- Job Error Count: 0
- Dump File: /home/oracle/brian/sql/dpump/expdp.table.u.u.01.dat
- bytes written: 4,096
- Dump File: /home/oracle/brian/sql/dpump/expdp.table.u.u.%u.dat
- Worker 1 Status:
- Instance ID: 1
- Instance name: cdb12102
- Host name: stormking
- Process Name: DW00
- State: EXECUTING
- Object Schema: U
- Object Name: U_UK
- Object Type: TABLE_EXPORT/TABLE/INDEX/INDEX
- Completed Objects: 1
- Worker Parallelism: 1
- Export>
- Export> desc
- Job: SYS_EXPORT_TABLE_01
- Owner: U
- Operation: EXPORT
- Creator Privs: TRUE
- GUID: 37F48589F45C6E50E0537901A8C02DBC
- Start Time: Monday, 18 July, 2016 22:05:44
- Mode: TABLE
- Instance: cdb12102
- Max Parallelism: 1
- Timezone: -07:00
- Timezone version: 18
- Endianness: LITTLE
- NLS character set: AL32UTF8
- NLS NCHAR character set: AL16UTF16
- EXPORT Job Parameters:
- Parameter Name Parameter Value:
- CLIENT_COMMAND u/********@//stormking:1521/pdbm parfile=expdp.table.u.u.par
- [oracle@stormking cdb12102 dpump]$ impdp u/u@//stormking:1521/pdbm parfile=impdp.table.u.u.par
- Import: Release 12.1.0.2.0 - Production on Mon Jul 18 22:14:35 2016
- Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
- Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
- and Real Application Testing options
- Master table "U"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
- Starting "U"."SYS_IMPORT_FULL_01": u/********@//stormking:1521/pdbm parfile=impdp.table.u.u.par
- Processing object type TABLE_EXPORT/TABLE/TABLE
- ^C
- Import> desc
- Job: SYS_IMPORT_FULL_01
- Owner: U
- Operation: IMPORT
- Creator Privs: TRUE
- GUID: 37F4A57EAE536EFDE0537901A8C0328C
- Start Time: Monday, 18 July, 2016 22:14:38
- Mode: FULL
- Instance: cdb12102
- Max Parallelism: 1
- Timezone: -07:00
- Timezone version: 18
- Endianness: LITTLE
- NLS character set: AL32UTF8
- NLS NCHAR character set: AL16UTF16
- EXPORT Job Parameters:
- Parameter Name Parameter Value:
- CLIENT_COMMAND u/********@//stormking:1521/pdbm parfile=expdp.table.u.u.par
- IMPORT Job Parameters:
- Parameter Name Parameter Value:
- CLIENT_COMMAND u/********@//stormking:1521/pdbm parfile=impdp.table.u.u.par
- TABLE_EXISTS_ACTION REPLACE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement