Home » RDBMS Server » Server Utilities » oracle export (oracle 8i,unix)
icon4.gif  oracle export [message #291865] Mon, 07 January 2008 01:49 Go to next message
kumarpavan
Messages: 3
Registered: January 2008
Location: India
Junior Member
Hi Friends,

Can we take export backup of a production database when users are accessing same? When we import this export dump will there be any issues?

Please provide me a solution for this.

Thanks,
pavan
Re: oracle export [message #291870 is a reply to message #291865] Mon, 07 January 2008 02:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:

Can we take export backup of a production database when users are accessing same?

Yes, use "consistent=yes" and don't use SYS.
export is NOT a backup.

Quote:

When we import this export dump will there be any issues?

Yes if you didn't use "consistent=yes".

But you can also have problem during export as you must have undo segments enough to support the concurrent users activity.

Regards
Michel

Re: oracle export [message #291911 is a reply to message #291870] Mon, 07 January 2008 03:46 Go to previous message
kumarpavan
Messages: 3
Registered: January 2008
Location: India
Junior Member
Thanks Michel. Thanking you for your prompt message.
Previous Topic: Number (10,5)
Next Topic: Getting date from header of csv and load it to a table
Goto Forum:
  


Current Time: Tue Dec 24 23:39:20 CST 2024