Oracle Database Data Pump Step 9 : Import Commands
Example
Prerequisite:
- Prior to user import it is a good practice to drop the schema or table imported.
Commands:
impdp <bkpadmin>/<bkp123> parfile=<imp.par>
*Please replace the data in <> with appropriate values as per your environment. You can add/modify parameters as per your requirements. In the above example all the remaining parameters are added in parameter files as stated below: *
- Import Type : User Import
- Import entire schema
- Parameter file details [say imp.par] :
schemas=<schema>
directory= DATAPUMP_REMOTE_DIR
dumpfile=<dbname>_<schema>.dmp
logfile=imp_<dbname>_<schema>.log
- Import Type : User Import for large schema
- Import entire schema for large datasets: Parallelism is used here (Note : Adding parallelism will increase the CPU load on server)
- Parameter file details [say imp.par] :
schemas=<schema>
directory= DATAPUMP_REMOTE_DIR
dumpfile=<dbname>_<schema>_%U.dmp
logfile=imp_<dbname>_<schema>.log
parallel=5
- Import Type : Table Import [ Import set of tables]
- Parameter file details [say imp.par] :
tables= tname1, tname2, tname3
directory= DATAPUMP_REMOTE_DIR
dumpfile=<dbname>_<schema>.dmp
logfile=exp_<dbname>_<schema>.log
TABLE_EXISTS_ACTION= <APPEND /SKIP /TRUNCATE /REPLACE>
