| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Loader and the truncate command
That is interesting. Coincidentally, I was reading up on the
TRUNCATE command in the manual just two days ago. To my
surprise, there is a REUSE STORAGE option that causes a
table to be truncated in a way that preserves the extents.
Somehow I'd never seen that option before. That must be what
SQL*Loader is doing--TRUNCATE table REUSE STORAGE.
Jonathan
On Mon, 21 Aug 2000 13:06:13 -0800, you wrote:
>Howdy,
>
> I just learned something that maybe the rest of you already know. =
But if
>not, I thought I'd share it with you. In the Utilities Manual, it says =
that
>if you use the TRUNCATE option in your SQL*Loader control file, it will =
use
>the SQL TRUNCATE command. Actually, that isn't entirely true. It works
>differently. The SQL TRUNCATE command, if executed within sqlplus, will
>clean up all the extents and you will have just the initial extent when
>done. However, SQL*Loader will not do that. If you had 200 extents =
before,
>you will still have 200 when the table has been loaded. I was expecting
>these to be cleaned up and they weren't. Just thought you might like to
>know.
>
>Bill Carle
>Database Management
Received on Mon Aug 21 2000 - 17:25:48 CDT
 |
 |