RE: Oracle partition key update question

From: David Kurtz <info_at_go-faster.co.uk>
Date: Sun, 4 Jul 2004 23:37:21 +0100
Message-ID: <CKEAJBMGFEOCDBFILPJDOEBBEDAA.info@go-faster.co.uk>

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.

eg. If you partition Payroll result tables by employee ID, and then you need to correct the employee ID, you update the EMPLID column in every table in the database, and thus you could cause the rows in the payroll result tables to move between partiitions (the name of the vendor that delivers core functionality to permit such updates has been witheld).

regards

David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:david.kurtz_at_go-faster.co.uk
web: www.go-faster.co.uk
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Warren Homer Sent: 04 July 2004 20:42
To: oracle-l_at_freelists.org
Subject: Oracle partition key update question

Hi,

is it possible in Oracle 9i to update a column in the partition key that causes the record to change from one partition to another.

Thanks.
Warren.

Get a Credit Card - 60 sec online response: http://ad.au.doubleclick.net/clk;8097459;9106288;b?http://www.anz.com/aus/pr omo/qantas5000ninemsn

[AU only]

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Sun Jul 04 2004 - 17:34:13 CDT