Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Interesting (painful) Migration Problem (Nov 7.2.2.4.10 -> NT 7.3.3.0.0)
hi,
We've got an interesting and painful migration in progress.
We're moving a ~8 Gigabyte 7.2.2.4.10 Database from a Novell 4.11 server to a 7.3.3.0.0 NT 4.0 Svc Pk 3 server.
Yeah, I know, we're insane.
Anyone got any experience with this?
We have done the following:
1) exported the 7.2.2.4.10 DB to a dump file
(it's about 1.3 G)
2) Created a database on the new server
Problems: The import program will try to create sys volumes instead of lettered drives, so we can't just import it (plus we need to fix some structural issues....)
We have a plan:
a. Create tablespaces for the data, indexes, etc b. Create the users on the new box with quotas in those tablespaces c. Run the import and pray that each user's tables make it into thenew tablespaces
Is there any way to make this any less difficult? Any pitfalls to avoid?
Any information you may have would be greatly appreciated... Thanks much!
Nassif!! Received on Fri Mar 27 1998 - 00:00:00 CST