Re: expdp fails with ORA-31693 and ORA-01555
From: rjamya <rjamya_at_gmail.com>
Date: Fri, 16 Aug 2013 07:57:22 -0400
Message-ID: <CAGurbTOXwYKABGia9cbp4hZWLZbeKPPX-9gA86sx0QvD-FLzgQ_at_mail.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
Date: Fri, 16 Aug 2013 07:57:22 -0400
Message-ID: <CAGurbTOXwYKABGia9cbp4hZWLZbeKPPX-9gA86sx0QvD-FLzgQ_at_mail.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 - 13:57:22 CEST