Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: expdp and clob ... any tricks to speed up?

RE: expdp and clob ... any tricks to speed up?

From: Mladen Gogala <mgogala_at_vmsinfo.com>
Date: Wed, 20 Dec 2006 16:20:35 -0500
Message-ID: <00a701c7247c$b09ecbd0$232b650a@nycwkswxp2829>


Funny thing is that the ordinary export works. The problem is that the schema is a bit fat (160GB), so the export and

Import would take until Christmas 2007. I believ that "data pump" is leaking all over the place and that it will become a

reliable tool in Oracle 12f.  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya Sent: Wednesday, December 20, 2006 4:12 PM To: Mladen Gogala
Cc: Oracle Discussion List
Subject: Re: expdp and clob ... any tricks to speed up?  

Mladen,

come to think of it, it is an OS error, probably not Oracle.

Raj

On 12/20/06, Mladen Gogala < mgogala_at_vmsinfo.com <mailto:mgogala_at_vmsinfo.com> > wrote:

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  

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 20 2006 - 15:20:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US