Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63

    Unanswered: Migrating Normal Table to Partition Table

    The Table data grows and we want to make partition of it .

    As it's quite huge , What's the best solution to migration it
    to the partition table .( the table name must be same )

    BTW , oracle version is 8.1.7
    Oracle is an ocean . I am just a little fish

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118
    You'll have to decide what kind of partitioned table to use:

    { range_partitioning
    | hash_partitioning
    | composite_partitioning
    | list_partitioning
    }



    Then you would create the new partitioned table and migrate your data to it.



    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.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
  •