Home » RDBMS Server » Server Administration » Extent Allocation Sequence
Extent Allocation Sequence [message #204296] Mon, 20 November 2006 00:51 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
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
Re: Extent Allocation Sequence [message #204362 is a reply to message #204296] Mon, 20 November 2006 05:57 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/logical.htm#i4896
Previous Topic: Integrity constraints while migrating
Next Topic: A gift for all DBA's
Goto Forum:
  


Current Time: Fri Dec 09 05:49:47 CST 2016

Total time taken to generate the page: 0.24204 seconds