Re: export/import

From: Fraser McCallum <fmcc_at_NOSPAModbaguru.com>
Date: Thu, 21 Feb 2002 18:08:10 -0000
Message-ID: <pHad8.21210$kX6.159010@NewsReader>

You will always get some IMP0015 errors as Oracle won't replace the sys objects even if you use destroy=Y. If all the objects you are getting this error for are owned by SYS don't worry about the error.

Kind Regards

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"s Lehaire" <s.lehaire_at_meilleuregestion.com> wrote in message news:a52vio$4vq$1_at_reader1.imaginet.fr...
> I tried to import data into an other database but it doesn't work!
> here my cmd lines:
> exp system/manager c:\data.dmp
> imp system/manager c:\data.dmp destroy=y full=y
>
> but when I try to import an other time there is an error because the
object
> already exist (error oracle : IMP0015)
>
> The 2 databases are on 2 differents computers.
> so how can I do to import structures and data of the other database ?
>
> thx for help
>
> S.Lehaire apprenti administrateur
>
>
Received on Thu Feb 21 2002 - 12:08:10 CST