Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: great sql-file and how can I run this file...

Re: great sql-file and how can I run this file...

From: thomas <spam.thomas_at_t-online.de>
Date: Fri, 6 Jun 2003 16:52:38 +0200
Message-ID: <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" <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 - 09:52:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US