Re: Import-Problems

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 - 13:42:01 CST