Space issues
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Space issues

  1. #1
    Join Date
    Aug 2008
    Posts
    117

    Space issues

    Hi all,

    how can i shrink the space used by tablespaces, I have some table reaching to 99% used and want to shrink it.

    how can i make it automated job to shrink if the usage is more than 70%?

    Please help and guide!!

    thanks
    Pat

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Log into your database as sys using sqlplus and run the following file. It will let you know the high water mark of each tablespace and the largest free extent.This should help you to decide if you can shrink your database.

    But before you start shrinking things, you try to do some basic reading to get a better understanding of space management in Oracle.

    Unplanned shrinkage is usually bad!!!
    Attached Files Attached Files
    this space intentionally left blank

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by midora
    Hi all,

    how can i shrink the space used by tablespaces, I have some table reaching to 99% used and want to shrink it.

    how can i make it automated job to shrink if the usage is more than 70%?

    Please help and guide!!

    thanks
    Pat
    and how do you intend to shrink it if the space is used?

Posting Permissions

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



Click Here to Expand Forum to Full Width