Oracle database export
Export an Oracle database is done using the exp. The exp command can be used with those options:
exp <Utilisateur>/<Mot de passe>@<Instance> [Parametres] exp <User> / <password> @ <Instance> [Settings]
Full database export
To export the entire contents of an Oracle database, use the exp command with the following parameters:On Dos:
- exp user/password@instance full=yes consistent=yes file='D:\exports\Export_Database_XXX.dmp' log='D:\exports\ Export_Database_XXX.dmp'
On Unix:
- xp user/password@instance full=yes consistent=yes file='/path/Export_Database_XXX.dmp' log='/path/Export_Database_XXX.dmp'
To export only a few tables
To export a few tables, use the exp command with the following parameters:
On Dos:
- exp USER/PASSWORD@INSTANCE TABLES=(noms,clients,comments) file='D:\exports\Export_Tables_Clients.dmp' log='D:\exports\Export_Tables_Clients.dmp'
On Unix:
- exp USER/PASSWORD@INSTANCE TABLES=(noms,clients,comments) file='/chemin/Export_Tables_Clients.dmp' log='/chemin/Export_Tables_Clients.dmp'
Parameters for exp command
The exp command supports the following parameters:
| help | Display help on export command |
| parfile | Filename parameters |
| USERID | Username and Password to connect to the database |
| FULL | Export entire file (N, default) |
| BUFFER | Size of data buffer |
| OWNER | List of users to export |
| FILE | Output filename (EXPDAT.DMP by default) |
| TABLES | List of tables to export |
| COMPRESS | Import in only 1 extent: compression (Y by default) |
| RECORDLENGTH | Record length |
| GRANTS | Export privileges (rights) (Y by default) |
| INCTYPE | Export type (incremental, cumulative or complete) |
| DIRECT | Optimized access to data (no SQL) |
| FEEDBACK n | Indicates the progress of the export table by table. 1 char is shown for n exported rows |
| INDEXES | Indexes export (Y by default) |
| RECORD | Marking of export INCREMENTAL (differentials) in the dictionary (Y by default) |
| ROWS | Export data (Y by default) |
| PARFILE | Parameter file (in this case, the options will be specified in this file) |
| CONSTRAINTS | Export constraints (Y by default) |
| CONSISTENT | Consistent image before export (updates allowed) |
| LOG | Name of the log file to generate |
| STATISTICS | Type of statistics to generate the import (compute, estimate or none) (ESTIMATE, by default) |