Re: Export/Import/Transport a database

[Quoted] [Quoted] I want to copy the whole database, including the data to another computer. The export dmp file size if about 90M. The oracle 816 (data [Quoted] [Quoted] source) is on Linux. The Oracle 815 (destination) is on PC. I don't [Quoted] know why the file is invalid. it works if the dmp file is import back [Quoted] to the same computer.

[Quoted] my import command is:

[Quoted] imp usr/pwd file=bkup.dmp buffer=64000 commit=Y fromuser=datasrc touser=datadst

is there anything wrong? do I have to do anything in the command to [Quoted] specify that I'm importing from a different machine? is that any other [Quoted] method to do the data transfer?

[Quoted] thx for ur help

Ray

  wildpony <z1wildpony_at_hotmail.com> wrote:
> i can not verify if there is a difference in the exp/imp for 8.1.5 to
> 8.1.6
> are you just wanting to create the database schema or all the data
> and how much data are you trying to copy over and why are you going
> backwards
> from 8.1.5 to 8.1.6 and what os are you using
> the error that you received states that the header file is invalid or
> corrupt
>
> vdragonz_at_my-deja.com wrote:
>
> > yes, I tried and it works !!
> >
> > is there any other way I can copy the database?
> >
> > Ray
> > wildpony <z1wildpony_at_hotmail.com> wrote:
> > > are you sure the export file is not corrupted, can you import
 into a
> > > dummy/developer type database on the same os?
> > >
> > > vdragonz_at_my-deja.com wrote:
> > >
> > > > yes, in binary... oh.... are 8.1.6 using the same version of
 exp/imp as
> > > > 8.1.5? I export the database in 8.1.6 and import in 8.1.5
> > > > is there a problem with that?
> > > >
> > > > Ray
> > > >
> > > > wildpony <z1wildpony_at_hotmail.com> wrote:
> > > > > did you ftp in binary mode
> > > > >
> > > > > vdragonz_at_my-deja.com wrote:
> > > > >
> > > > > > Hi, I want to copy a database from one machine to another
 machine.
> > > > > > I tried to export the tables to a dmp file and then copy
 that
 in the
> > > > > > another machine, where I do the Import for that file.
 However , it
> > > > > > gives an error of :
> > > > > >
> > > > > > IMP-00010: not a valid export file, heaer failed
 verification
> > > > > > IMP-00000: Import terminated unsuccessfully.
> > > > > >
> > > > > > is that mean i can not import a database file that is not
 exported
 on
> > > > > > the same machine?
> > > > > >
> > > > > > Thankx in advance
> > > > > >
> > > > > > Sent via Deja.com http://www.deja.com/
> > > > > > Before you buy.
> > > > >
> > > > >
> > > >
> > > > Sent via Deja.com http://www.deja.com/
> > > > Before you buy.
> > >
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jul 26 2000 - 00:00:00 CEST