Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!c03.atl99!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: 61 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 15:55:22 GMT NNTP-Posting-Host: 68.65.40.201 X-Complaints-To: abuse@adelphia.net X-Trace: news1.news.adelphia.net 1054914922 68.65.40.201 (Fri, 06 Jun 2003 11:55:22 EDT) NNTP-Posting-Date: Fri, 06 Jun 2003 11:55:22 EDT Xref: core-easynews comp.databases.oracle.misc:98449 X-Received-Date: Fri, 06 Jun 2003 08:54:38 MST (news.easynews.com) You can not use any of the free file splitting utilities because you have to make sure that the split occurs between INSERT statements. If you are doing this on your PC, you could use UTL_FILE. But you'll have to mess with setting up directories for reading/writing the files (search these news groups for UTL_FILE and directory). If you have Reports you could use TEXT_IO (same calls as UTL_FILE), but file i/o is on the client's side (your PC). If you have a real pgming language it is a simple pgm to write: read and write lines until ctr gets to desired size then close output file and create another. I could write you a quick and dirty util to do it, but unless you have Delphi you'd have to take my word for it that all it did was what I said. And, if you have Delphi, see the previous para. Maybe you could import it to a spread sheet???? "thomas" wrote in message news:bbq9t5$tq5$02$1@news.t-online.com... > thanks for the answer. > and how is the best way to cut the file ?? > > :-) thomas > > "Scott Mattes" schrieb im Newsbeitrag > news:Xa1Ea.1046$Jw6.760269@news1.news.adelphia.net... > > 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 > > > > > > > > > > > > > > >