-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|