On Tue, 2 Mar 2004 09:17 , 'Schildberg, Steffen' <[EMAIL PROTECTED]> sent:
>Hi Stephen, > >> Please do! It would be great to have the ability to snapshot >> production data only specific tables without down time or >> having to do a full backup. Right >> now, the only method I know of would be to work with SQL >> SELECT and build our own 'loadercli' type tool, correct? >> >Yes, partially correct. At the moment there is no way to avoid the >table locks on extracting/loading a specific table. [snip] >Best regards, > Steffen >-- >Steffen Schildberg >SAP DB Team >SAP Labs Berlin Ok... on the coat-tails of the recent discusison of 'update statistics' doing a lock... has further consideration been given to changing loadercli so that a extract (SELECT) does not lock the tables? Some option to set the isolation level? Do you need someone to test the revised loadercli :) ? Thank you. Stpehen Gutknecht full time traveler... currently in Phoenix Arizona USA heading to Dallas, Texas soon... -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
