Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: export/import

Re: export/import

From: raghu <raghu.kuralla_at_netdecisions.com>
Date: Thu, 21 Feb 2002 14:56:24 -0000
Message-ID: <tU7d8.4238$9h2.1556494@monolith.news.easynet.net>


Assuming u are running this command on the source DB, if not from the same box use the @servicename
exp system/manager file=C:\exp_source.dmp full=y log=c:\exp_source.log

Assuming that you moved the .dmp file from SOURCE DB BOX to TARGET box and running the following command on the TARGET DB box imp system/manager file=c:\exp_source.dmp full=y ignore=y log=c:\imp_source.log

"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 - 08:56:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US