Home » RDBMS Server » Server Utilities » ORA-01400 error when importing a dmp file
ORA-01400 error when importing a dmp file [message #73279] Tue, 16 March 2004 02:09 Go to next message
Praveen Kumar
Messages: 21
Registered: December 2001
Junior Member
hi,

i have a dmp file which i exported from a database.
that particular database is corrupted now .
i tried to import it to a new instance , after displaying that 2 tables are successfully imported it is giving an error for the third table.

it is stating that it will not accept null values , as the column is primary.

the error it is showing is ORA-01400

can anyone help me in this.
how to import such a dmp file, are ther any options to fill the value of those null records.

thanks,

praveen

 

 

 

 

Report message to a moderator

Re: ORA-01400 error when importing a dmp file [message #73281 is a reply to message #73279] Tue, 16 March 2004 03:27 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
either your exported dump is wrong
or
you are importing to a wrong schema/table
Please
POST your export session log
and
sample import session, table structure and EXACT ERROR message as it appears

Report message to a moderator

Previous Topic: export from remote server
Next Topic: URGENT: Restore database from datafiles
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 05:46:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.