Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie DBA: Data files and externts
Hi Paul,
Oracle won't do anything with the datafile as long as there are no segments
in it.
There are two types of initial extent:
the explicit one, which you specify when you create a table/index, in the
create statement.
If you don't specify an initial extent the implicit initial extent is derived
from the initial extent of the default storage clause of the tablespace.
In Oracle7 the dba_extents view will show you which extents are in what file.
Hth,
Sybrand Bakker, Oracle DBA
Paul Simmons wrote:
> Just trying to determine a suspision.
>
> When adding a datafile to a tablespace, does Oracle create and extent the
> size of your defined initial_extent in the file ?
>
> If no ... how do you determine what file your allocated extents are
> associated with?
>
> Thanx in advance.
>
> Regards
>
> Paul Simmons
Received on Tue Feb 16 1999 - 00:01:11 CST