OraFAQ Forum: Backup & Recovery » import problem

Home » RDBMS Server » Backup & Recovery » import problem (oracle 9)

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

import problem [message #394664]

Sun, 29 March 2009 12:30

mohaninforakle
Messages: 55
Registered: January 2009

Member

hai experts,

Now am in a trouble of importing dump into database.I formated my client system to install oracle newly before formating only i exported database so now only i have dump file.Then i created new database and tried to import that dump while importing its says the following messsage

imp-00019 row rejected due to oracle error 1400
imp 00003 oracle error 1400 encountered
ora-01400 cannot insert null into testcehema.tablename.columnname

Then this message contineously going import not completed.
I have attached the screen shot here.Please help me some body am i a hurry i have only one data to solve this problem please

Help me somebody.....

Attachment: update.JPG
(Size: 116.98KB, Downloaded 872 times)

Report message to a moderator

Re: import problem [message #394665 is a reply to message #394664]

Sun, 29 March 2009 12:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

I doubt you want to hear this, but in my opinion you are doing something wrong.

However, without being able to see how the export was done or how the import was invoked, I can not begin to guess specifics.

Report message to a moderator

Re: import problem [message #394666 is a reply to message #394664]

Sun, 29 March 2009 12:41

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

Senior Member
Account Moderator

Probably the issue existed in source database itself.
As said, unless we can see some proof on export methods, logs and status of table constraints, we cannot say it solid.

Report message to a moderator

Re: import problem [message #394667 is a reply to message #394664]

Sun, 29 March 2009 12:57

mohaninforakle
Messages: 55
Registered: January 2009

Member

thanks for your reply

I exported like this way

C:\>EXP SYSTEM/PASSWORD@MYDATABASE

FINALYY I HAVE GINVEN IMPORT ENTIRE EXPORT FILE = Y

So now what i have to do please reply for this

Report message to a moderator

Re: import problem [message #394668 is a reply to message #394664]

Sun, 29 March 2009 13:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm

Answers are contained in the manual above.
Best Wishes

Report message to a moderator

Re: import problem [message #394669 is a reply to message #394664]

Sun, 29 March 2009 13:10

mohaninforakle
Messages: 55
Registered: January 2009

Member

Thanks again for this link

I gone through this link,is there any way to skip that particule table while importing so that all other tables will be imported.Please reply

Report message to a moderator

Re: import problem [message #394670 is a reply to message #394664]

Sun, 29 March 2009 13:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>is there any way to skip that particule table while importing so that all other tables will be imported.
No.
How many tables were successfully imported before the errors started?

Report message to a moderator

Re: import problem [message #394671 is a reply to message #394669]

Sun, 29 March 2009 13:16

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

Senior Member
Account Moderator

>>so that all other tables will be imported.
I case you have not noticed, all other tables (that have no similar issues) will be imported.

A constraint is violating in a particular table.
You can just do an import without table data.
Manually disable the constraint for that particular table.
Do an import with data and ignore=y.
Since the table that is violating has the constraints disabled, it will just load all data, good and bad.
You can figure it later and enable the constraints back.

Report message to a moderator

Re: import problem [message #394672 is a reply to message #394664]

Sun, 29 March 2009 13:22

mohaninforakle
Messages: 55
Registered: January 2009

Member

Thanks again

actually two schemas has imported this the third schema some 20 tables after that its goes long time import not completed that particular problem of a table contains 4450 rows for every rows that error message apperas.So the import takes long time and finally its says an error time over.

Alleast can i no validating constraint until import completed.
Please reply i have 700 remaining tables to import

Report message to a moderator

Re: import problem [message #394674 is a reply to message #394664]

Sun, 29 March 2009 13:38

mohaninforakle
Messages: 55
Registered: January 2009

Member

thanks for your reply

I tried to import with out rows but i got strucked.The import aborted when that paticular table schema importing...
the error is

IMP-00009 Abnormal end of export file.

Here i have attached the screen shots.

Reply me please

Attachment: updates.JPG
(Size: 128.60KB, Downloaded 907 times)

Report message to a moderator

Re: import problem [message #394675 is a reply to message #394674]

Sun, 29 March 2009 13:40

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

Senior Member
Account Moderator

That is a dreaded message.
Did you ftp/transfer the dump file from one server to another?
Are you sure the dmp file is not correct?

Report message to a moderator

Re: import problem [message #394676 is a reply to message #394675]

Sun, 29 March 2009 13:43

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

Senior Member
Account Moderator

>>I tried to import with out rows but i got strucked.

Post your command line parameters.

Report message to a moderator

Re: import problem [message #394677 is a reply to message #394664]

Sun, 29 March 2009 13:45

mohaninforakle
Messages: 55
Registered: January 2009

Member

thanks again

Yes after i exported i transfered into other system.Because i reinstall oracle for virus was in my server so i supposed to transfer the dump to other server.After i did format,again i copied from dump into server.

Yes i copied into other system,form there i copied again to server and made an import.

reply me please

Report message to a moderator

Re: import problem [message #394678 is a reply to message #394664]

Sun, 29 March 2009 13:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

How big is the output file from export?
About how long did the export command run from start to finish?

Report message to a moderator

Re: import problem [message #394679 is a reply to message #394664]

Sun, 29 March 2009 13:47

mohaninforakle
Messages: 55
Registered: January 2009

Member

thanks for your reply

my exports done on normal time only finally i received an message that export completed successfully with warning

Report message to a moderator

Re: import problem [message #394681 is a reply to message #394664]

Sun, 29 March 2009 13:53

mohaninforakle
Messages: 55
Registered: January 2009

Member

the export file size is 305 mb

Report message to a moderator

Re: import problem [message #394683 is a reply to message #394664]

Sun, 29 March 2009 14:03

mohaninforakle
Messages: 55
Registered: January 2009

Member

hello mahesh sir am waiting for your reply.

I have only one day to correct this problem please am in hurry

Please reply my post.

Report message to a moderator

Re: import problem [message #394685 is a reply to message #394664]

Sun, 29 March 2009 14:21

mohaninforakle
Messages: 55
Registered: January 2009

Member

Please reply me am waiting here...

Report message to a moderator

Re: import problem [message #394686 is a reply to message #394685]

Sun, 29 March 2009 14:27

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

Senior Member
Account Moderator

There is nothing much we can do.
Hope you have not corrupted the dumpfile.
Post your command line parameters.
Start over. Clean the target and do import again.

Report message to a moderator

Re: import problem [message #394687 is a reply to message #394664]

Sun, 29 March 2009 14:30

mohaninforakle
Messages: 55
Registered: January 2009

Member

ok i will do my best.Thanks for your continuel reply.

Thanks a lot.

Report message to a moderator

Re: import problem [message #394689 is a reply to message #394687]

Sun, 29 March 2009 14:33

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

Senior Member
Account Moderator

For the third time I am asking
>>Post your command line parameters
to be specific, for your import session

Report message to a moderator

Re: import problem [message #394690 is a reply to message #394664]

Sun, 29 March 2009 14:45

mohaninforakle
Messages: 55
Registered: January 2009

Member

again i imported finally i got this message

IMP - 00028 Partial import of previous table rolled back.1404 row rolled back
IMP 00009 abnormal end of export file.Here i have attached the screen shot also.

Attachment: updates3.JPG
(Size: 102.51KB, Downloaded 856 times)

Report message to a moderator

Previous Topic:	rollforward issue
Next Topic:	TRANSPORT TABLESPACE Command problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 08:43:17 CDT 2024