Home » RDBMS Server » Backup & Recovery » Effect of insert on export (expdp) (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit)
Effect of insert on export (expdp) [message #551625] Thu, 19 April 2012 13:57 Go to next message
manubatham20
Messages: 307
Registered: September 2010
Location: Noida, India
Senior Member
Hi,

What will be the effect of insert statement on expdp if I am doing full table export?

Thanks,
Manu

Report message to a moderator

Re: Effect of insert on export (expdp) [message #551626 is a reply to message #551625] Thu, 19 April 2012 14:06 Go to previous messageGo to next message
BlackSwan
Messages: 20109
Registered: January 2009
Senior Member
>What will be the effect of insert statement on expdp if I am doing full table export?
It depends upon timing of each & when COMMIT occurred (or not).

Other sessions do not see uncommitted data.

Report message to a moderator

Re: Effect of insert on export (expdp) [message #551628 is a reply to message #551626] Thu, 19 April 2012 14:10 Go to previous messageGo to next message
manubatham20
Messages: 307
Registered: September 2010
Location: Noida, India
Senior Member
What will happen if I committed a transaction and export of the same table is ongoing?

[Updated on: Thu, 19 April 2012 14:10]

Report message to a moderator

Re: Effect of insert on export (expdp) [message #551631 is a reply to message #551628] Thu, 19 April 2012 14:16 Go to previous messageGo to next message
BlackSwan
Messages: 20109
Registered: January 2009
Senior Member
>What will happen if I committed a transaction and export of the same table is ongoing?
It depends upon timing of each & really has little to do with export itself.
It is documented on Concepts Manual regarding Read Consistent View of how Oracle presents data.

Report message to a moderator

Re: Effect of insert on export (expdp) [message #551653 is a reply to message #551631] Fri, 20 April 2012 00:51 Go to previous message
Littlefoot
Messages: 16997
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The original export utility had the CONSISTENT & OBJECT_CONSISTENT parameters (see here). Export data pump doesn't have these any more, but offers FLASHBACK_SCN and FLASHBACK_TIME (see here).

Maybe you'll find interesting Where has consistent=y gone when using Datapump export.

Report message to a moderator

Previous Topic: rman recovery problem
Next Topic: database accidently droped by dbca
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 24 18:06:10 CDT 2013

Total time taken to generate the page: 0.63621 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.