OVSD Migration from Windows Oracle 8.1.7 to Solaris Oracle 9.0 version
Hi, We have a requirement to migrate OVSD from Oracle 8.1.7 on Windows machine to Oracle 9.0 on Solaris machine.Can somebody please let us know the guidelines for the above migration as i couldn't find them in the OVSD standard documentation.
Note : We have SD 4.5 with SP8 on windows with oracle version as 8.1.7.
Re: OVSD Migration from Windows Oracle 8.1.7 to Solaris Oracle 9.0 version
Yes, you have got the right idea. I must admit that I have only worked with a database where the same schema contains the repo and data user, and I have not seen problems with integrity constraints.
Unless there is a real data problem, I think there are two ways, in principle, to handle this: 1) do the import twice; the second time around the dependent data should find what it is looking for. 2) disable the constraints before the import, then enable them afterwards.