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

On Dec 20, 10:25 am, 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?

This might be normal if you don't install or migrate the OLAP option properly. It may only be a warning if it is just a need to recompile the objects. I don't know offhand, but I suspect there are OLAP objects that come from installation and shouldn't be migrated. Are you using OLAP? Are you licensed for it?

You might run dbca and save the db creation script it can create. I've found this very useful to have around during and beyond the life of the db, together with a file notating all administrative changes made. One useful thing is, I can then create an empty db elsewhere with simple file editing. An even more useful thing is to know why any changes from defaults were made.

jg

--
@home.com is bogus.
http://catless.ncl.ac.uk/Risks/24.92.html#subj5