Re: ORA-1438 on Import (very urgent!!!!)

From: Chris Weiss <chris_at_www.hpdbe.com>
Date: Wed, 23 Jan 2002 22:28:22 -0500
Message-ID: <a2nu4s$2vum$1@msunews.cl.msu.edu>

It sounds like you recreated the table from a DDL script, the table drifted in structure, and you are attempting to import the data into an invalid table definition. If so, trying importing the entire file after dropping the table. Also, look for a synonym to a table with the same name.

Otherwise, crank up the precision on your number columns.

If this fails, try importing the data into a different database to ensure it is not a problem with your current database.

Good Luck!

--

~~~~~~~~~~~~~~~~
Chris Weiss
www.hpdbe.com
High Performance Database Engineering
~~~~~~~~~~~~~~~~


"Frank Backes" <frank.backes_at_centif.de> wrote in message
news:a2ndev$t71$01$1_at_news.t-online.com...


> In order to defragment a single table on an 8.1.7 release I have exported

it


> using exp.exe. After I dropped the table I imported it with imp.exe and

> received an ORA-1438 (value larger than specified precision allows for

this


> column).

>

> How can this be? Any ideas?

>

>

>

>

Received on Wed Jan 23 2002 - 21:28:22 CST