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

Thread: Migration

  1. #1
    Join Date
    Feb 2008
    Posts
    1

    Migration

    hI

    Anyone can help me to migrate composite range-hash partition to caomposite range-list partition online?

    Thanks

    Subramanian

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    1) create a new table
    2) copy data to a new table using sqlplus "copy" command
    3) create all indexes on a new table, give all grants, create triggers on that table
    4) rename old table
    5) rename a new table to the one you need.
    Best wishes!
    Dmitri

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