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.
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
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