Re: DATAFILE??
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: jim_kennedy@xxxxxxxxxx
- Date: Thu, 20 Oct 2005 11:29:45 +0100
On 10/18/05, oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
wrote:
>
> The best way to find out is to try it. You will probably find that it
> depends. If you use a LMT and do uniform extents then it will do it by
> concatenation. (fill up the first file then move on to the 2nd etc.).
> If you create an LMT and do automatic extents then it is different. It
> does it by striping. The first extent goes in the first file, the 2nd
> in the 2nd file...
>
> You can see this by setting up a small test.
> Jim
Unfortunately, if you run the test you'll find that your assertion isn't
correct on 10gR1 :)
1 create tablespace demo
2 datafile 'c:\temp\demo01.dbf' size 10m,'c:\temp\demo02.dbf' size 10m
3* extent management local uniform size 128k
USER @ orcl>/
Tablespace created.
USER @ orcl>create table t1(c1 number);
create table t1(c1 number)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
USER @ orcl>create table demo(c1 number);
Table created.
USER @ orcl>drop table demo;
Table dropped.
USER @ orcl>create table demo(c1 number)
2 tablespace demo;
Table created.
USER @ orcl>alter table demo allocate extent;
Table altered.
USER @ orcl>alter table demo allocate extent;
Table altered.
USER @ orcl>alter table demo allocate extent;
Table altered.
USER @ orcl>alter table demo allocate extent;
Table altered.
USER @ orcl>alter table demo allocate extent;
Table altered.
USER@ orcl>alter table demo allocate extent;
Table altered.
USER @ orcl>select file_id,count(*)
2 from dba_extents
3 where segment_name='DEMO'
4 group by file_id;
FILE_ID COUNT(*)
---------- ----------
9 4
10 3
2 rows selected.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Other related posts:
