Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL loader and truncate drop storage clause

Tom StaresinicMar 19 2024 — edited Mar 19 2024

Comment to “https://forums.oracle.com/ords/apexds/post/sql-loader-and-truncate-drop-storage-clause-0172”

Person “678145 ” said “… TRUNCATE statement …Deallocates all space used by the removed rows … http://download.oracle.com/docs/….”

I say: That quote might be true for SQL Loader TRUNCATE mode if SQL Loader is executed with the “Direct-pathload” command line option (because direct load always load above the High Water Mark) . Whereas, again my guess, in “Conventional ”.mode (i.e. SQL INSERTs), the TRUNCATE might NOT deallocate. (i.e. it might implicitly “REUSE STORAGE”)

Comments
Post Details
Added on Mar 19 2024
0 comments
186 views