Re: moving oracle database 9 from another computer to another one

From: <fitzjarrell_at_cox.net>
Date: Thu, 20 Dec 2007 11:09:40 -0800 (PST)
Message-ID: <a7edf4ae-cd4a-4df3-b8bb-83bd743feaf6@i3g2000hsf.googlegroups.com>

On Dec 20, 12:25 pm, noumian <n.nou..._at_gmail.com> wrote:
> i am sorry ,but iam still learning,oracle is very big, they are things
> that i know how to d and that i have done aready, and they are things
> that i havent done before but that i have an idea about how to do it.
> its just that i want to be sure.
> i have made a test on own cumputer,
> using exp full=y from the old database and imp full=y for the new
> database.
> after that i have many warning like : "126 objet(s) non valide(s) dans
> le schéma OLAPSYS,"126 objet(s) non valide(s) dans le schéma
> OLAPSYS." .....
> is it normal?

Not usually.

At this point you query dba_objects or user_objects and find which are invalid and then try to discover why. Hopefully it's a matter of using the utlrp.sql script to recompile them.

David Fitzjarrell Received on Thu Dec 20 2007 - 13:09:40 CST