Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [oracle@waipio1 WAILUA dpump]$ cat expdp.brian.texpdp.par
- directory=dpump
- logfile=expdp.brian.texpdp.log
- dumpfile=expdp.brian.texpdp.%U.dat
- logtime=all
- compression=all
- reuse_dumpfiles=yes
- tables=
- brian.texpdp
- [oracle@waipio1 WAILUA dpump]$ export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI'
- [oracle@waipio1 WAILUA dpump]$ expdp "'/ as sysdba'" parfile=expdp.brian.texpdp.par
- Export: Release 12.1.0.1.0 - Production on Sun Sep 29 15:32:45 2013
- Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
- Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
- and Real Application Testing options
- UDE-31623: operation generated ORACLE error 31623
- ORA-31623: a job is not attached to this session via the specified handle
- ORA-06512: at "SYS.DBMS_DATAPUMP", line 3874
- ORA-06512: at "SYS.DBMS_DATAPUMP", line 5161
- ORA-06512: at line 1
- [oracle@waipio1 WAILUA trace]$ cat WAILUA_dm00_16678.trc
- Trace file /app/oracle/diag/rdbms/wailua/WAILUA/trace/WAILUA_dm00_16678.trc
- Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
- and Real Application Testing options
- ORACLE_HOME = /app/oracle/product/12.1.0/db_1
- System name: Linux
- Node name: waipio1
- Release: 3.8.13-13.el6uek.x86_64
- Version: #1 SMP Wed Aug 21 14:28:36 PDT 2013
- Machine: x86_64
- Instance name: WAILUA
- Redo thread mounted by this instance: 1
- Oracle process number: 39
- Unix process pid: 16678, image: oracle@waipio1 (DM00)
- *** 2013-09-29 15:32:46.642
- *** SESSION ID:(418.77) 2013-09-29 15:32:46.642
- *** CLIENT ID:() 2013-09-29 15:32:46.642
- *** SERVICE NAME:(SYS$USERS) 2013-09-29 15:32:46.642
- *** MODULE NAME:(Data Pump Master) 2013-09-29 15:32:46.642
- *** ACTION NAME:(SYS_EXPORT_TABLE_06) 2013-09-29 15:32:46.642
- KUPC: Setting remote flag for this process to FALSE
- KUPP: Initialization complete for master process DM00
- *** 2013-09-29 15:32:47.774
- ksvp2penabled: ep->flg = 0, rpr->slv_flg = 0
- ksvp2penabled: ep = 0x7f9fa0b80e30, rpr = 0x1eee90910
- KUPP: Error 6502 detected in master process DM00
- OPIRIP: Uncaught error 447. Error stack:
- ORA-00447: fatal error in background process
- ORA-31666: Master process DM00 had an unhandled exception.
- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- ORA-06512: at "SYS.KUPM$MCP", line 16913
- ORA-06512: at "SYS.KUPM$MCP", line 16804
- ORA-06512: at "SYS.KUPM$MCP", line 16599
- ORA-06512: at "SYS.KUPM$MCP", line 1104
- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- ORA-06512: at "SYS.KUPM$MCP", line 16913
- ORA-06512: at "SYS.KUPM$MCP", line 16804
- ORA-06512: at "SYS.KUPM$MCP", line 16599
- ORA-06512: at "SYS.KUPM$MCP", line 1622
- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- ORA-06512: at line 2
- [oracle@waipio1 WAILUA dpump]$ export NLS_DATE_FORMAT='YYYYMMDD HH24:MI'
- [oracle@waipio1 WAILUA dpump]$ expdp "'/ as sysdba'" parfile=expdp.brian.texpdp.par
- Export: Release 12.1.0.1.0 - Production on Sun Sep 29 15:33:10 2013
- Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
- Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
- and Real Application Testing options
- 20130929 15:33 15:33:13.526: Starting "SYS"."SYS_EXPORT_TABLE_07": "/******** AS SYSDBA" parfile=expdp.brian.texpdp.par
- 20130929 15:33 15:33:13.864: Estimate in progress using BLOCKS method...
- 20130929 15:33 15:33:14.575: Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
- 20130929 15:33 15:33:14.595: Total estimation using BLOCKS method: 64 KB
- 20130929 15:33 15:33:16.697: Processing object type TABLE_EXPORT/TABLE/TABLE
- 20130929 15:33 15:33:17.015: Processing object type TABLE_EXPORT/TABLE/IDENTITY_COLUMN
- 20130929 15:33 15:33:17.357: Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
- 20130929 15:33 15:33:17.361: Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
- 20130929 15:33 15:33:31.716: . . exported "BRIAN"."TEXPDP" 4.703 KB 1 rows
- 20130929 15:33 15:33:31.969: Master table "SYS"."SYS_EXPORT_TABLE_07" successfully loaded/unloaded
- 20130929 15:33 15:33:31.972: ******************************************************************************
- 20130929 15:33 15:33:31.973: Dump file set for SYS.SYS_EXPORT_TABLE_07 is:
- 20130929 15:33 15:33:31.975: /home/oracle/sql/dpump/expdp.brian.texpdp.01.dat
- 20130929 15:33 15:33:31.977: Job "SYS"."SYS_EXPORT_TABLE_07" successfully completed at Sun Sep 29 15:33:31 2013 elapsed 0 00:00:20
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement