| sqlldr: Replace or Truncate [message #71778] |
Thu, 09 January 2003 23:53  |
Deborah
Messages: 18
Registered: June 2002
|
Junior Member |
|
|
Hi,
in sqlloader, I have to clean up one table before
loading fresh data.
Which one is better option in the control file?
TRUNCATE INTO TABLE ITM_MSTR_TEMP
OR
REPLACE INTO TABLE ITM_MSTR_TEMP
And why?
TIA,
Debby
|
|
|
|
| Re: sqlldr: Replace or Truncate [message #71779 is a reply to message #71778] |
Fri, 10 January 2003 02:39  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
actaully,
even if you specify replace,
an internal truncate is used by sql*loader is different (it will re-use tables extents) and is slower (a bit...not a big difference unless it is a real huge table).
I prefer to truncate the table before loading the data
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
