Updating partition key

Is there a way to update a partition key of a table, where the table is partitioned by range in oracle 8.
Can any body help me pls.
shankar

[Edited by sbala on 03-16-2001 at 02:33 PM]

AFAIK you can update the partition key as long as the new key still fits in the partition range of it's current partition. If I'm not mistaken, even this limitation is no longer valid in 8i if you enabled row movement between partitions

jmodic,

can u explain how to enabled row movement between partitions ?

Thanks

The database is set like this.
The database consists of 47 tables. The application which we use is designed such a way that each client will have a specific userid to login and enter their data in the 47 tables through their views(47). So each user is given their own views, as data can be edited through the dedicated view.

All the 47 tables will have the userid as one of their columns in it. That way its easy to partition by range.
For each userid 47 tables are partitioned, views are created and stored in a different tablespace. So actually the data is partitioned by the client id (userid in oracle terms).

The userid is dropped accidently from the dba user. So the objects which are owned by the users are deleted. So we did a point in time recovery and thinking of creating the new user and updating the partition key with the new userid.
Hope this explains the situation.

Thanks,
shankar.

Quote:

---

Originally posted by culonbu
jmodic,

can u explain how to enabled row movement between partitions ?

Thanks

---

ALTER TABLE my_partitioned_table ENABLE ROW MOVEMENT;

I am not really sure whats the thing u r asking me. Sorry, can u explain it to me briefly.
thanks
shankar

Shankar,
I wasn't asking you anything, I was merely answering culonbu's question how to enable row movement :). That's why I was quoting him in my reply...