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: TurkBear <john.greco_at_dot.state.mn.us>
Date: Fri, 06 Jun 2003 10:09:27 -0500
Message-ID: <4jb1ev4ilhbi90hto64b4vs0a8b90pbai8@4ax.com>

I believe your file contains insert statements AND the data to insert..( hence the huge size)

You would be better off using Oracle's exp/imp functions to move this amount of data..

"thomas" <spam.thomas_at_t-online.de> wrote:

>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
>
>

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Fri Jun 06 2003 - 10:09:27 CDT

Original text of this message

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