Problem solve Get help with specific problems with your technologies, process and projects.

Monitor the import or export of an Oracle database

A script that will allow a DBA to see how many rows were imported or exported and is especially useful with big tables.

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:

  COMMIT=Y  

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:

  FEEDBACK=NNNN 

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 [email protected] 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.

Dig Deeper on Oracle database export, import and migration

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close