Problem solve

IMP-00009 and IMP-00028 errors during import

I'm trying to import a dump file and I have the errors "IMP-00009: abnormal end of export file" and "IMP-00028."

Brian Peasland

By

Brian Peasland

Published: 22 Mar 2007

I'm trying to import a dump file and I have the errors "IMP-00009: abnormal end of export file" and "IMP-00028." The export file was made on Oracle 9.2.0.8, and I tried to import on Oracle 9.2.0.4. Is this error due to bad transfer or is it due to the Oracle version?

When transferring data between two different versions, follow these steps:

Use the lower version of exp to create the dump file. You can connect to a remote database with the exp utility by using a TNS alias when specifying the username:
```
exp [email protected]_alias full=y .....
```
Use the destination database's imp version.

But your versions are the same major versions and only different in patchset levels. And looking at your error message, I am guessing that the dump file was FTP'ed wrong. When you FTP the dump file, explicitly state 'bin' so as to transfer in binary mode. Some FTP utilities incorrectly sense the dump file to be an ASCII file and the transfer corrupts the dump file.

Dig Deeper on Oracle database backup and recovery

Related Q&A from Brian Peasland

Managing Oracle connections from third-party apps

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading

SearchDataManagement

7 data modeling techniques and concepts for business
Three types of data models and seven data modeling techniques are available to data management teams to convert mountains of ...
Couchbase NoSQL database adds relational capabilities
With its latest update, Couchbase introduced features that bring the equivalent of tables and schema to its database to reduce ...
Data architecture vs. information architecture: How they differ
Data architects collect the statistics and information architects put the numbers into context as they work symbiotically to ...

SearchBusinessAnalytics

Sisense unveils Extense Framework to enable embedded BI
After rebranding its platform early in 2021 to reflect a heightened focus on embedded analytics, Sisense introduced a set of new ...
Looker platform update adds new app development capabilities
Looker 21, which the vendor unveiled July 21, features the general availability of Looker's new portal for application developers...
SAS, Microsoft a possible pairing after Broadcom talks end
Acquisition talks between SAS and Broadcom broke down a day after they were reported, but SAS may have hoped all along to attract...

SearchSAP

IT complexity slows S/4HANA migration pace
Most S/4HANA projects are being held up by the complexity of SAP system environments, and organizations need to fully understand ...
Deloitte SAP Industry Cloud apps aim to fill ERP gaps
The head of Deloitte's $4 billion SAP practice explains the consultancy's role in SAP's new industry applications and how Kinetic...
Rise with SAP won't move S/4HANA needle for large customers
Rise with SAP is good for smaller companies, but if Rise is going to be a success, SAP will need to figure out how to attract its...

SearchSQLServer

SQL Server database design best practices and tips for DBAs
Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...
SQL Server in Azure database choices and what they offer users
SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...
Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL
In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

Introduction to Docker quiz
These Docker questions and answers will test your knowledge of the fundamentals of Docker, but it won't be easy. Take this quiz ...
Library vs. framework: How these software artifacts differ
Libraries are low-level components that deliver a specific function, such as establishing a network connection. A framework is a ...
Java naming conventions, explained
You could start a Java variable with a dollar sign, but no one does. When you write Java code, always follow these standard Java ...

SearchDataCenter

IBM z/OS V2.5 integrates mainframes with hybrid clouds, AI
Bringing mainframes deeper into the hybrid cloud mix, IBM delivered an updated version of z/OS that makes it easier for IT pros ...
Explore the benefits of data center as a service
For organizations that might struggle to purchase and maintain their own data centers, they can turn to DCaaS, which enables them...
Data center contactless tech beyond the pandemic
No-touch tech like haptics and LiDAR became commonplace during the coronavirus pandemic, but such technology can increase demands...

SearchContentManagement

What are the top Microsoft Power Apps limitations?
Organizations should understand the limitations of Microsoft Power Apps, such as licensing constraints and connection ...
Box Sign gives business users built-in digital signature tool
Box's $55 million acquisition of SignRequest in February yields a native digital signatures feature for Box Business and ...
Compare 7 headless CMS offerings and their key differences
This headless CMS comparison chart highlights five key differences, including use cases, features and more, between the top ...

SearchHRSoftware

Benefits and challenges of a hybrid workplace
Employees' desire for flexibility may lead organizations to explore a hybrid workplace, but hybrid work has strengths and ...
U.S. lawmaker seeks national four-day workweek
The four-day workweek could become law under legislation introduced by U.S. Rep. Mark Takano. It would require firms to pay ...
Badmouthing of federal gov hurts cybersecurity recruiting
Government and businesses are struggling with cybersecurity recruiting because of a skills shortage. The federal government's ...

Close