OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » import (oracle 9i)

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

import [message #520151]

Thu, 18 August 2011 16:36

zodiacsom
Messages: 37
Registered: December 2009
Location: pune

Member

Hi all

I am facing problem during imp FYI

RV10GT(oracle):/home/oracle>imp '"sys/sys as sysdba"' file=/home/oracle/rv41_ap_blank25july11.dmp full=y log=/home/oracle/rv41_ap_blank25july11.log

Import: Release 8.1.6.0.0 - Production on Thu Aug 18 17:33:06 2011

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully

please help me ..

thanx .

Report message to a moderator

Re: import [message #520155 is a reply to message #520151]

Thu, 18 August 2011 17:48

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

Senior Member
Account Moderator

Seems your dmp file is corrupt.
Did you FTP the file?

And the versions are way different.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#i1013164
But I don't that is the problem. 8i to 10g should be possible.

[Updated on: Thu, 18 August 2011 17:53]

Report message to a moderator

Re: import [message #520157 is a reply to message #520155]

Thu, 18 August 2011 20:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I am facing problem during imp FYI
>RV10GT(oracle):/home/oracle>imp '"sys/sys as sysdba"' file=/home/oracle/rv41_ap_blank25july11.dmp full=y log=/home/oracle/rv41_ap_blank25july11.log
>Import: Release 8.1.6.0.0 - Production on Thu Aug 18 17:33:06 2011

importing using V8.1.6 utility into V10 DB could be problematic.

Which DB was source version & which version of "exp" utility created the dump file?

>import (oracle 9i)
why does topic header state 9i when it is NOT mentioned in post details while V8 & V10 are.

[Updated on: Thu, 18 August 2011 20:20]

Report message to a moderator

Re: import [message #520235 is a reply to message #520157]

Fri, 19 August 2011 08:09

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

BlackSwan wrote on Thu, 18 August 2011 21:18

why does topic header state 9i when it is NOT mentioned in post details while V8 & V10 are.

Probably because it is the average Wink

Report message to a moderator

Re: import [message #520248 is a reply to message #520235]

Fri, 19 August 2011 12:29

zodiacsom
Messages: 37
Registered: December 2009
Location: pune

Member

thank a lot ...

but i am searching for solution can any one help .... Smile

FYI

RV10GT(oracle):/u01/app/oracle/product/10.2.0/bin>imp

Import: Release 8.1.6.0.0 - Production on Fri Aug 19 12:16:34 2011

(c) Copyright 1999 Oracle Corporation. All rights reserved.

but database version is 10.2.0 ... this is condition of my client(USA) server.
and i have to import

Report message to a moderator

Re: import [message #520249 is a reply to message #520248]

Fri, 19 August 2011 12:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post results from following OS commands

id
env | sort

it appears that PATH is not as desired/expected.

Report message to a moderator

Re: import [message #520250 is a reply to message #520248]

Fri, 19 August 2011 12:37

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

zodiacsom wrote on Fri, 19 August 2011 19:29

thank a lot ...

but i am searching for solution can any one help ....
FYI

RV10GT(oracle):/u01/app/oracle/product/10.2.0/bin>imp

Import: Release 8.1.6.0.0 - Production on Fri Aug 19 12:16:34 2011

(c) Copyright 1999 Oracle Corporation. All rights reserved.

but database version is 10.2.0 ... this is condition of my client(USA) server.
and i have to import

What is not possible is not possible.
imp 8.1.6 can't understand an export file from 10.2.
So change the client for a 10.2 one or do not import.

Regards
Michel

Report message to a moderator

Previous Topic:	Problem Loading Data into Table- Tow fields appended & Converted into DateTime
Next Topic:	problem using sqlldr(2 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 13:39:16 CST 2025