| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle partition key update question
How does it update in situ?
Waleed
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]=20
Sent: Monday, July 05, 2004 1:54 AM
To: oracle-l_at_freelists.org
Subject: Re: Oracle partition key update question
The overhead is slightly worse than that. Oracle updates in situ, then deletes and inserts.
It's especially unpleasant if you've prefixed all your local indexes.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st
Yes, and since at least Oracle 8.1, if you create the table with, or
enable
'ROW MOVEMENT' on the record.
Of course, there is an additional overhead to doing this, you are effectively doing a delete and insert, but if you have a packaged application that does silly things you may need to do this.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |