Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2011

    Unanswered: 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

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Documentation says:
    When you drop a user, Oracle Database also purges all of that user's schema objects from the recycle bin.
    There's some reading in this Ask Tom's discussion about "drop user".

    Why is that so? I wouldn't know; most probably because Oracle programmed it that way. Why? Ask them.

  3. #3
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3
    Just a guess:
    Every Oracle object has an owner. When you drop an user, all its objects would remain orphane if not dropped.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts