Re: Export/Import/Transport a database

[Quoted] well that means that the presision specified for a number column in a create/alter table
or create cluster statement must be a digit between 1 - 38, if no precision [Quoted] is specified , a default precision of 22 digits is used

• specify numeric precision between 1- 38 and then re-excute the statement [Quoted] in other words just out the actual numeric precision on the table in question and compare it to the table in the other database schema

vdragonz_at_my-deja.com wrote:

> I don't know what a catproc or catalog is in Oracle. I tried to copy
> the data using the 'copy' command... however, there's some problem in
> one of the table with 'float' datatype. However, it gives me an error
> of the following:
>
> ORA-01727: numeric precision specifier is out of range (1 to 38)
>
> I think this may be a problem caused a 'float' column of the table.
> However, I really dunno what happens and how I can fix it.
>
> May you help? Thx a lot
>
> Ray
>
> wildpony <z1wildpony_at_hotmail.com> wrote:
> > 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)
> > over to another unix machine or nt server and never had any problems
> > I would contact oracle support
> > can you recreate your schema on the nt server and do a link between
 the
> > 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.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jul 27 2000 - 00:00:00 CEST