OraFAQ Forum: Server Utilities » Facing Problem during Importing Data using IMP.

Home » RDBMS Server » Server Utilities » Facing Problem during Importing Data using IMP.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Facing Problem during Importing Data using IMP. [message #74742]

Thu, 10 February 2005 20:47

Darshan Kinariwala
Messages: 2
Registered: February 2005

Junior Member

Dear sir,

I have Daily Backup using Oracle's Exp / Imp Command line utilities.. I am using Oracle 9.0.1..

I am facing Error IMP-00058... and ORA-01483...
and it dosen't allow me to import a Specific Table due. abow Error Code...

Plz... I need your Kind help ...SOS...

Darshan

Report message to a moderator

IMP-00058:Oralce Error 1438 encountered. [message #74744 is a reply to message #74742]

Fri, 11 February 2005 02:26

Darshan Kinariwala
Messages: 2
Registered: February 2005

Junior Member

Export File Created By Export V09.00.01 via conventional Path

Import Done in WE8MSWIN1252 Character Set and AL16UTF16 NCHAR Character Set.

Error Message:

IMP-00058:Oralce Error 1438 encountered.
ORA-01438:Value Larger Than Specified precision allow for this Column

Report message to a moderator

Re: IMP-00058:Oralce Error 1438 encountered. [message #74746 is a reply to message #74744]

Fri, 11 February 2005 03:53

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>I have Daily Backup using Oracle's Exp / Imp Command line utilities

export using exp utility is NEVER been an IDEAL backup.

look into your import.log. get the name of concerned table.
check your export.log . see whether the concerned table is exported properly.

If you are importing only the data and not structure using ignore=y during import,
a good chance is the mismatch in table structure between the target and source databases.

Report message to a moderator

Re: IMP-00058:Oralce Error 1438 encountered. [message #74763 is a reply to message #74744]

Mon, 14 February 2005 00:42

devika
Messages: 21
Registered: November 2004

Junior Member

Check the block size of the source and destination. Both the block size should match else create a non-standard block size in the destination and then import

Report message to a moderator

Previous Topic:	Renaming a database
Next Topic:	sqlldr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 07:46:21 CDT 2024