Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Unanswered: reducing the size

    we have a test db installation and have created all the users in the system tablespace. now the disk space is full and thought of dropping unwanted user by "Drop user <name> cascade" command. However the size is not reduced. Please advise me on the disk cleanup.

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    DROP USER will not release the physical disk space, it will only release the segments in the tablespace(s) that are occupied by that user's objects (for example, increase the free space in the tablespace).

    PS: To reduce the physical space, you need to re-size the files.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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