Partition parameters (help needed) [message #192671] |
Wed, 13 September 2006 04:03 |
dendroid66
Messages: 4 Registered: September 2006 Location: Belgium
|
Junior Member |
|
|
Hello,
A question regarding ORACLE partitions.
I have a table partitioned by range (key is snpupdt).
After analyzing the table I've got some results (see the attached
file).
ANALYZE TABLE ticket_p ESTIMATE STATISTICS;
select * from ALL_TAB_PARTITIONS where table_name='TICKET_P';
For the partitions ECD_12092006 and ECD_13092006 number of empty
blocks is zero, but the number of rows is different. It is impossible
to insert any new rows (ORA-01688).
It seems that the data inside these two partitions doesn't use all
datafile space (62 Mb) (see addLogEventTable.sql for deteails).
Do you know how to manage tablespace (or partition ) parameters
that each partition could use all tablespace?
|
|
|
|
|