On Mon, 2004-02-16 at 09:09, Yonatan Taub wrote: > I've got two tables which have a lot of data in them (about 1,100,000). > The deletion process takes about 15 minutes which is way too long. > "DROP TABLE" is not an option for me so I was looking at alternatives. > The "TRUNCATE TABLE" seems to be faster since it doesn't do any logging. > However, I understand that I have to be in an "Oracle Mode" rather than > "Internal Mode" for this sql statement to succeed. > > My questions are: > - What exactly is "Oracle Mode"? > - How do I enter "Oracle Mode"? > - I'm using JDBC. Do I to do anything specific with it?
google for "sapdb jdbc oracle mode" and you will get your answer. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
