Home » RDBMS Server » Server Administration » Partition parameters (help needed)
Partition parameters (help needed) [message #192671] Wed, 13 September 2006 04:03 Go to next message
Messages: 4
Registered: September 2006
Location: Belgium
Junior Member

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

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?
Re: Partition parameters (help needed) [message #192730 is a reply to message #192671] Wed, 13 September 2006 06:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use dbms_stats for partitioned tables.
use the 'partname' feature.
Look into documentation.
Re: Partition parameters (help needed) [message #192777 is a reply to message #192671] Wed, 13 September 2006 09:19 Go to previous message
Messages: 121
Registered: August 2006
Senior Member
you can use below as template
EXECUTE DBMS_STATS.GATHER_TABLE_STATS (ownname=>'SCOTT',tabname=>'EM',partname=>'P_092006',granularity=>'PARTITION', estimate_percent=>40, cascade=>TRUE);

Previous Topic: oracle for windows and linux
Next Topic: UPPERCASE with accent
Goto Forum:

Current Time: Fri Oct 28 01:52:13 CDT 2016

Total time taken to generate the page: 0.10175 seconds