Help: Bulk load with direct=true, out of space
From: Robin Rosenberg <robin_at_rosenbergit.se>
Date: Mon, 12 Apr 1999 21:33:30 GMT
Message-ID: <371266B4.EF87268_at_rosenbergit.se>
Date: Mon, 12 Apr 1999 21:33:30 GMT
Message-ID: <371266B4.EF87268_at_rosenbergit.se>
I'm trying to load 5 million rows into a table using SQL*Loader and it
is slow as hell so I tried using
direct=true. But at the end of the load (when creating the indices) it
says something like
cannot extend segment temp in tablespaces system.
Why isn't it using the tablespace that I have assigned as the default
tablespace? It is
definitiely big enough.
It seems I have to configure something, but what?
-- Robin Rosenberg | Voice: +46-708-305342 | "Any opinions are my own, etc. etc."3 Copyright © 1999 | ICQ#: 4058565 | <this line left blank> Rosenberg IT AB | Mail: robinr_at_acm.org |Received on Mon Apr 12 1999 - 23:33:30 CEST