Home » RDBMS Server » Server Utilities » Export/Import (Oracle 10.2.0.4.0/Windows 2003)
Export/Import [message #509656] Tue, 31 May 2011 00:02 Go to next message
gxeon
Messages: 53
Registered: January 2011
Location: Mumbai
Member
Hello Sir

I am new to Oracle DBA. m facing one problem. i imported and exported my data from one oracle DB to another by using exp/imp.....in both exp/imp log files, its shows the fallowing messages at the end.

"Import terminated successfully with warnings."
"Export terminated successfully with warnings."

but when i count there are some rows missing in some tables...

what could be the cause? is there any other way to cross check whether export/import was successful...

please help

Gaurav
Re: Export/Import [message #509661 is a reply to message #509656] Tue, 31 May 2011 01:24 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Check the error message in the log file.


Sriram
Re: Export/Import [message #509664 is a reply to message #509661] Tue, 31 May 2011 02:49 Go to previous message
convertin
Messages: 14
Registered: May 2007
Junior Member
How did you find that some records missing in the generated database? Are you sure that those records present in the dump file? If one of missing records contains an unique text you can find it in the dump using any hexadecimal viewer.
Previous Topic: Concatenating dashes in a column using sqlldr
Next Topic: How do you import a database?
Goto Forum:
  


Current Time: Thu Mar 28 06:07:00 CDT 2024