Home » RDBMS Server » Server Utilities » Import termination
Import termination [message #74669] Tue, 01 February 2005 22:14 Go to next message
Helge
Messages: 1
Registered: February 2005
Junior Member
Hi all,

my problem is as follows:

I exported a complete Oracle database using exp from Oracle 8.1.6 running on AIX (no incremental export or such things). I copied the export (about 4GB in 4 files) to a Sun and tried to import it there into an empty Oracle instance. I just wanted to have the data of a particular user so I used the fromuser= and touser= parameters.

Everything worked fine but one table could not be loaded because imp stated:

IMP-00058: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column.

Does anybody have an idea?

Thanks in advance

Helge

Report message to a moderator

Re: Import termination [message #137778 is a reply to message #74669] Fri, 16 September 2005 14:29 Go to previous message
caputt
Messages: 1
Registered: September 2005
Junior Member
Helge wrote on Tue, 01 February 2005 22:14

Hi all,

my problem is as follows:

I exported a complete Oracle database using exp from Oracle 8.1.6 running on AIX (no incremental export or such things). I copied the export (about 4GB in 4 files) to a Sun and tried to import it there into an empty Oracle instance. I just wanted to have the data of a particular user so I used the fromuser= and touser= parameters.

Everything worked fine but one table could not be loaded because imp stated:

IMP-00058: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column.

Does anybody have an idea?

Thanks in advance

Helge

Report message to a moderator

Previous Topic: EXP/IMP or Copy data over T1 lines
Next Topic: Oracle - MS SQL-Server Transparent Gateway not working
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 22:59:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.