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 15:47:48 -0000
Message-ID: <JE8d8.4265$9h2.1571749@monolith.news.easynet.net>


When u run the command, it will just display on the screen the same writes into this file, you can later check for any errors etc.

"s Lehaire" <s.lehaire_at_meilleuregestion.com> wrote in message news:a5333b$5sd$1_at_reader1.imaginet.fr...
> what is the log file?
>
> "raghu" <raghu.kuralla_at_netdecisions.com> a écrit dans le message de news:
> tU7d8.4238$9h2.1556494_at_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 - 09:47:48 CST

Original text of this message

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