Home » RDBMS Server » Server Utilities » running export utility online (Oracle 10g, 10.2.0.4.0, Solaris 8)
running export utility online [message #457788] Wed, 26 May 2010 00:48 Go to next message
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.
Re: running export utility online [message #457790 is a reply to message #457788] Wed, 26 May 2010 00:50 Go to previous messageGo to next message
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
Re: running export utility online [message #457794 is a reply to message #457790] Wed, 26 May 2010 01:00 Go to previous messageGo to next message
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.
Re: running export utility online [message #457798 is a reply to message #457794] Wed, 26 May 2010 01:06 Go to previous messageGo to next message
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.
Re: running export utility online [message #457799 is a reply to message #457798] Wed, 26 May 2010 01:08 Go to previous messageGo to next message
Littlefoot
Messages: 21687
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.
Re: running export utility online [message #457800 is a reply to message #457794] Wed, 26 May 2010 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
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

Re: running export utility online [message #457804 is a reply to message #457799] Wed, 26 May 2010 01:34 Go to previous messageGo to next message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

Thank you very much for this reply!
Re: running export utility online [message #457805 is a reply to message #457799] Wed, 26 May 2010 01:34 Go to previous message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

Thanks for this, it's very helpful...
Previous Topic: Oracle jobs appear to be running but.....
Next Topic: External Table
Goto Forum:
  


Current Time: Fri Sep 17 08:47:31 CDT 2021