Re: expdp fails with ORA-31693 and ORA-01555
- From: Oliver <ofabelo@xxxxxxxxx>
- To: rjamya <rjamya@xxxxxxxxx>
- Date: Fri, 16 Aug 2013 13:32:10 +0100
I'm sorry I'm a newbie and this database instance is not installed by me.
Parallel expdp is not used, so thanks, I will try it.
About next point, yes, many tables save clob/blobs data. Could I use
parallel expdp too for improving it?
I'm not sure how to see current undo retention, I'm sorry. I can see that
it has 2 undo tablespaces with 4 datafiles each tablespace and each
datafile can grow until 4GB maximum.
Thanks beforehand.
Regards...
2013/8/16 rjamya <rjamya@xxxxxxxxx>
> Could you share your expdp command? 130GB taking 7-8 hours probably means,
>
> 1. it could could benefit from parallel expdp (if not used)
> or
> 2. most of your data is in clob/blobs and hence no further optimization is
> possible
>
> I am asking (speculating?) this because, for 130gb, with expdp being used
> in parallel, 7-8 hours seems a bit long unless you have LOBs. Also what is
> your undo retention? is this is a high oltp db?
>
> Raj
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
