Message-Id: <10550.111394@fatcity.com> From: Vincent Ruger Date: Fri, 7 Jul 2000 08:02:51 +0200 Subject: RE: Import from V7 to V8 fails This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFE7D8.FBD0CF82 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi I've impotred 7.3.4 exports into 8.1.5 (and 8.1.6) but had to run first catexp7.sql to get the correct tables in the catalog. I've you run catalog.sql in a live environment probably all the objects become invalid (in our situation it did) So we compiled (using PLSQL-developer, great tools also for dba's) everything and it worked. hth Vincent Ruger Oracle DBA -----Oorspronkelijk bericht----- Van: root@fatcity.com [mailto:root@fatcity.com]Namens Schoen Volker Verzonden: donderdag 6 juli 2000 15:27 Aan: Multiple recipients of list ORACLE-L Onderwerp: Import from V7 to V8 fails Hi list, I have a problem with my Oracle 8.1.5. What have I done: 1. Export full database from Oracle 7.3.4 2. Import full database export into Orale 8.1.5, Import fails 3. Import only the needed schemas, works fine Now my problem: There are a lot of invalid objects in SYS schema. I can't recompile = these objects. Another cuiriosity is that I can't drop a user. Oracle Support says: Drop database and recreate it, but this is production and I don't like = to do this. Does anyone know if it is possible to repair this database, running catalog.sql doesn't help. any help is welcome TIA Volker Sch=F6n E-Mail: mailto:v.schoen@inplan.de http://www.inplan.de --=20 Author: Schoen Volker INET: v.schoen@inplan.de 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@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). ------_=_NextPart_001_01BFE7D8.FBD0CF82 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Import from V7 to V8 fails

Hi

I've impotred 7.3.4 exports into 8.1.5 (and 8.1.6) = but had to run first catexp7.sql to get the correct tables in the = catalog.

I've you run catalog.sql in a live environment = probably all the objects become invalid (in our situation it = did)
So we compiled (using PLSQL-developer, great tools = also for dba's) everything and it worked.

hth

Vincent Ruger
Oracle DBA

-----Oorspronkelijk bericht-----
Van: root@fatcity.com [mailto:root@fatcity.com]Namens = Schoen Volker
Verzonden: donderdag 6 juli 2000 15:27
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Import from V7 to V8 fails


Hi list,

I have a problem with my Oracle 8.1.5.

What have I done:
1. Export full database from Oracle 7.3.4
2. Import full database export into Orale 8.1.5, = Import fails
3. Import only the needed schemas, works fine

Now my problem:
There are a lot of invalid objects in SYS schema. I = can't recompile these
objects. Another cuiriosity is that I can't drop a = user. Oracle Support
says:
Drop database and recreate it, but this is = production and I don't like to do
this.
Does anyone know if it is possible to repair this = database, running
catalog.sql doesn't help.

any help is welcome

TIA
Volker Sch=F6n
E-Mail: mailto:v.schoen@inplan.de
http://www.inplan.de


--
Author: Schoen Volker
  INET: v.schoen@inplan.de

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@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