DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Updating partition key

  1. #1
    Join Date
    Mar 2001
    Posts
    6
    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]

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Dec 2000
    Posts
    126
    jmodic,

    can u explain how to enabled row movement between partitions ?

    Thanks

  4. #4
    Join Date
    Mar 2001
    Posts
    6
    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.

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    [QUOTE][i]Originally posted by culonbu [/i]
    [B]jmodic,

    can u explain how to enabled row movement between partitions ?

    Thanks [/B][/QUOTE]

    ALTER TABLE my_partitioned_table ENABLE ROW MOVEMENT;
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Mar 2001
    Posts
    6
    I am not really sure whats the thing u r asking me. Sorry, can u explain it to me briefly.
    thanks
    shankar

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width