Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Migrating from 7 to 9i
Naveen - Sorry, I was sleeping. Of course, by now you are probably sleeping.
We have a few list participants on your side of the globe, but maybe not a
critical mass of people yet.
I apologize if you feel your messages have been overlooked. Since replies are voluntary, I tend to read a message and consider whether I could probably answer that question better than someone else. Unfortunately, many people reply to some types of questions and some other questions tend to slip through the cracks. And some questions could easily be answered with a Google search. I say that not so much as a criticism, but we all have different learning styles.
I believe that more information will tend to get you a better reply because it gives us all more information to go on. Unfortunately this is an English-language list and that is a difficulty for those whose first language is not English. I try to keep that in mind and remember that the smartest person I worked with had lousy English. He tried to improve by taking an ESL class, but ended up marrying the instructor.
As to migration from 7 to 9i, in my mind, the critical issue is "how large is your database"? If it is only a few gig and your business users will allow you to have it down for a few hours, the simplest approach is something like export/import. Basically, create your new database in Oracle9i, then somehow get all the data from the old to the new database. You can use export/import, SQL*Net COPY, etc. I am facing that task in about a year from now on a 150-gig. database because we are buying new hardware. If you feel your database is far too large for this method, investigate the migration alternatives. Go into http://technet.oracle.com and search the documentation for the word "migration". It has a very specific document describing the migration steps. I tend to avoid this whenever possible. Oracle's upgrade process tends to be simple, but migrations are much more involved and may not be worth the effort if you can accomplish the end result using other alternatives.
Good luck Naveen. Please reply if any of these points isn't clear to you.
Of course, if you've already gone home for the day I may not see your
message until I arrive on Monday.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Friday, August 09, 2002 6:08 AM
To: Multiple recipients of list ORACLE-L
Why is that my questions hardly get any replies?
Is it that I don't give sufficient details? Or is that because my questions are too simple for most of you experts?
Or is it simply because of the time difference(Because I post my questions during Indian working hours)?
Whatever the reason, I do my bit(read RTFM) before putting any questions and
I come up with questions which are either related to experience, or where
too
less information is available.
-----Original Message-----
Sent: Friday, August 09, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L
Hi All Gurus,
I need some guidelines in Migrating an Oracle version 7(Dont have the exact version right now) database to 9i.
There are few tables which store Chinese Characters. And it also requires
converting Big5 internal code (some are HK characters set) into Unicode
ISO10646:1-2000.
Please advise on any complications which may arise and any other
considerations which might come from your experience.
Please pour in any suggestions you might have for me.
Regards,
Naveen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
INET: naveen_nahata_at_mindtree.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Aug 09 2002 - 10:13:37 CDT
![]() |
![]() |