OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » oracle export (oracle 8i,unix)

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

oracle export [message #291865]

Mon, 07 January 2008 01:49

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

Report message to a moderator

Re: oracle export [message #291870 is a reply to message #291865]

Mon, 07 January 2008 02:01

Michel Cadot
Messages: 68770
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

Report message to a moderator

Re: oracle export [message #291911 is a reply to message #291870]

Mon, 07 January 2008 03:46

kumarpavan
Messages: 3
Registered: January 2008
Location: India

Junior Member

Thanks Michel. Thanking you for your prompt message.

Report message to a moderator

Previous Topic:	Number (10,5)
Next Topic:	Getting date from header of csv and load it to a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 05 21:17:15 CDT 2025