Let us assume here that the database administrator wants to import the EMPLOYEE table from the export file to the VBS user, knowing that the EMPLOYEE table was exported from the VBS user.

IMP SYSTEM/SYS FILE=C:\E\FULL.DMP TABLES=EMPLOYEE FROMUSER=VBS TOUSER=VBS IGNORE=Y

The EMPLOYEE table was imported to the VBS user by the database manager. Note that we used the variables FROMUSER & TOUSER to identify the user from whom we exported the table and to identify the user to whom we imported it. It may not be necessary to use the TOUSER variable here because the table will be imported to the same user from whom we exported it. However, It is necessary if the user we issued from and the variable we will import to has changed, and we also used the variable IGNORE to ignore error messages that indicate that this table exists in the user.

Of course, other variables can be used, for example ROWS=N to import the table without data, and other variables according to the requirements.