![]() |
|
![]() | ||
|
Subject:
Migrating an Oracle database
Category: Computers > Software Asked by: jmanels-ga List Price: $20.00 |
Posted:
06 Oct 2004 12:17 PDT
Expires: 13 Oct 2004 20:57 PDT Question ID: 411149 |
How do I edit an Oracle .DMP file, and what changes do i have to make when exporting from Oracle 8i in Windows 2000 and import into Oracle 9i in Linus AS 2.1 |
![]() | ||
|
There is no answer at this time. |
![]() | ||
|
Subject:
Re: Migrating an Oracle database
From: rtfm-ga on 12 Oct 2004 15:36 PDT |
Never edit an export file. (never say never either, but even though there are a few things you can change, most editors will mess things up for you). You should not have to make any changes. If there are any errors you should work through them - For example, a 904 table does not exist might refer to a system AQ table that no longer exists, or a table owned by a schema you didn't export. What you need to avoid is exporting from a higher version and importing to a lower version. There are plenty of other well-known tips, such as do not use compress=y, and it is better if you create the tablespaces and tables before the import and use ignore=y. Google the newsgroups comp.databases.oracle.* for more info. http://www.dbaoracle.net |
Subject:
Re: Migrating an Oracle database
From: rtfm-ga on 12 Oct 2004 15:37 PDT |
Oh yeah, be sure you use binary when you ftp! |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |