Home » RDBMS Server » Server Utilities » Urgent: Unable to import from dump file
Urgent: Unable to import from dump file [message #69789] Wed, 06 March 2002 03:55 Go to next message
Siddharth Bahri
Messages: 18
Registered: March 2001
Junior Member
Hi,

We are using Oracle 8.1.6 on Linux server.I am trying to import a table from a dump file taken the previous day which has the entire database export. I am gettint the following error during import:

IMP-00009: abnormal end of export file
IMP-00033: Warning: Table "COMPANY" not found in export file
Import terminated successfully with warnings.

The dmp file is 2.14GB. I have the log file of the export taken during the backup and it shows that the table was exported and export terminated sucessfully without warnings.

Can someone tell me what the problem is? Its Urgent.

Rgds.
Siddharth

Report message to a moderator

Re: Urgent: Unable to import from dump file [message #69795 is a reply to message #69789] Thu, 07 March 2002 10:15 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Have you tried this command:

imp system/PASSWORD fromuser=SCHEMANAME touser=SCHEMANAME TABLES=COMPANY

Where SCHEMANAME is the same for both. Don't use FULL.

Report message to a moderator

Previous Topic: HELPPP___NEW ORACLE USER!!
Next Topic: Backup Recovery
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 27 17:23:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.