Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I find out no of rows in Export file - URGENT

Status
Not open for further replies.

vivekm

Programmer
Oct 4, 2000
76
GB

Hi,

Is there a way of finding out how many number of rows there are in my export .dmp file? When I use the SHOW clause, it gives me all the statements, crap, etc. I just want a summary, if possible.

Regards,
Vivek
 
It's in the log file generated when the export ran. If you don't have access to that then you could write a script (Shell or Perl) to parse the output of an import with show=y, just counting all of the "INSERT" statements for each table.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top