🎴 Flashcard Mode
Oracle Database and JDBC Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
What is the use of reuse storage clause when used with truncate table statement?
AnswerClick to flip back
A
specifies that the empty space created by deleting the records must be retained for this table and should not be used by other tables
💡 Explanation:
The REUSE STORAGE clause in TRUNCATE specifies that the space freed by deleting rows remains allocated to the table (kept in its tablespace). The default DROP STORAGE would return that space to the tablespace for other tables to use. TRUNCATE cannot be rolled back.