Does oracle not move tables to recyclebin in case of drop user ?
Hi all,
Oracle does not remove a dropped table permanently from storage when recyclebin is on and table is dropped
without purge option. Table is moved to recyclebin. Dropped table can be recovered from recyclebin using flashbak drop.
In case of drop user does Oracle remove all the objects from database permanently ? What is the role of recyclebin
in drop user case ? Is dropping a user , implies dropping all its objects individually ? Why Oracle does not move
tables to recyclebin in this case ? Please, explain a bit...
Thanks & Regards
Sukhendu