Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    276

    Unanswered: partitions in Oracle...

    Hi,
    Can we add partition to a table which has data? I read online about exchange partition..
    1) We have a table old_tab (without partition but has data)
    2) Create a table new_tab same as old_tab but with partitions
    3)Switch data from old_tab to new_tab using alter table....
    ALTER TABLE new_tab
    EXCHANGE PARTITION partition_name
    WITH TABLE old_tab
    WITHOUT VALIDATION;
    4) Drop the old table(old_tab) and rename the new table(NEW_TAB) as old table(OLD_TAB).
    Does anyone know of any other method??

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Looks "ok" to me that way. Another way (if on 10g and above) would be using dbms_redefinition.

Posting Permissions

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