RE: DATAFILE??
- From: "Kennedy, Jim" <jim_kennedy@xxxxxxxxxx>
- To: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- Date: Thu, 20 Oct 2005 07:23:52 -0700
Interesting that they changed it. Looks like they changed it from 9i. Good to
know. Probably better they did.
Jim
-----Original Message-----
From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx]
Sent: Thu 10/20/2005 3:29 AM
To: Kennedy, Jim
Cc: cmarquez@xxxxxxxxxxxxxxxx; Yavor_Ivanov@xxxxxxxx; Oracle Mailing List;
oracle.tutorials@xxxxxxxxx
Subject: Re: DATAFILE??
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:
