OraFAQ Forum: Backup & Recovery » Effect of insert on export (expdp)

Home » RDBMS Server » Backup & Recovery » Effect of insert on export (expdp) (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Effect of insert on export (expdp) [message #551625]

Thu, 19 April 2012 13:57

manubatham20
Messages: 562
Registered: September 2010
Location: Seattle, WA, USA

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

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

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

manubatham20
Messages: 562
Registered: September 2010
Location: Seattle, WA, USA

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

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

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

Littlefoot
Messages: 21648
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 20 14:41:57 CST 2021