How ORA-1555 reported by expdp solved by insert over network
From: sundar mahadevan <sundarmahadevan82_at_gmail.com>
Date: Fri, 20 Apr 2012 12:56:38 -0400
Message-ID: <CADmQEr7-nYQNZiWp05KqdVgfbBsE7ugQVmrjGn3HeaVP5Lfezw_at_mail.gmail.com>
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.
Date: Fri, 20 Apr 2012 12:56:38 -0400
Message-ID: <CADmQEr7-nYQNZiWp05KqdVgfbBsE7ugQVmrjGn3HeaVP5Lfezw_at_mail.gmail.com>
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-lReceived on Fri Apr 20 2012 - 11:56:38 CDT