Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news3.optonline.net!rip!news.webusenet.com!router1.news.adelphia.net!news1.news.adelphia.net.POSTED!not-for-mail From: "Scott Mattes" Newsgroups: comp.databases.oracle.misc References: Subject: Re: great sql-file and how can I run this file... Lines: 24 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: Date: Fri, 06 Jun 2003 14:03:35 GMT NNTP-Posting-Host: 68.65.40.201 X-Complaints-To: abuse@adelphia.net X-Trace: news1.news.adelphia.net 1054908215 68.65.40.201 (Fri, 06 Jun 2003 10:03:35 EDT) NNTP-Posting-Date: Fri, 06 Jun 2003 10:03:35 EDT Xref: core-easynews comp.databases.oracle.misc:98444 X-Received-Date: Fri, 06 Jun 2003 07:02:52 MST (news.easynews.com) Split it into bite size chunks, say 100M each, and put a commit at the end of each one. "thomas" wrote in message news:bbo4en$7uv$00$1@news.t-online.com... > hello all, > > I've a great sql-file with 1.2 GigaByte (GB!). > in this file (created with toad and export data) are only insert-statments. > > how can I insert thís in the database. I use a workstatio with PIII-Xeon and > 768 mb ram and after some hours the sql-script crashed in sqlplus or toad. > > thanks for any hints / tips.... > > > :-) thomas, germany > > >