For those interested.. We migrated by exp/imp from 8.0.6 to 8.1.7. Got some errors on system objects but so far everything is going smoothly. >>> [EMAIL PROTECTED] 08/24/01 17:13 PM >>> system can get hosed up weird, part of it depends on ignore= setting. if you do ignore=y then it will potentially mess up system stuff(someone qith AQ experience, clarify, doesnt the AQ stuff get loaded into the system schema?). I seem to remember that as a problem. joe Mario Alberto Ramos Arellano wrote: > > What happens to system? > During a migration, does SYSTEM get corrupted because of importing older versions of >system objects? > Is it needed to run catalog and catproc again on the new version? > > >>> [EMAIL PROTECTED] 08/23/01 23:27 PM >>> > > nope, not SYS > > >From: Jon Walthour <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re: Migrate/Update-which way is better? > >Date: Thu, 23 Aug 2001 10:00:58 -0800 > > > > > 1. I have a full export dump, I know the objects owned by sys are not > >exported/imported. What happens to the objects owned by system? > > > >Listers, please correct me if I am wrong here, but that's not my > >understanding. I have recreated a complete database from a full export in > >the past and the 8i Utilities manual says that a full export "exports the > >entire database". So, I'm almost certain that includes SYS. > > > >Jon Walthour > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mario Alberto Ramos Arellano > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mario Alberto Ramos Arellano INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Migrate/Update-which way is better?
Mario Alberto Ramos Arellano Mon, 27 Aug 2001 18:03:07 -0700
- Migrate/Update-which way is better? Mario Alberto Ramos Arellano
- Re: Migrate/Update-which way is better? Jon Walthour
- Re: Migrate/Update-which way is better? JOE TESTA
- Re: Migrate/Update-which way is better? Rachel Carmichael
- Re: Migrate/Update-which way is better? Dennis M. Heisler
- Mario Alberto Ramos Arellano