How to Recover an Oracle Database From a Full Export
You must use a specific command at the terminal prompt to recover or import a full Oracle database export. This command not only imports the data into memory, but also writes it to disk or a backup tape. Oracle's import utility also handles imports of individual information like user data, tables and tablespaces. These items are all included when doing a full import from a full export file.
Other People Are Reading
Instructions
-
-
1
Go to the terminal prompt on your Linux or Unix based computer.
-
2
Browse to the directory where the Oracle database export file is located.
-
-
3
Type the following command at the prompt:
imp file=filename
-
4
Replace the "filename" value with the actual name of the full Oracle database export dump. Press the Enter key.
-
5
Enter your Oracle username and password when prompted. The program then imports the export file as a new database in the Oracle database system.
-
1
