Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008

    Unanswered: non-partitioned to partition

    is it possible to migrate non-partitioned table into partioned table by using
    exchange clause?
    but the rows of the nonpartitioned table refer more than one partition.

    the exchange clause should be like:

    alter table partioned_table
    exchange partition part1,
    exchange partition part2,
    exchange partition part3
    with table temp;

  2. #2
    Join Date
    Sep 2002
    Unfortunately, your question does not make any sense to me. Can you describe your current state (tables that exist, are they partitioned, do they currently have data, etc) and your desired end state?

    The more relevant and accurate information you can provide will enable the other forum posters to provide you with a correct answer,

  3. #3
    Join Date
    Jun 2003
    West Palm Beach, FL

    Thumbs up Exchange Partition With Table

    According to the fine SQL Reference manual, it's valid -- try it out!
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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