Home » RDBMS Server » Server Utilities » EXP/IMP 8.0.5 (Oracle 8.0.5, winXP SP2)
EXP/IMP 8.0.5 [message #432054] Fri, 20 November 2009 13:17 Go to next message
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
Re: EXP/IMP 8.0.5 [message #432056 is a reply to message #432054] Fri, 20 November 2009 13:20 Go to previous messageGo to next message
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.
Re: EXP/IMP 8.0.5 [message #432057 is a reply to message #432056] Fri, 20 November 2009 13:25 Go to previous messageGo to next message
ThomasG
Messages: 3186
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.)
Re: EXP/IMP 8.0.5 [message #432064 is a reply to message #432056] Fri, 20 November 2009 15:17 Go to previous messageGo to next message
joy_division
Messages: 4618
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.
Re: EXP/IMP 8.0.5 [message #432084 is a reply to message #432064] Sat, 21 November 2009 00:23 Go to previous messageGo to next message
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.
Re: EXP/IMP 8.0.5 [message #432137 is a reply to message #432084] Sat, 21 November 2009 16:03 Go to previous message
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
Previous Topic: SQl loader
Next Topic: Will Import
Goto Forum:
  


Current Time: Sat Oct 01 02:31:52 CDT 2016

Total time taken to generate the page: 0.08699 seconds