Re: Datapump export error
- From: "Keith Moore" <kmoore@xxxxxxxxxxxx>
- To: rjamya@xxxxxxxxx
- Date: Mon, 11 Mar 2013 08:28:14 -0500
One of my DBAs created the parameter file. I didn't even notice it was 10GB
instead of 10G.
Yes, we were using FLASHBACK_TIME and that worked fine. The export completed
after approximately 20 hours and there were no issues with UNDO (which we
watched closely). Space was tight but in the end, there was no need to
compress the files so this became a non-issue.
The issue was that files were accessed (read?) after they had reached the 10GB
limit. In other words, with PARALLEL=8, the first 8 files were created, files
9-16 were created and all were 10 GB but then while writing to files 17-24,
expdp went back and tried to open file # 5 which had already been compressed.
Another lister responded privately that she had seen the same issue where the
"completed" files were accessed again at the very end of the export.
Looks like in 10g Oracle covered all their bases to make sure there was no way
to compress datapump export files (no compress option, no compress to named
pipe, no manual compress) :-(
Keith
> With PARALLEL, each worker process will access one file at a time. So,
> assuming your LOB table is larger than 10G, and LOB accesses are always
> slow, I hazard a guess that gzip started after file reached about 10g, but
> before next set of rows fetched by worker process. The new file creation
> happens *when* worker process tries to write and finds that you have
> reached max limit and then it will create a new file and continue.
> if I were to gzip, I'd wait until next file is created and only then start
> gzipping.
>
> "ORA-08180: no snapshot", have you looked at this error yet? you are
> specifying flashback_time, so is undo_retention large enough to account for
> all the time since flashback time specified and current expdp time? LOBS
> normally take too long, so perhaps you could try adding
> access_method=external_table
> might help, YMMV.
>
> Also i didn't know FILESIZE accepted 10GB, I always thought it should be
> 10G, i.e. sans the B, something new to know.
>
> Raj
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
