OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Export

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

Export [message #229131]

Thu, 05 April 2007 08:57

moody1
Messages: 15
Registered: March 2007

Junior Member

I'm thinking that running an export would affect other users of the database trying to access those tables being exported - can someone point me to documentation concerning?

Export is of a single user, full=n direct=y.

Thank you.

Report message to a moderator

Re: Export [message #229137 is a reply to message #229131]

Thu, 05 April 2007 09:13

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Not sure what you are looking into.
>>users of the database trying to access those tables being exported
You do not want to export by that time then!.
I would use CONSISTENT=Y.
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1005615

Report message to a moderator

Re: Export [message #229141 is a reply to message #229131]

Thu, 05 April 2007 09:18

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,
'm thinking that running an export would affect other users of the database trying to access those tables being exported
No,
and about documenation..."Mahesh" already point you...

Regards
Taj

Report message to a moderator

Re: Export [message #229151 is a reply to message #229137]

Thu, 05 April 2007 09:49

moody1
Messages: 15
Registered: March 2007

Junior Member

We have a job that runs longer then expected and I am looking into all the various factors that may affect it. One thing I found was that we have an export that is running when they kick off their job. So I was trying to find documentation that explains or demonstrates locks etc. during an export.

Report message to a moderator

Re: Export [message #229152 is a reply to message #229131]

Thu, 05 April 2007 09:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

In Oracle Readers do NOT block Writers & Writers do NOT block Readers.

Report message to a moderator

Re: Export [message #229153 is a reply to message #229152]

Thu, 05 April 2007 09:57

moody1
Messages: 15
Registered: March 2007

Junior Member

Thanks. May I ask were you read that from?

Report message to a moderator

Re: Export [message #229154 is a reply to message #229131]

Thu, 05 April 2007 10:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.wisc.edu/drmt/oratips/sess004.html

Concurrency
Readers don't block readers.

Readers don't block writers.
Note: SELECT ... FOR UDPATE behaves as a writer

Writers don't block readers.

Plus many others from GOOGLE!
Results 1 - 10 of about 781,000 for Oracle Readers do NOT block Writers & Writers do NOT block Readers

[Updated on: Thu, 05 April 2007 10:04] by Moderator

Report message to a moderator

Previous Topic:	How set the one home(oracle8i) on windows.
Next Topic:	Taking Export without Materialized Views

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 20:13:48 CST 2024