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”)