940854 wrote:Not sure what you mean by "same" - the former shows all initialization parameters that have been explicitly set, and the latter creates a pfile initialization file from spfile settings.
Am I right to say that these 2 are the same?
1) select name, value from v$parameter where ISDEFAULT = 'FALSE';
2) create pfile from spfile;
They gave me the same results... 41 rows of parameter... 0 events and 0 underscore hidden parameters..
940854 wrote:Have you considered this?:
I know that I can have a direct upgrade to 11g and I can afford to have downtime for 2 - 3 hours. I have read some Oracle article in Oracle support and know that the only method is through exp/imp or Data Pump expdp/impdp. I understand that Windows Server 2008 Standard R2 does not support Oracle 9i...
2) How long will upgrade via exp/imp 220GB take?It make take a while depending on the resources of your servers for export and import, adding to that transferring the files. A direct remote upgrade is better as it was suggested in other replies to this thread.
3) Can I have 11g EE (32 bit) running on a Windows Server 2008 Standard (64 bit)? If so, can I exp/imp from 9i (32 bit) to 11g (32bit) and subsequently change 11g (32bit) to 11g (64bit)?Yes you can, the 11g db would be a brand new empty db where you are dumping data into. What I would do is directly import into 11g 64 bit if that is your target version. Still downtime is an issue here.