Results 1 to 2 of 2

Thread: Does oracle not move tables to recyclebin in case of drop user ?

  1. #1
    Join Date
    Oct 2009
    Posts
    6

    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

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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
  •