 Datafiles [message #162680] |
Mon, 13 March 2006 00:51  |
chara
Messages: 81
Registered: April 2005
Location: th
|
Member |
|
|
hi all,
if i have a datafile is data1.dbf a sizing is 100m.After used a data1.dbf the after it is available 20m.If i add data2.dbf 100m.
1)Is the oracle can came back used a 20m of data1.dbf untill 0m?
2)In the same way If i have many datafiles that available sizing (may be 10m,20m...)
and i add the last datafile .Is the oracle can came back used the sizing of all datafiles that available untill 0m.?
Thks for advance
Chara
|
|
|
|
| Re: Datafiles [message #162758 is a reply to message #162680] |
Mon, 13 March 2006 08:46  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
I'm not sure I understand your question due to the way it was phrased, but oracle can and will use as much space in the datafiles as it can, if it can allocate extents of appropriate size, and pending fragmentation issues. A single object can have multiple extents, each extent being in a different datafile.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
