Actually, SYSTEM *is* included in a full export.
This can cause you some problems on import if you forget about it. The few times I've recreated a database and populated it with a 'full' export, I've dropped the SYSTEM user from the new database before running the import. Since the discussion is on importing a v7 database into 8i, it might be a good idea to drop the SYSTEM user after the import as well, and recreate. Jared On Monday 21 January 2002 04:10, Boivin, Patrice J wrote: > Trial and error... <cough> <roll eyes upward> > > We have migrated a couple of development databases. > > Things to watch out for: > > Oracle says replication-related objects are not handled "very well" by > export / import. We haven't encountered any problems in that regard, but > all the snapshots had been turned off before the full export. > > SYS and SYSTEM objects are not included in the full export, so any public > synonyms, anything referring to objects stored in there will be invalid or > point to <Unknown> objects. > > If you have users with objects stored in the SYSTEM schema, kiss them bye > bye. Ironically we noticed that the default accounts (for the demo db) in > one 7.3.4. database were stored in SYSTEM. We don't need those accounts so > we removed them. > > The Web Development Toolkit is included in 8.1.7 by default, it is placed > in the SYS schema as a built-in package. On our databases here only one > user was using the toolkit, so he had installed it in his own schema. Now > we have two copies in the new database, with public synonyms pointing to > the SYS schema. > > Ensure you use the same character set for both. > > Double-check everything -- take an inventory of what is in your database, > what is valid / invalid, etc. in the first database, then run that test > again on the new one, and compare the results. > > Ensure you run the same /rdbms/admin scripts in the new database as you did > in the old one, before you do your migration. > > Change Manager is a useful tool, to a degree -- with OEM 2.2. on NT there > are bugs / shortcomings in it. My list so far: > -- the JVM screen properties go beserk after a while, but it doesn't appear > to affect the final results. Just leave the screen alone, and if you see > an error save the reports BEFORE you acknowledge the error. > -- it is extremely slow if you don't run it from the OEM console, > -- it doesn't verify whether packages have body text in them, > -- it does not log constraint name changes, esp. SYS_C#### names > -- I am not sure, I think it doesn't log the number of constraints per > table either. > > One amazing thing is that some objects that were invalid in the old > database are valid in the new one. Hopefully these old objects were > invalid only because someone had altered a parent object... > > They tightened up the code in 8i, some of the shortcuts that were used in > the older version by developers will result in invalid objects in the new > version. > > 8i doesn't prevent people from writing code that doesn't explicitly specify > the schema. > > run utlrp.sql from /rdbms/admin before you do your comparisons. > > If others know of other shotcomings, or ideas, please let me know. > > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des syst�mes > Technology Services | Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | R�gion des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > -----Original Message----- > Sent: Monday, January 21, 2002 4:50 AM > To: Multiple recipients of list ORACLE-L > > > > Hi smith ! > > I haven't done it but in my opinion, there should be no problem, but > anyways, the best way to find out is to try it!! > > > > Arslan Zaheer Dar > [EMAIL PROTECTED] > Database Administrator > Shaukat Khanum Memorial Cancer Hosptial & Research Centre > www.shaukatkhanum.org.pk > > > -----Original Message----- > > Sent: Saturday, January 19, 2002 12:57 AM > To: Multiple recipients of list ORACLE-L > > Can I do a full export from 7.3.4 and then do a full import into 8.1.7? > > Ron Smith ---------------------------------------- Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: QUOTED-PRINTABLE Content-Description: ---------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
