Table Redefinition
OS: Oracle Enterprise Linux 5u2 (64-bit)
DB: 10.2.0.4.0 Standard Edition
I am looking to move a table from one tablespace to another and I'm trying to determine the effects on the source tablespace, specifically the size of the datafiles and their footprint on disk after the redefinition. The source tablespace is currently around 122Gb in size, and is comprised of nine datafiles. Each datafile is roughly 13.5Gb in size and all are set to autoextend. The table I wish to move is approximately 106Gb in size and makes up a majority of the tablespace on disk.
If I were to do a redefinition and move this table into it's own tablespace, it seems I'd essentially be removing 85% of the data from the original tablespace. What happens to this space, as it relates to the datafile and on disk? Will I still have nine datafiles, each just sized smaller? If the space is freed from the datafiles, is it automatically freed on disk? I'm trying to ensure that I don't wind up adding 100Gb of space on disk for the new tablespace without it being made available from the original tablespace.
I am looking to move a table from one tablespace to another and I'm trying to determine the effects on the source tablespace, specifically the size of the datafiles and their footprint on disk after the redefinition. The source tablespace is currently around 122Gb in size, and is comprised of nine datafiles. Each datafile is roughly 13.5Gb in size and all are set to autoextend. The table I wish to move is approximately 106Gb in size and makes up a majority of the tablespace on disk.
If I were to do a redefinition and move this table into it's own tablespace, it seems I'd essentially be removing 85% of the data from the original tablespace. What happens to this space, as it relates to the datafile and on disk? Will I still have nine datafiles, each just sized smaller? If the space is freed from the datafiles, is it automatically freed on disk? I'm trying to ensure that I don't wind up adding 100Gb of space on disk for the new tablespace without it being made available from the original tablespace.
0