RE: Oracle partition key update question

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@xxxxxxxxxxxxxxx
web: www.go-faster.co.uk
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Warren Homer
Sent: 04 July 2004 20:42
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: