Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: great sql-file and how can I run this file...
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" <spam.thomas_at_t-online.de> wrote in message
news:bbq9t5$tq5$02$1_at_news.t-online.com...
> thanks for the answer.
> and how is the best way to cut the file ??
>
> :-) thomas
>
> "Scott Mattes" <Scott_at_TheMattesFamily.ws> schrieb im Newsbeitrag
> news:Xa1Ea.1046$Jw6.760269_at_news1.news.adelphia.net...
> > Split it into bite size chunks, say 100M each, and put a commit at the
end
> > of each one.
> >
> > "thomas" <spam.thomas_at_t-online.de> wrote in message
> > news:bbo4en$7uv$00$1_at_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
> > >
> > >
> > >
> >
> >
>
>
Received on Fri Jun 06 2003 - 10:55:22 CDT