RE: Import from V7 to V8 fails

From: Vincent Ruger <Vincent.Ruger_at_nos.nl>
Date: Fri, 7 Jul 2000 08:02:51 +0200
Message-Id: <10550.111394@fatcity.com>

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

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_at_fatcity.com [mailto:root_at_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_at_inplan.de
http://www.inplan.de

--=20
Author: Schoen Volker
INET: v.schoen_at_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_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).

------_=_NextPart_001_01BFE7D8.FBD0CF82
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Import from V7 to V8 fails</TITLE>
</HEAD>
<BODY>

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_at_fatcity.com [<A =
HREF=3D"mailto:root_at_fatcity.com">mailto:root_at_fatcity.com</A>]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: <A =

HREF=3D"mailto:v.schoen_at_inplan.de">mailto:v.schoen_at_inplan.de</A>
 <A HREF=3D"http://www.inplan.de" =
TARGET=3D"_blank">http://www.inplan.de</A>

 

-- 
 Author: Schoen Volker
   INET: v.schoen_at_inplan.de


Fat City Network Services    -- (858) =
538-5051  FAX: (858) 538-5051
 San Diego, =

California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----
 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 Received on Fri Jul 07 2000 - 01:02:51 CDT