Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-1438 on Import (very urgent!!!!)

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

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 24 Jan 2002 16:22:01 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA79DB1DF@lnewton.leeds.lfs.co.uk>


Frank,

sorry no ideas at all, but ...

I've had a couple of funnies in the past with imp. I've had ORA-600s and a few others from time to time, no apparent reason, but I 'fixed' it by simply using buffer=1024000 on the imp command line.

On the other hand, why bother de-fragmenting a table, it makes no sense and does not increase performance. Rebuilding an index on a table which gets a lot of deletes WILL make a difference.

Good luck.

Norman.



Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com

------------------------------------------------------------------------

-----Original Message-----

From: Frank Backes [mailto:frank.backes_at_centif.de] Posted At: Wednesday, January 23, 2002 10:29 PM Posted To: server
Conversation: ORA-1438 on Import (very urgent!!!!) Subject: ORA-1438 on Import (very urgent!!!!)

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 Thu Jan 24 2002 - 10:22:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US