Printable View
Hi
1>I have a data about 6 gb in oracle database 7.3.3.0.0. workgroup edition with distributed option , now i want to migrate the database in to 9iR2 enterprise edition ?
if i take the export of 7.3 W E withDE then import into 9iR2EE.
wil, it work .
or do i have to follow the path 7.3->8.0.5->8.0.6->8.1.7->9.2
please suggest
and plateform is window NT,
2> How can i estimate the size of dmp file on windows please provide the steps.
SOnu
If you are doing export/import then you can directly export from Oracle7.3 and import into Oracle9i.
Hi Adewri
my question is still the same
1>if i take the export of 7.3 Workstation with Distributed Environment then import into 9i R2 Enterprise Edition.
wil, it work .
2> How can i estimate the size of dmp file on windows please provide the steps.
3> can we implement Oracle parallel server on 7.3 Workstation with distributed environment? If yes can i get some link r any white paper for implementing this thing? or do you have any steps for that.
Please have a look on both the 3 questions.
Sonu
Yes it will work. You need to pre-create the tablespaces in the 9i databases. Then use oracle7.3 exp utility to export and Oracle9i import utility ro import.Quote:
Originally posted by sonuji_in
Hi Adewri
my question is still the same
1>if i take the export of 7.3 Workstation with Distributed Environment then import into 9i R2 Enterprise Edition.
wil, it work .
You need to create a migration testing environment if possible. Do a sample database export and import and then run existing applications to see if there are any possible glitch, if there are then look for the solutions or available patches on metalink. Then when you are sure that everything has been resolved, do the final upgrade.
In windows i have no idea, in unix yes its possible.Quote:
2> How can i estimate the size of dmp file on windows please provide the steps.
OPS on workstations ?? i didn't get that. If you just read the concepts of RAC (OPS in 8i and earlier) that might give you a clear picture. For RAC you need to have atleast 3 nodes. Two for Oracle Software and instances and one to store the shared database.Quote:
3> can we implement Oracle parallel server on 7.3 Workstation with distributed environment? If yes can i get some link r any white paper for implementing this thing? or do you have any steps for that.
Please have a look on both the 3 questions.
Sonu
Refer to http://tahiti.oracle.com for more documentations.
Why 3 Amar? RAC needs minimum two nodes and a shared disk array.Quote:
Originally posted by adewri
For RAC you need to have atleast 3 nodes. Two for Oracle Software and instances and one to store the shared database.
Refer to http://tahiti.oracle.com for more documentations.
My mistake, i said 3 including the shared node as well...Quote:
Originally posted by SANJAY_G
Why 3 Amar? RAC needs minimum two nodes and a shared disk array.