RE: Import from V7 to V8 fails

From: Trassens Christian <trassenc_at_TELEFONICA.COM.AR>
Date: Thu, 6 Jul 2000 10:40:24 -0300
Message-Id: <10550.111337@fatcity.com>

If you have space enough, install 8.1.5 engine separately of the one of 7.3.4, create an 8.1.5 database using environment variables of 8.1.5 = and as
you always do and then export and import using named pipes. If you need = more
detail about tell me.

Regards.

> -----Mensaje original-----
> De: Schoen Volker [SMTP:v.schoen_at_inplan.de]
> Enviado el: Jueves 6 de Julio de 2000 10:27
> Para: Multiple recipients of list ORACLE-L
> Asunto: Import from V7 to V8 fails

>=20

> Hi list,

>=20

> I have a problem with my Oracle 8.1.5.

>=20

> 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

>=20

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

>=20

> any help is welcome

>=20

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

>=20
>=20

> --=20
> Author: Schoen Volker
> INET: v.schoen_at_inplan.de

>=20


> 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).
Received on Thu Jul 06 2000 - 08:40:24 CDT