Re: Export/Import/Transport a database

[Quoted] did you run catalog and catproc on the PC I have never run oracle on a Linux machine I have always been able to export from one unix machine (hp,sun,aix) [Quoted] over to another unix machine or nt server and never had any problems I would contact oracle support
[Quoted] can you recreate your schema on the nt server and do a link between the [Quoted] [Quoted] 2 databases/servers and copy over the data

vdragonz_at_my-deja.com wrote:

> 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
> source) is on Linux. The Oracle 815 (destination) is on PC. I don't
> know why the file is invalid. it works if the dmp file is import back
> to the same computer.
>
> my import command is:
>
> 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
> specify that I'm importing from a different machine? is that any other
> method to do the data transfer?
>
> 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