-
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
-
You can't drop a user if it owns any objects unless you specify CASCADE option.
After user is dropped you can't recover it from recyclebin.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|