Hi, "insert into" will try to do that in one transaction, which will run out of memory. Try the following:
create table test as select * from test_link; You can also set the column names and types: create table test(id int, name varchar) as select a, b from test_link; Regards, Thomas On Tue, Feb 10, 2009 at 10:57 AM, Gilles <[email protected]> wrote: > > Hello, > > I'm trying to import data from an existing MS Access database into H2. > Trying to use "save as" from Access gives me an error for Timestamptz > format (?), so I tried linking all tables from H2 and "insert into" > the corresponding tables. But then I get a Java OutOfMemoryError. My > table is 15,199,760 records long. Is this normal? Is this a limitation > of H2? Should I move to another engine? > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
