Home » RDBMS Server » Backup & Recovery » Export
Export [message #229131] Thu, 05 April 2007 08:57 Go to next message
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.
Re: Export [message #229137 is a reply to message #229131] Thu, 05 April 2007 09:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: Export [message #229141 is a reply to message #229131] Thu, 05 April 2007 09:18 Go to previous messageGo to next message
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
Re: Export [message #229151 is a reply to message #229137] Thu, 05 April 2007 09:49 Go to previous messageGo to next message
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.
Re: Export [message #229152 is a reply to message #229131] Thu, 05 April 2007 09:53 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
In Oracle Readers do NOT block Writers & Writers do NOT block Readers.
Re: Export [message #229153 is a reply to message #229152] Thu, 05 April 2007 09:57 Go to previous messageGo to next message
moody1
Messages: 15
Registered: March 2007
Junior Member
Thanks. May I ask were you read that from?
Re: Export [message #229154 is a reply to message #229131] Thu, 05 April 2007 10:01 Go to previous message
BlackSwan
Messages: 25046
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:
  


Current Time: Thu Dec 08 16:40:24 CST 2016

Total time taken to generate the page: 0.12239 seconds