Home » RDBMS Server » Server Utilities » Re: export and consistent=Y
Re: export and consistent=Y [message #368065] Tue, 15 February 2000 06:10
Messages: 67
Registered: September 1999
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
Previous Topic: Export Question !
Next Topic: Writing data from oracle tables into ascii files...
Goto Forum:

Current Time: Fri Feb 03 17:16:42 CST 2023