Re: How ORA-1555 reported by expdp solved by insert over network
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: "sundarmahadevan82@xxxxxxxxx" <sundarmahadevan82@xxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 20 Apr 2012 13:21:39 -0700 (PDT)
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@xxxxxxxxx>
To: Oracle-L@xxxxxxxxxxxxx
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@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
Other related posts: