OraFAQ Forum: Server Utilities » running export utility online

Home » RDBMS Server » Server Utilities » running export utility online (Oracle 10g, 10.2.0.4.0, Solaris 8)

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

running export utility online [message #457788]

Wed, 26 May 2010 00:48

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

To DBA Masters,
Just want to confirm if I can run the export (command line) even if the database is up (online)? Are there any risks/impact while doing so?

Thanks alot.

Report message to a moderator

Re: running export utility online [message #457790 is a reply to message #457788]

Wed, 26 May 2010 00:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

reym21 wrote on Tue, 25 May 2010 22:48

To DBA Masters,
Just want to confirm if I can run the export (command line) even if the database is up (online)? Are there any risks/impact while doing so?

Thanks alot.

no risk

Report message to a moderator

Re: running export utility online [message #457794 is a reply to message #457790]

Wed, 26 May 2010 01:00

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Thanks Sir for your prompt reply...
but if in case that there are simultaneous transactions (updates) going with the database while the export is running? How do the export utility extract the rows of the table? Would it get the recent updates or the previous?
Thanks again.

Report message to a moderator

Re: running export utility online [message #457798 is a reply to message #457794]

Wed, 26 May 2010 01:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How do the export utility extract the rows of the table?
Reliably

>Would it get the recent updates or the previous?
Recent or previous relative to what?
It is a point in time snapshot & you can not dictate the point in time.

Report message to a moderator

Re: running export utility online [message #457799 is a reply to message #457798]

Wed, 26 May 2010 01:08

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I guess you'd be interested in the CONSISTENT parameter:Quote:

You should specify CONSISTENT=y when you anticipate that other applications will be updating the target data after an export has started.

More information.

Report message to a moderator

Re: running export utility online [message #457800 is a reply to message #457794]

Wed, 26 May 2010 01:09

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ risk: you add some load on the server, so there is a risk
2/ concurrency: it depends on the value of parameter "consistent" you give

See Database Utilities for more information.

Regards
Michel

[Updated on: Wed, 26 May 2010 02:24]

Report message to a moderator