Partition table update -FAQ
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Partition table update -FAQ

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Partition table update -FAQ

    Hi

    While doing the partition key update and if the value execeeds the partition limit, the update failes with the error

    ORA-14402: updating partition key column would cause a partition change


    Refering to the FAQ
    http://www.dbasupport.com/oracle/faq/Detailed/8.shtml update on partition key is not possible outside the partition limits.

    But in oracle 8i onwards it is possible to update the partition keys directly with out delete and inserte.

    Alter the partition table or create the table with the option "Enable Row Movement"

    Alter table Table_name enable row movement;


    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Seems you are making more of a statement than asking a question Thomas. Is the row movement not working for you?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Hi

    Hi Slimdave

    No Comments Slimdave... Better sleep on your post..

    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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