2017  Kodetalk | Feedback | Privacy Policy | Terms | About
userimage

how to drop a table completely from oracle database with memory cleanup

I need to delete a table and its namespace including memory cleanup. How to do this in oracle database?

userimage

Try using the drop storage including the delete query in oracle database.

For example

DROP table <TABLENAME> <CONDITION IF ANY> DROP STORAGE
DROP table <TABLENAME> <CONDITION IF ANY> PURGE
Answer is