Re: Partitioning problems - Oracle 8.1.7.4

Hi Tony,

> Because I have a global PK index I thought

> that letting the table grow would

> have an adverse affect on performance for this index, so archiving a

> partition off would make sense.

Yes, that is true, but on the other side you loose the control of uniqueness; a duplicated record could be re-entered after archiving the former one.

If you check the unique constraint (i.e. non of the records in the temporary table exists in the partitioned table) *before* each exchange partition (and you move the duplicated records in an exception table before the exchange) you probably don't need the global index at all.

Regards

Jaromir

• Original Message ----- From: <Tony.Adolph_at_o2.com> To: <jaromir_at_db-nemec.com> Cc: <oracle-l_at_freelists.org> Sent: Monday, February 07, 2005 11:14 AM Subject: Re: Partitioning problems - Oracle 8.1.7.4

--
http://www.freelists.org/webpage/oracle-l