Home » RDBMS Server » Server Utilities » Export/Import (Oracle 2003)
Export/Import [message #509656] Tue, 31 May 2011 00:02 Go to next message
Messages: 53
Registered: January 2011
Location: Mumbai
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

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

Re: Export/Import [message #509664 is a reply to message #509661] Tue, 31 May 2011 02:49 Go to previous message
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: Mon Nov 30 16:45:02 CST 2015

Total time taken to generate the page: 0.09117 seconds