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

Mladen,

I'd first blame workspace manager.
Seriously.
I hit this yesterday.
If this is a database upgraded from 9.2 or even one that was created on a base release but which major patchsets have been applied - there is an excellent chance that the version of workspace manager is behind and is hosing expdp and/or export.
Sorry that this has nothing to do with LOBs. I'll bet that you're not sorry that this has nothing to do with LONG RAWs.

No data dictionary scripts required here. All right, I'll use one:

col comp_id format a10
col comp_name format a35
col version format a10
select comp_id, comp_name, version, status from dba_registry
order by 1;

COMP_ID    COMP_NAME                           VERSION    STATUS
---------- ----------------------------------- ---------- ------
CATALOG    Oracle Database Catalog Views       10.1.0.4.0 VALID
CATJAVA    Oracle Database Java Packages       10.1.0.4.0 VALID
CATPROC    Oracle Database Packages and Types  10.1.0.4.0 VALID
CONTEXT    Oracle Text                         10.1.0.4.0 VALID
EM         Oracle Enterprise Manager           10.1.0.4.0 VALID
EXF        Oracle Expression Filter            10.1.0.4.0 VALID
JAVAVM     JServer JAVA Virtual Machine        10.1.0.4.0 VALID
ORDIM      Oracle interMedia                   10.1.0.4.0 VALID
OWM        Oracle Workspace Manager            10.1.0.6.0 VALID
XDB        Oracle XML Database                 10.1.0.4.0 VALID
XML        Oracle XDK                          10.1.0.4.0 VALID

Paul

On 12/20/06, Mladen Gogala <mgogala_at_vmsinfo.com> wrote:
>
> 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> 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
>
>
>

-- 
-- ALTER SESSION SET EVENTS 'immediate trace name hanganalyze level 4';

--
http://www.freelists.org/webpage/oracle-l