Re: How ORA-1555 reported by expdp solved by insert over network

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Fri, 20 Apr 2012 13:21:39 -0700 (PDT)
Message-ID: <1334953299.29366.YahooMailNeo_at_web160902.mail.bf1.yahoo.com>



If the table is subject to updates involving large numbers of rows you may have experienced delayed  block cleanout during the expdp session; once those blocks are 'cleaned' a subsequent select won't suffer the same fate.

David Fitzjarrell



From: sundar mahadevan <sundarmahadevan82_at_gmail.com> To: Oracle-L_at_freelists.org
Sent: Friday, April 20, 2012 10:56 AM
Subject: How ORA-1555 reported by expdp solved by insert over network

Hi All,
Greetings. Recently we were trying to export a frequently updated table using datapump with flashback_scn. It failed with ORA-1555. But when we tried to insert into table as select * from table_at_source as of scn, it worked. So what was happening in the background? I was expecting to receive ORA-1555 with the second approach as well since the select statement is executed on the source. Thanks in advance.

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 20 2012 - 15:21:39 CDT

Original text of this message