Oracle drop table cascade and release the space

DROP TABLE user_names CASCADE CONSTRAINTS PURGE


this to release the space of table when you drop it in one sentence


yasser