help with adding datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: help with adding datafile

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Cool

    I have a tablespace that has a datafile of 400m and out of which 300m has been used.
    Assuming that I add another datafile (of 200m) to the tablespace, is the remaining 100m left from the 300m going to be used before the new 200m that I have added will be used?
    I am thinking that if I go ahead and add the new datafile of 200m, then the 100m that is remaining out of the 400m will not be used.
    Can any one please explain?

    still learning,
    learn

  2. #2
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    Cool

    How much space will be used in the remain 100M in the first datafile is depandant on what's the size of the next extent .

    For example , If Table1 suppose to grow and next extend are 120M , so the 100M is not enough and will not be used .

    Check out the NEXT_EXTENT column in dba_segments view and You will know how the things going on ....

  3. #3
    Join Date
    Nov 2000
    Posts
    169
    thanks for that.

    still learning,
    learn

  4. #4
    Join Date
    Nov 1999
    Posts
    226
    Hi

    The priority of usage will go to the old file only and incase that space is not used for any reason liek extent_size etc or is not in autoextensible mode , then only the new file space will be used

    regards

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