Re: Migrate/Update-which way is better?
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?
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: Jon Walthour 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?
Nope, NO SYS objects are exported during a full export,. recreate the database then run full import. joe [EMAIL PROTECTED] 08/23/01 02:00PM 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: Jon Walthour INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Migrate/Update-which way is better?
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: Jon Walthour 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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?
Jon, If you look at the Export Modes description in the Utilities manual, it says that All objects in the database are exported, except those in the schema of SYS. Dennis Jon Walthour wrote: 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: Jon Walthour 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: Dennis M. Heisler 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).