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

Thread: partition existing table

  1. #1
    Join Date
    May 2002
    Posts
    193
    Dear Sir,

    Can anyone tell me as to whether if it is possible to partition
    an existing table(that has no partition in it) in a database and if so the syntax for the same.....

    Thanks and Regards,

    K.Diwakar

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi,
    How to Partition an non-partitioned table?
    SQL:
    1. Create table dummy_t as select with the required partitions
    2. Alter table EXCHANGE partition T with dummy_T
    3. Drop table T

    exp/imp:
    Perform the following steps to partition an non-partitioned table:
    1.Export the table to save the data.
    2.Drop the table from the database.
    3.Create the table again with partitions.
    4.Import the table data.

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