Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Instead of rewriting the commands each time, we can use a parameter file to export/Import with Data Pump.
1. First we create the parameter file.
1 2 3 4 5 6 7 | $ vi parametre.par directory=data_pump_dir dumpfile=exp.dmp logfile=exp.log tables=EMRAH.PERSONEL ~ |
2. Then we start the export process.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | $ expdp parfile=parametre.par Export: Release 11.2.0.1.0 - Production on Mon Nov 3 17:28:13 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username: sys as sysdba Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Starting "SYS"."SYS_EXPORT_TABLE_01": sys/******** AS SYSDBA parfile=parametre.par Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 64 KB Processing object type TABLE_EXPORT/TABLE/TABLE . . exported "EMRAH"."PERSONEL" 16.81 KB 107 rows Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYS.SYS_EXPORT_TABLE_01 is: /u01/app/oracle/admin/catalog/dpdump/exp.dmp Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 17:28:30 |
