Login or Register to Ask a Question and Join Our Community


AIX

Issue while importing Oracle Dump File on AIX 5.3

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems AIX Issue while importing Oracle Dump File on AIX 5.3
# 1  
Old 12-26-2014
Tools Issue while importing Oracle Dump File on AIX 5.3
Hi All,

I am facing one problem related to importing Oracle Dump file.
We have two different version of AIX boxes with oracle (version 10.2.0.4.0) installed.
On one AIX box (version 6.1) we are creating oracle dump file (*.dmp) using oracle exp utility and importing it onto another AIX box (version 5.3) using
imp utility of oracle.

We are getting below error :
Code:
25 Dec 22:13 IMP-00010: not a valid export file, header failed verification
25 Dec 22:13 IMP-00000: Import terminated unsuccessfully

Any pointer would be highly appreciated.

Thanks & Regards
Gunjan.
Last edited by Don Cragun; 12-26-2014 at 12:37 PM.. Reason: Add CODE and ICODE tags.
# 2  
Old 12-26-2014
Hello Gunjan,

Welcome to forums, kindly use code tags as per forum rules for any commands or codes in your posts. You can refer following
link to go through from the forum rules.

https://www.unix.com/misc.php?do=cfrules


Now for your error, there may be following points here.
i- The most common cause with FTP is using an ASCII transfer and failing to use the binary flag.
ii- Importing into an earlier version of Oracle.
iii- Either the file was not generated by Export or it was corrupted.

Also following link may help you in same.
https://community.oracle.com/thread/...art=0&tstart=0


Thanks,
R. Singh
Last edited by RavinderSingh13; 12-26-2014 at 10:22 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Homework & Coursework Questions

Oracle dump file (del format) import into db2

1. The problem statement, all variables and given/known data: are the oracle dump files compatible to direct import into db2? I already tried many times but it always truncated results. anyone can help/ advice or suggest? 2. Relevant commands, code, scripts, algorithms: exp... (3 Replies)
Discussion started by: Sonny_103024
3 Replies

2. AIX

Production Issue in AIX Oracle RAC [errpt output : DUPLICATE IP ADDRESS DETECTED IN THE NET]

1)We have 2 node cluster RAC on AIX: ->test1 ->test3 2) After rebooting server both the node sequentailly, we are getting below error from errpt command : # errpt |more IDENTIFIER TIMESTAMP T C RESOURCE_NAME DESCRIPTION FE2DEE00 0901223914 P S SYSXAIXIF DUPLICATE IP ADDRESS... (2 Replies)
Discussion started by: manjusharma128
2 Replies

3. UNIX and Linux Applications

How to import and dump file to remote Oracle server?

Hi All, I have a linux centos instance which has a dump file. I need to import the dump file to the oracle server which is located at some remote location. I have installed the oracle client on my machine and I am able to connect to the remote oracle server. Now how to import the dump to the... (3 Replies)
Discussion started by: Palak Sharma
3 Replies

4. UNIX for Dummies Questions & Answers

How can I import a particular schema from full dump in Oracle?

Hi All, I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump. Is that possible in oracle. What will be the command for that? (6 Replies)
Discussion started by: Palak Sharma
6 Replies

5. AIX

Oracle Db Dump compression issue

Dear All, I am trying to backup Databases in my company which installed on AIX oracle 10g. From the start they have not used the archives to backup DB. Instead they use expdp utility to export the data in to dump file and rename the file extension to .tmp and ftp to another machine to compress... (5 Replies)
Discussion started by: thameerakn
5 Replies

6. Solaris

Primary key issue when running Oracle sql file

I got a issue with running the following script below if I remove the inserts and alter table the tables will install just fine but if I try and do the full thing in one go i get the below error dose any one have any ideas on this problem? its got me spinning, thanks. REM REM List of... (1 Reply)
Discussion started by: Wpgn
1 Replies

7. Shell Programming and Scripting

Connection to Oracle data and dump text file

Hi for all! I need for my job one shell script very concrete about connection to oracle databases and writing to text file. Well I tell you: 1.- I must read a file as parameter from linux interface: > example.sh fileToRead 2.-I must read line to line in "fileToRead" and take a... (9 Replies)
Discussion started by: wien996
9 Replies

8. Emergency UNIX and Linux Support

Core Dump Issue

Hi In SunOS the gdb command outputs the following info. ---Type <return> to continue, or q <return> to quit--- Reading symbols from /opt/dcs_5.1/lib/libssl.so...done. Loaded symbols for /opt/dcs_5.1/lib/libssl.so Reading symbols from /opt/dcs_5.1/lib/libcrypto.so...done. Loaded symbols for... (1 Reply)
Discussion started by: kumaran_5555
1 Replies

9. Shell Programming and Scripting

Importing dump file

Hi, I am trying to import 22 .dmp files but facing the problem with the last table file it never ends the import command, only the table is created but the rows of the table don't get imported. This is the problem with only ine table rest 21 tables are being imported properly. Thanks in... (2 Replies)
Discussion started by: anushilrai
2 Replies

10. UNIX for Dummies Questions & Answers

Importing a unix file dump into a PC capable database

My development team has been trying to figure out how to import a unix data dump into SQL Server or convert it into an intermediate file format for several days. The data dump in question looks like this: $RecordID: 1<eof> $Version: 1<eof> Category: 1<eof> Poster: John Doe<eof>... (7 Replies)
Discussion started by: DaltonF
7 Replies
Login or Register to Ask a Question