Lots of small size datafiles VS fewer datafiles with large sizes -
Hi,
we are migrating our 9i database from windows 32 bit to 11g ASM on Windows 64 bit
The database size is 160 GB spanning across 87 data files (due to 32 bit O/S limitations, we have a lot of files with a max file size of 2 GB)
There are 2 options: 1. use transportable tablespace and 2. use export / import
If we use the transportable tablespace option , it means that the 11g database will inherit the 9i database files structures and the fragmentation within those files since the all the data files will be copied over to 11g database at O/S level. This mean that even on 11g we will end up having all those (87 to be exact) small data files from 9i database
we are migrating our 9i database from windows 32 bit to 11g ASM on Windows 64 bit
The database size is 160 GB spanning across 87 data files (due to 32 bit O/S limitations, we have a lot of files with a max file size of 2 GB)
There are 2 options: 1. use transportable tablespace and 2. use export / import
If we use the transportable tablespace option , it means that the 11g database will inherit the 9i database files structures and the fragmentation within those files since the all the data files will be copied over to 11g database at O/S level. This mean that even on 11g we will end up having all those (87 to be exact) small data files from 9i database
0