SQL-LOADER, UNIX ascii file 1.2M liness takes more than 2 days..HELP!
From: Marc Shewring <shewring_at_wmcpet.dialix.oz.au>
Date: 1996/06/08
Message-ID: <4pbiq0$qfp_at_tetleys.pet.wmc.com.au>#1/1
Marc Shewring
Received on Sat Jun 08 1996 - 00:00:00 CEST
Date: 1996/06/08
Message-ID: <4pbiq0$qfp_at_tetleys.pet.wmc.com.au>#1/1
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?
regards Marc
Marc Shewring
Information Technology Officer "If you build it... Western Mining Corporation - Petroleum Division They will surf..."
Marc.Shewring_at_p085.aone.net.au
shewring_at_wmcpet.dialix.oz.au
mcs_at_interlink.com.au
Received on Sat Jun 08 1996 - 00:00:00 CEST