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

Thread: datafile resize

  1. 04-16-2001, 02:33 PM #1
    dorothy
    dorothy is offline Junior Member
    Join Date
    Oct 2000
    Posts
    90
    I allocated a lot of space(1200m) to a tablespace. Only 500m was used so I want to resize the datafile to 520m. When I checked the extents column from dba_segments I realized that the tablespace has 3 extents. I'm thinking of making it one extent before I resize the datafile.
    Is it a good idea to do that? Or I can resize it to 520m with no problem?

    NOTE: I'm in DSS environment and nothing more is going to be added to the segments in the tablespace. the tablespace and segments are static.
    Reply With Quote Reply With Quote
  2. 04-16-2001, 02:35 PM #2
    jdorlon
    jdorlon is offline Senior Member
    Join Date
    Nov 2000
    Posts
    344
    If you are sure that the table is not going to grow to another extent then no problem, shrink your datafile.

    If the table DOES need to extend, then the worst thing that will happen is that you will get an error mesage saying that there is no room for the next extent. Then you can just resize it again..


    -John
    Reply With Quote Reply With Quote
  3. 04-16-2001, 02:36 PM #3
    Halo
    Halo is offline Moderator
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    You should be able to resize it w/o any problems.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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

Click Here to Expand Forum to Full Width