Re: expdp fails with ORA-31693 and ORA-01555
From: Oliver <ofabelo_at_gmail.com>
Date: Fri, 16 Aug 2013 13:32:10 +0100
Message-ID: <CALQkqm8F+ZAH-W7V4u5FDuPtq9gK4-obNecOUxDJ838G3LS_Nw_at_mail.gmail.com>
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...
Date: Fri, 16 Aug 2013 13:32:10 +0100
Message-ID: <CALQkqm8F+ZAH-W7V4u5FDuPtq9gK4-obNecOUxDJ838G3LS_Nw_at_mail.gmail.com>
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_at_gmail.com>
> 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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 16 2013 - 14:32:10 CEST