| Re: export and consistent=Y [message #368065] |
Tue, 15 February 2000 06:10 |
Thomas
Messages: 67
Registered: September 1999
|
Member |
|
|
Hi Brian,
A1:Yes, consistant=y is a MUST if you export an DB while users are connected and working. Otherwise its not guaranteed that all Data is Consistant. Because it slowes the Export down you should export a big DB without this flag but without users connected.
Direct means that Oracle does not need to put the Data through the SGA, this speeds up every Export/Import for 200 - 500 %. So since it is
available I never used the conventional Path.
Q2: I do not understand what this means. Propably it has to do with the Locking that has to be used for consistant export.
Hope that helped a bit
regards thomas
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
