Move Table with Partitions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Move Table with Partitions

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hello:

    How can I move a table with partitions, to a different tablespace? Alternatively how can I alter table extent sizes after the table is created and the tablespace is having extent sizes defined already.

    Thanks, ST2000

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    you have to move partitions one by one

    dont know what you are talking about extent sizes of a table if you are talking about partitions?

  3. #3
    Join Date
    Oct 2000
    Posts
    449
    Sorry for confusion..

    I have a tablespace allocation made at 64K extent sizes and one of the table in there is the same since storage definition is dominated at TS level.. Secondly this table has partitions. Now choice 1 is .. I want this table to have larger extents of 50MB each.. or move to a different tablespace that already has this kind of extents. So when I tried to move, it gave a problem since it has partitions..

    Thanks, ST2000

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    storage for partitioned tables goes by partitions not tables, just think partitions as seperate tables with their own storage parameters

  5. #5
    Join Date
    Mar 2002
    Posts
    534
    Just have a look at the ALTER TABLE table_name MOVE statement and you will probably see that it can solve your problem

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