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

Thread: Partitioning tablespaces in 8i

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    I am currently running a db version 8.1.6 on solaris and NT..
    I have a table that need to be partitioned. It already has data in them. I don't want to export the data, create a new structure with partition and then import the data. I want to be able to do that dynamically.. What are the issues I might need to become aware of interms of performance, possibility and how do I do that?? Thanks..

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If your partitioned table is going to be the same structure as your original table, then it is really easy.

    First, create your partitioned table with one partition that is partitioned on maxvalue. Then, exchange your existing table into the partitioned table. Once your table is a partitioned table, you can split the partitions into as many partitions as you want.
    Jeff Hunter

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