The import process is the reverse process of the export process, through which we can import data and objects from the export file to the database.

The options available in the import process are:

1- Import tables.

2- Import user data.

3- Import Tablespaces.

4- Import a database.

It should be noted that any user who does not have the IMP_FULL_DATABASE privilege cannot import any object or data, and the steps that are taken during the import process can be summarized as follows:-

1- Create tables.

2- Import data.

3- Create indexes.

4- Import TRIGGERS.

5- Activate restrictions on tables.

6- Build functions.