See the book - chapter 12, page 250.
It's normal behaviour. There is one bizarre
SQL run if you do the exchange
"without validation" and another (usually cheaper)
if you do it "with validation".
This relates to checking primary and unique
keys, rather than the partitioning constraint.
The solution/workaround is to set the constraints
to a RELY ENABLE NOVALIDATE. But the last
time I checked you still got problems with partitioned
tables in involved in parent/child relationships.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
-----Original Message-----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 11 April 2002 17:17
I'm testing the exchange partition and it's taking 90
seconds to exchange a table containing 700 000 rows
with a partition containing also 700 000 rows.
I've noticed that SYS is doing a crazy select to check
on the PK of the tables even if I used whitout
validation in the exchange statement.
I this normal behavior ?
=====
Stéphane Paquette
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
