| Exporting schema using consistent parameter [message #562787] |
Sun, 05 August 2012 04:36  |
 |
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  |
 |
Michel Cadot
Messages: 68421
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 |
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
