RE: expdp and clob ... any tricks to speed up?
- From: "Mladen Gogala" <mgogala@xxxxxxxxxxx>
- To: <rjamya@xxxxxxxxx>, "'Oracle Discussion List'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 20 Dec 2006 16:06:41 -0500
Here is one way of speeding things up:
Export: Release 10.2.0.3.0 - Production on Wednesday, 20
December, 2006 15:58:21
Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release
10.2.0.3.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": parfile=exp.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
;;; Export> EXIT_CLIENT
Total estimation using BLOCKS method: 167.0 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type
SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
ORA-39125: Worker unexpected fatal error in
KUPW$WORKER.UNLOAD_METADATA while ca
lling KUPF$FILE.WRITE_LOB []
ORA-19502: write error on file
"/ODATA/oradata/news/news_archive.dmp", blockno 5
(blocksize=4096)
ORA-27061: waiting for async I/Os failed
Linux Error: 6: No such device or address
Additional information: -1
Additional information: 4096
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6228
----- PL/SQL Call Stack -----
object line object
handle number name
0x59641804 14916 package body SYS.KUPW$WORKER
0x59641804 6293 package body SYS.KUPW$WORKER
0x59641804 2339 package body SYS.KUPW$WORKER
0x59641804 6854 package body SYS.KUPW$WORKER
0x59641804 1259 package body SYS.KUPW$WORKER
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal
error at 15:59:33
ORA-39014: One or more workers have prematurely exited.
This has completed really quicky, performance was great. I'm
about to congratulate Oracle by opening a TAR.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of rjamya
Sent: Wednesday, December 20, 2006 3:37 PM
To: Oracle Discussion List
Subject: expdp and clob ... any tricks to speed up?
I have couple of tables that take long time to export using
expdp (10gr1 db) because they have a clob in them. Are there
any tricks to speed that up? parallel is of no use it won't
use it.
ummm .. same with impdp ?
TIA
Rjamya
----------------------------------------------
Got RAC?
Other related posts:
