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:03:35 CDT
