Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will be learning DataPump Commands.
1. İmport:
1 | # impdp "'/ as sysdba'" directory=csv_dir dumpfile=import.dmp logfile=import.log parallel=2 |
2. Export:
1 | # expdp "'/ as sysdba'" directory=dump_dir tables=users.session_data dumpfile=export.dmp logfile=export.log parallel=2 |
3. Dump file size estimation:
1 | # expdp "'/ as sysdba'" estimate_only=y tables=users.session_data_record logfile=n |
4. Remap schema:
1 2 3 | # expdp "'/ as sysdba'" directory=dump_dir tables=scott.session_data dumpfile=export.dmp logfile=export.log # impdp "'/ as sysdba'" directory=csv_dir dumpfile=export.dmp logfile=imp.log remap_schema=scott:emrah remap_tablespace=users:data_ts tables=scott.session_data_record |
5. Copy schema:
1 2 3 | # expdp "'/ as sysdba'" directory=dump_dir schema=scott dumpfile=exp.dmp logfile=exp.log # impdp "'/ as sysdba'" directory=dump_dir remap_schema=scott:emrah dumpfile=exp.dmp logfile=imp.log |
6. Copy schema – metadata only:
1 2 3 | # expdp "'/ as sysdba'" directory=dump_dir schema=scott dumpfile=exp.dmp logfile=exp.log # impdp "'/ as sysdba'" directory=dump_dir remap_schema=scott:emrah (content=metadata_only) dumpfile=exp.dmp logfile=imp.log |
7. First we create the parameter file (with Oracle User):
1 | # vi export.par |
A- We fill in the parameter file:
1 2 3 4 5 6 | directory=dump_dir dumpfile=exp.dmp logfile=exp.log tables=EMRAH.PERSONEL query=EMRAH.PERSONEL:"where id < 200" parallel=8 |
B- We start the export process;
1 | # nohup expdp "'/ as sysdba'" parfile=export.par $ |
