What is the use of ROWS option in IMP command?

by

The ROWS option indicates whether the table rows should be imported.

In Oracle, the ROWS option in the IMP (Import) command is used to specify the number of rows to import. This option allows you to control the import process by specifying a limit on the number of rows that should be imported from the export file.

For example, if you want to import only a specific number of rows from a larger export file, you can use the ROWS option to set a limit on the number of rows to be imported.

Here’s a basic syntax example:

IMP username/password@dbname TABLES=(table_name) ROWS=y

In this example, table_name is the name of the table you want to import, and ROWS=y indicates that you want to include the ROWS option in the import process.

Please note that the actual syntax and usage may vary based on the specific version of Oracle you are using. Always refer to the Oracle documentation corresponding to your Oracle database version for accurate and up-to-date information.