Google Answers Logo
View Question
 
Q: Migrating an Oracle database ( No Answer,   2 Comments )
Question  
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
Answer  
There is no answer at this time.

Comments  
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!

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

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 Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy