-
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
-
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?
-
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
-
storage for partitioned tables goes by partitions not tables, just think partitions as seperate tables with their own storage parameters
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|