Import an Oracle database
Oracle database import is done using the "imp" command.
Imp command use the following parameters:
exp <User>/<Password>@<Instance> [Parameters]
Import all database
To import all Oracle database contents, use the exp command with the following parameters:
On Dos:
- imp USER/PASSWORD@INSTANCE full=yes file='D:\exports\Export_Database_XXX.dmp' log='D:\exports\Import_Database_YYY.dmp' FROMUSER=UserXXX TOUSER=UserYYY
On Unix:
- imp USER/PASSWORD@INSTANCE full=yes file='/path/Export_Database_XXX.dmp' log='/path/Import_Database_YYY.dmp' FROMUSER=UserXXX TOUSER=UserYYY
Import only a few tables
To import only a few tables, use the imp command with the following parameters:
On Dos:
- imp USER/PASSWORD@INSTANCE TABLES=(noms,clients,comments) file='D:\exports\Export_Tables_Clients.dmp' log='D:\exportsImport_Tables_Clients.dmp' FROMUSER=UserXXX TOUSER=UserYYY
On Unix:
- imp USER/PASSWORD@INSTANCE TABLES=(noms,clients,comments) file='/chemin/Export_Tables_Clients.dmp' log='/chemin/Import_Tables_Clients.dmp' FROMUSER=UserXXX TOUSER=UserYYY
Imp command parameters
imp command supports the following parameters
| HELP | Display help of import command |
| USERID | Username and password for the connection |
| FULL | Import all file (Y, by default) |
| BUFFER | Size of data buffer |
| FROMUSER | List of exported owners (old users) |
| FILE | File used to import (EXPDAT.DMP, default) |
| TOUSER | List of destination owners |
| SHOW | Only show objects to import (N, by default) |
| TABLES | List of tables to import |
| IGNORE | Ignore errors due to already existing objects (N, default; necessary) |
| RECORDLENGTH | Record Length |
| GRANTS | Import rights (Y, default) |
| INCTYPE | Differential import type |
| INDEXES | Import indexes (Y, default, required) |
| COMMIT | Commit packet by packet (N, default) |
| ROWS | Import the contents of tables (Y, default) |
| PARFILE | Parameter file (in this case, the options will be specified in this file) |
| LOG | Name of the log file to generate |
| DESTROY | Overwrite Tablespace file (N, default) |
| INDEXFILE | Write tables and indexes in the specified file |
| CHARSET | Character to use (NLS_LANG, default) |
| FEEDBACK n | Indicates the progress of the export table by table. 1 char is shown for n exported rows |