DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    Extent Allocation Sequence

    I have two datafile in a tablespace of 2gb each
    Both of files set to autoextend ,One of the file is going to be 100% full but another newly created datafile is not used yet

    My Question Is?
    When an extent in that particular tablespace needed to be allocated
    and first datafile is 100% used
    what will be sequence?
    Either it'll extend the first file or extent will be allocated from a newly created datafile

    And when both of files are 100% full and what will happen then?

    Thanx in advance

  2. #2
    Join Date
    Sep 2002
    try it, see what happens.

    It's called learning

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.