OraFAQ Forum: Server Utilities » ORA-01400: cannot insert NULL into ROW

Home » RDBMS Server » Server Utilities » ORA-01400: cannot insert NULL into ROW_ID

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

ORA-01400: cannot insert NULL into ROW_ID [message #572818]

Mon, 17 December 2012 22:34

ravidwivedi2288
Messages: 8
Registered: December 2012
Location: Malaysia

Junior Member

hi m facing the above error while tryin to run my control file in sqlloader
as i need to load the csv data into oracle
can anyone guide me wat sequence i need to write so that i do not face the above error.

Report message to a moderator

Re: ORA-01400: cannot insert NULL into ROW_ID [message #572821 is a reply to message #572818]

Mon, 17 December 2012 22:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: ORA-01400: cannot insert NULL into ROW_ID [message #572832 is a reply to message #572818]

Tue, 18 December 2012 01:11

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

Senior Member
Account Moderator

Quote:

can anyone guide me wat sequence i need to write so that i do not face the above error.

You have to analyze where does the problem come investigating the various generated files and accordingly fix your data or control file.

Regards
Michel

Report message to a moderator

Previous Topic:	Need to copy table with NCLOB column into another database (10g to 11g)
Next Topic:	IMPDP from 10.2.0.1.0 to 11.2.0.3 leads to empty tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 06:22:29 CDT 2025