Re: Import from V7 to V8 fails

--0-1804289383-962892199=:17211
Content-Type: text/plain; charset=us-ascii

 Are you sure you're running the correct catalog.sql? After changing your ORACLE_SID to the new sid, did you run .oraenv to ensure that the PATH and ORACLE_HOME variables are pointing to the right directories before running catalog.sql? If not, rerun it with the correct environment settings. Also, are you sure you connected as SYS or INTERNAL when you ran catalog.sql?

Did you get any errors during either the export or the import? If so, try to determine what caused them and correct them.

If all of this fails, you'll probably have to recreate the database.

Schoen Volker <v.schoen_at_inplan.de> wrote:

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ön
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

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


---------------------------------
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
--0-1804289383-962892199=:17211
Content-Type: text/html; charset=us-ascii



<P> Are you sure you're running the correct catalog.sql? After changing your ORACLE_SID to the new sid, did you run .oraenv to ensure that the PATH and ORACLE_HOME variables are pointing to the right directories before running catalog.sql? If not, rerun it with the correct environment settings. Also, are you sure you connected as SYS or INTERNAL when you ran catalog.sql?</P>

<P>Did you get any errors during either the export or the import? If so, try to determine what caused them and correct them.</P>

<P>If all of this fails, you'll probably have to recreate the database.</P>

<P><B><I>Schoen Volker &lt;v.schoen_at_inplan.de&gt;</I></B> wrote: <BR></P>

<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">Hi list,<BR><BR>I have a problem with my Oracle 8.1.5.<BR><BR>What have I done:<BR>1. Export full database from Oracle 7.3.4<BR>2. Import full database export into Orale 8.1.5, Import fails<BR>3. Import only the needed schemas, works fine<BR><BR>Now my problem:<BR>There are a lot of invalid objects in SYS schema. I can't recompile these<BR>objects. Another cuiriosity is that I can't drop a user. Oracle Support<BR>says:<BR>Drop database and recreate it, but this is production and I don't like to do<BR>this.<BR>Does anyone know if it is possible to repair this database, running<BR>catalog.sql doesn't help.<BR><BR>any help is welcome<BR><BR>TIA<BR>Volker Schön<BR>E-Mail: mailto:v.schoen@inplan.de<BR>http://www.inplan.de<BR><BR><BR>--<BR>Author: Schoen Volker<BR>INET: v.schoen@inplan.de<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Int!

ernet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>
Send instant messages & get email alerts with Yahoo! Messenger.