Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL loader and truncate drop storage clause

lesakMar 3 2009 — edited Mar 3 2009

Hi,

I check that during load data via sqlloader like that:

LOAD DATA
TRUNCATE
INTO TABLE TEMP_TABLE
FIELDS TERMINATED BY ","
(id,
text
)

it use reuse storage in truncate command. Is there any way to set truncate with drop storage option?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2009

Added on Mar 3 2009

#general-database-discussions

3 comments

987 views