Home » RDBMS Server » Server Utilities » Exporting schema using consistent parameter (oracle 10.2.0 , oel 4.4)
Exporting schema using consistent parameter [message #562787] Sun, 05 August 2012 04:36 Go to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
Hello to everyone ;

I taking export using consistent parameter. Theoretically i can understand .
practically i couldn't understand how it works.

for ex

I am updating tab1 table under sams user. table having one lakh records.
while updating the query using consistent=y and consistent=n. i mean
exp sams/sams file=cons.dmp owner=sams consistent=y
exp sams/sams file=cons2.dmp owner=sams consistent=n

then both files imported to separate user(sam ,san).
Updated info not visible in san and sam user.

I want to know practically how it works. I need perfect example.
while using consistent=y and consistent=n

Thanks in advance
Thiyagusham.G
Re: Exporting schema using consistent parameter [message #562791 is a reply to message #562787] Sun, 05 August 2012 06:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Understand what it is said in documentation:

Quote:
[CONSISTENT] Specifies whether or not Export uses the SET TRANSACTION READ ONLY statement to ensure that the data seen by Export is consistent to a single point in time and does not change during the execution of the exp command.


and

Quote:
If you use CONSISTENT=n, each table is usually exported in a single transaction.


So in BOTH cases, each table is consistent.

Regards
Michel

[Updated on: Thu, 09 August 2012 08:37]

Report message to a moderator

Re: Exporting schema using consistent parameter [message #562793 is a reply to message #562791] Sun, 05 August 2012 06:54 Go to previous message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ michel

Thanks for your reply.
Previous Topic: strange issue in sql loader
Next Topic: trunc function in sql loader
Goto Forum:
  


Current Time: Fri Mar 29 00:08:20 CDT 2024