Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-1438 on Import (very urgent!!!!)
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