Home » RDBMS Server » Server Utilities » Oracle table import fails
Oracle table import fails [message #74468] Thu, 16 December 2004 15:04 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
Hi,

I'm trying to import a table from the full export file. I had to truncate the table and need to reimport it now.

Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

Export file created by EXPORT:V08.01.05 via direct path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. importing LAND's objects into LAND
. . importing table                "LICENCE_MAINT"
IMP-00058: ORACLE error 1403 encountered
ORA-01403: no data found
IMP-00028: partial import of previous table rolled back: 9 rows rolled back
Import terminated successfully with warnings

Thanks,
Re: Oracle table import fails [message #74469 is a reply to message #74468] Fri, 17 December 2004 02:00 Go to previous message
Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...
Senior Member

Looks like there were no rows in the LICENCE_MAINT table when you took the export.

Can you be certain the rows existed when you took the export. Examine the export log.

Michael hartley

http://www.openfieldsolutions.co.uk
Previous Topic: test db refresh from production db - different platforms
Next Topic: how export and import oracle database 9i
Goto Forum:
  


Current Time: Wed Jul 03 16:37:19 CDT 2024