Home » RDBMS Server » Server Utilities » CONSISTENT versus OBJECT_CONSISTENT in EXP (oracle10g)
CONSISTENT versus OBJECT_CONSISTENT in EXP [message #399304] Tue, 21 April 2009 08:56 Go to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Hello, I am posting this question after read the oracle doc..
I just need small clarification in export parameter.

Please correct me if i am wrong here.

EXP CONSISTENT =Y

This parameter set SET TRANSACTION READ ONLY begning of the export.
It will reset only after completing the export. so the entire export
will be done on READ ONLY MODE.


EXP OBJECT_CONSISTENT=Y

This parameter set SET TRANSACTION READ ONLY for begining of the table and ends on
end of the table export. It sets the
TRANSACTION READ ONLY for each table seperately...


Re: CONSISTENT versus OBJECT_CONSISTENT in EXP [message #399521 is a reply to message #399304] Wed, 22 April 2009 13:30 Go to previous message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Any response is highly appreciated...
Previous Topic: SQLLoader(DIRECT=FLASE, PARALLEL=TRUE)
Next Topic: Conventional path in SQLLoader
Goto Forum:
  


Current Time: Fri Mar 29 00:43:46 CDT 2024