Hi, I have a 10.2.0.5 database running on Windows Server x64bit that I want to move to 11G Linux SUSE10. I will be using export / import. Should I export the database stats from 10G and import into 11G ? Or will export / import take care of this ?
Printable View
Hi, I have a 10.2.0.5 database running on Windows Server x64bit that I want to move to 11G Linux SUSE10. I will be using export / import. Should I export the database stats from 10G and import into 11G ? Or will export / import take care of this ?
I would do the export with statistics=none. However, you are better off using expdp,
i.e. data pump. It faster, and better supported than the older exp/imp utilities.
Either way, you should gather all new stats after you migrate the data.