OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » EXP/IMP 8.0.5 (Oracle 8.0.5, winXP SP2)

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

EXP/IMP 8.0.5 [message #432054]

Fri, 20 November 2009 13:17

ahmadsaeed
Messages: 24
Registered: November 2009
Location: Lahore, Pakistan

Junior Member

Dear all,
I am working on an experiment where need to import some data from oracle sysetm to another.
Both the systems have oralce 8.0.5 installed
i used the EXP80 command in the System1 and then tried to import in the system creating the user with same name that was in system1
and the problem rises here.
i recieved this message.
---
The command:
mp80.EXE file=D:\file.DMP fromuser=user touser=user buffer=10000000 commit=y ignore=y skip_unusable_indexes=y
-----------

and the result was:

Connected to: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production

Export file created by EXPORT:V08.00.05 via conventional path

. . importing table "AUDIT_STOCK_POSITION"
11/21/2009 12:14:08 AM: Terminated

can we do something abt it ?
or some other way that can be helpfull in this regard.

Thanks.
Ahmad Saeed
ahmadsaeed321@mail.com

Report message to a moderator

Re: EXP/IMP 8.0.5 [message #432056 is a reply to message #432054]

Fri, 20 November 2009 13:20

ahmadsaeed
Messages: 24
Registered: November 2009
Location: Lahore, Pakistan

Junior Member

This was missed in the post

IMP-00009: abnormal end of export file

IMP-00018: partial import of previous table completed: 294903 rows imported

Import terminated successfully with warnings.

Report message to a moderator

Re: EXP/IMP 8.0.5 [message #432057 is a reply to message #432056]

Fri, 20 November 2009 13:25

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Posibility 1: There was an error during the export. Have you looked at the export log, if the export was successfull?

Posibility 2: The file got damaged during the transfer. Check if the file size is the same as on the original export machine. (You didn't transfer it in ASCII mode per ftp by chance? That would damage it.)

Report message to a moderator

Re: EXP/IMP 8.0.5 [message #432064 is a reply to message #432056]

Fri, 20 November 2009 15:17

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

Senior Member

Also could be because you hit the maximum 2gb size in the file. I think before 8i, you could make export files larger than 2gb, but you could not import past the 2gb marker.

Report message to a moderator

Re: EXP/IMP 8.0.5 [message #432084 is a reply to message #432064]

Sat, 21 November 2009 00:23

ahmadsaeed
Messages: 24
Registered: November 2009
Location: Lahore, Pakistan

Junior Member

if i import the same file in 10g , will it solve the space issue.
i think 10g can import more than 2gb. the dmp file size was 16mb.

Report message to a moderator

Re: EXP/IMP 8.0.5 [message #432137 is a reply to message #432084]

Sat, 21 November 2009 16:03

ahmadsaeed
Messages: 24
Registered: November 2009
Location: Lahore, Pakistan

Junior Member

Dear all,
Thanks a lot for the support i have successfully import the data in new installation.
Actually there was some problem in dmp file. i made another backup and all went fine.
thanks again

Report message to a moderator

Previous Topic:	SQl loader
Next Topic:	Will Import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 21:00:47 CDT 2024