That can't be the reason.
The Import-Utility from Oracle creates the table (and the indexes) and than
inserted the rows into.
So I don't have a table at the time of Import.
--
Gaby Spiessl
gaby_at_spiessl.net
"Jim Kennedy" <kennedy-family_at_home.com> schrieb im Newsbeitrag
news:diRN7.5424$726.2901287_at_news1.sttln1.wa.home.com...
> The error is saying that one of the columns in the table has a smaller
> allowable precision than what is in the dmp file. You need compare the
> field definitions of the table you are importing to and the field
definition
> of the table you were importing from.
>
> For example :
> If in my fromdatabase I have a table myTable like:
> create table myTable(
> acolumn number(10,10)
> );
>
> and in my todatabase I have a myTable like:
> create table myTable(
> acolumn number(10,2)
> );
>
> Then when I import I will get the error. (assuming that in the 1st table I
> have some numbers that use all of the specified percision.)
> Jim
> "Gaby Spiessl" <gspiessl_at_gmx.at> wrote in message
> news:9u8jic02koj_at_enews3.newsguy.com...
> > I have Oracle 8.1.7 running on Win2000
> > One Tablespace with 2 Datafiles (two times 1500 MB)
> > I wan't to import but I get an error:
> >
> > IMP00058 Oracle Error 1438
> > ORA01438 value alrger than secified precision allows for this columns
> > IMP00018 partitial import of previous table completet
> > 133933 rows imported
> >
> > In the first datafile there are 150 MB free. The second datafile is
free.
> > The number of rows for the import are 952000.
> >
> > Can anybody help me!
> >
> > Thanks
> >
> > --
> > Gaby Spiessl
> > gaby_at_spiessl.net
> >
> >
>
>
Received on Fri Nov 30 2001 - 14:52:56 CST
