This script will allow an Oracle DBA to see how many rows were imported or exported and is especially useful with big tables. The import command should have one (or both) of these options:
In this case, open a SQL*PLUS window or use svrmgrl to see how many rows were imported:
SELECT COUNT(*) from
This select may take (very) long time to perform and so it should be used only for importing.
The second option is:
You will get a dot on the screen for every NNNN number of rows imported. The information is not very accurate but I consider it to be a very good solution when you need to have just an approximate idea of the import and to be certain that the import didn't hang. The value for NNNN is up to you. A small value will fill the screen with dots but will give you nice feedback. It works for both import and export.
For More Information
- What do you think about this tip? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle tip to offer your fellow DBA's? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical Oracle questions--or help out your peers by answering them--in our live discussion forums.
- Check out our Ask the Experts feature: Our SQL, Database Design, Oracle, SQL Server, and DB2 gurus are waiting to answer your toughest questions.