| Extent allocation problem [message #112288] |
Thu, 24 March 2005 02:29  |
srix5
Messages: 11
Registered: March 2005
Location: Bangalore
|
Junior Member |
|
|
Hi
I have created 5 tablespaces with 5 datafiles in each. I have created a table with 5 partitions
in which data will be stored in appropriate tablespace.
Tablespace1 contains datafiles (000.dbf,001.dbf,002.dbf,003.dbf,004.dbf) for day1 partition
Tablespace2 contains datafiles (000.dbf,001.dbf,002.dbf,003.dbf,004.dbf) for day2 partition
Tablespace3 contains datafiles (000.dbf,001.dbf,002.dbf,003.dbf,004.dbf) for day3 partition
Tablespace4 contains datafiles (000.dbf,001.dbf,002.dbf,003.dbf,004.dbf) for day4 partition
Tablespace5 contains datafiles (000.dbf,001.dbf,002.dbf,003.dbf,004.dbf) for day5 partition
Only one table shares all these tablespaces.
I inserted data upto day2 partitions only. I have not inserted data for other 3 partitions. But
i find some extents have been allocated for a particular datafile (ie 002.dbf) which i have never
inserted data for it (ie for tblspace 3,4,5).
Particularly datafile 002.dbf has been allocated extents for all other tablespaces 3,4,5. But
000.dbf,001.dbf,003.dbf,004.dbf has not been allocated any extents. I have selected count(*) from
those partitions but it retured 0. I am sure that there is only one table is sharing these
tablespaces. I want to know who is using this particular datafile and how to resolve this problem.
Thanks in advance.
|
|
|
|
| Re: Extent allocation problem [message #112338 is a reply to message #112288] |
Thu, 24 March 2005 08:43  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
I'd need to see your create table, create tablespace, and insert statements to know for sure, but it soounds like you need to read the Oracle concepts guide to get a better understanding of what tablespaces, datafiles, and partitions are. It should clear your confusion right up.
For instance, why do you have 5 datafiles for each tablespace?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
