Re: SQL-LOADER, UNIX ascii file 1.2M liness takes more than 2 days..HELP!

From: PATTER <rodney.patterson_at_norfolkva.ncr.com>
Date: 1996/06/11
Message-ID: <DsuHwp.DEH_at_avenger.daytonoh.ncr.com>#1/1

==========Marc Shewring, 6/8/96========== Hi there I am traying to load in data using sql-loader under SUNOS 4.1.3.u on a Sparc20 and the load is taking forever. Admitedly the file is big 1.2 Million lines and there are only 4 fields on each line. Is there a faster way of getting this nav-data into oracle?

Are your log files and system on a different disk than your data?

Increase the size of your rollback segments

I didn't do it, nobody saw me, you can't prove it! BART Received on Tue Jun 11 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Murthy Patamalla: "Re: few questions from a beginner"
Previous message: Glen Case : "Re: SQL-LOADER, UNIX ascii file 1.2M liness takes more than 2 days..HELP!"
In reply to: Marc Shewring: "SQL-LOADER, UNIX ascii file 1.2M liness takes more than 2 days..HELP!"
Next in thread: Murthy Patamalla: "Re: few questions from a beginner"
Reply: Brian M. Biggs: "Re: SQL-LOADER, UNIX ascii file 1.2M liness takes more than 2 days..HELP!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message