Re: Export/Import/Transport a database

I don't even have a 'second schema'. I copy the data using the 'create table mode'... so it should just create the table according to the schema of the original data. Since it is done by the copy statement. There's nothing that I can do to modify the precision.

Ray

  wildpony <z1wildpony_at_hotmail.com> wrote:
> 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
> is specified , a default precision of 22 digits is used
>
> -- specify numeric precision between 1- 38 and then re-excute the
 statement
> 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.
>
>

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