Move table from tablespace with 4 meg extent to a tablespace with 128 k extent
Hello,
As part of a 10g to 11g migration exercise we are going to reorganize the tablespaces and its objects in the 11g instance after the initial import to 11g.
We do not have any 4 meg extent tablespaces in the 10g structure.
I am using the REMAP_TABLESPACE option in impdp to get the tables with many extents into the 11g four meg extent tablespace.
( 80 tablespaces to 8 ). Of course I cannot get every object into its proper tablespace during the import.
Is there any 'gotchas' when moving a table from a tablespace with 4 meg extent size to a tablespace with a 128 k extent size?
As part of a 10g to 11g migration exercise we are going to reorganize the tablespaces and its objects in the 11g instance after the initial import to 11g.
We do not have any 4 meg extent tablespaces in the 10g structure.
I am using the REMAP_TABLESPACE option in impdp to get the tables with many extents into the 11g four meg extent tablespace.
( 80 tablespaces to 8 ). Of course I cannot get every object into its proper tablespace during the import.
Is there any 'gotchas' when moving a table from a tablespace with 4 meg extent size to a tablespace with a 128 k extent size?
1