Home » RDBMS Server » Backup & Recovery » import problem (oracle 9)
import problem [message #394664] Sun, 29 March 2009 12:30 Go to next message
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 147 times)
Re: import problem [message #394665 is a reply to message #394664] Sun, 29 March 2009 12:38 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: import problem [message #394666 is a reply to message #394664] Sun, 29 March 2009 12:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: import problem [message #394667 is a reply to message #394664] Sun, 29 March 2009 12:57 Go to previous messageGo to next message
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
Re: import problem [message #394668 is a reply to message #394664] Sun, 29 March 2009 13:00 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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
Re: import problem [message #394669 is a reply to message #394664] Sun, 29 March 2009 13:10 Go to previous messageGo to next message
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
Re: import problem [message #394670 is a reply to message #394664] Sun, 29 March 2009 13:14 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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?
Re: import problem [message #394671 is a reply to message #394669] Sun, 29 March 2009 13:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: import problem [message #394672 is a reply to message #394664] Sun, 29 March 2009 13:22 Go to previous messageGo to next message
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
Re: import problem [message #394674 is a reply to message #394664] Sun, 29 March 2009 13:38 Go to previous messageGo to next message
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 165 times)
Re: import problem [message #394675 is a reply to message #394674] Sun, 29 March 2009 13:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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?
Re: import problem [message #394676 is a reply to message #394675] Sun, 29 March 2009 13:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: import problem [message #394677 is a reply to message #394664] Sun, 29 March 2009 13:45 Go to previous messageGo to next message
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
Re: import problem [message #394678 is a reply to message #394664] Sun, 29 March 2009 13:45 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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?
Re: import problem [message #394679 is a reply to message #394664] Sun, 29 March 2009 13:47 Go to previous messageGo to next message
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
Re: import problem [message #394681 is a reply to message #394664] Sun, 29 March 2009 13:53 Go to previous messageGo to next message
mohaninforakle
Messages: 55
Registered: January 2009
Member
the export file size is 305 mb


Re: import problem [message #394683 is a reply to message #394664] Sun, 29 March 2009 14:03 Go to previous messageGo to next message
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.
Re: import problem [message #394685 is a reply to message #394664] Sun, 29 March 2009 14:21 Go to previous messageGo to next message
mohaninforakle
Messages: 55
Registered: January 2009
Member


Please reply me am waiting here...

Re: import problem [message #394686 is a reply to message #394685] Sun, 29 March 2009 14:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: import problem [message #394687 is a reply to message #394664] Sun, 29 March 2009 14:30 Go to previous messageGo to next message
mohaninforakle
Messages: 55
Registered: January 2009
Member


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

Thanks a lot.
Re: import problem [message #394689 is a reply to message #394687] Sun, 29 March 2009 14:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: import problem [message #394690 is a reply to message #394664] Sun, 29 March 2009 14:45 Go to previous message
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 176 times)
Previous Topic: rollforward issue
Next Topic: TRANSPORT TABLESPACE Command problem
Goto Forum:
  


Current Time: Fri Dec 09 06:17:59 CST 2016

Total time taken to generate the page: 0.05701 seconds