Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle Data Pump Example     - Linux System Getting Started Learning: Linux common log file (Linux)

- Subquery Oracle study notes (Database)

- Android Send HTTP POST requests (Programming)

- GitLab installation configuration notes (Linux)

- Install Oracle database error process of [INS-35172] (Database)

- Python extension module Ganglia 3.1.x (Linux)

- Chkconfig command Detailed service is added and shut down the system in two ways to start service under Linux (Linux)

- Ten SCP transfer command example (Linux)

- CentOS 6.4 compiler installed MySQL 5.6.14 (Database)

- Use mdadm tool to create software RAID 0 (Linux)

- Remote database using RMAN recovery test (RAC return to single-instance database) (Database)

- Some of the bibliographic management tools to good use on linux (Linux)

- C / C ++ language variable scope: local variables, global variables, file-level variables (Programming)

- Examples of Exploration Class File (Programming)

- Ubuntu users to install Xtreme Download Manager (Linux)

- Nginx supports user multi-threaded downloads and resume broken (Server)

- RedHat Linux 9.0 under P4VP-MX motherboard graphics resolution of problems (Linux)

- PostgreSQL procedural language learning (Database)

- To control based on IP address routing policy under Linux (Linux)

- Household use Linux Security (Linux)

 
         
  Oracle Data Pump Example
     
  Add Date : 2018-11-21      
         
       
         
  Oracle Data Pump example, the main export Examples:

1. Export specified table space:

expdp system / xxx DIRECTORY = dump_dir tableapace = xxx dumpfile = xxx_% DATE: ~ 0,4 %% DATE: ~ 5,2 %% DATE: ~ 8,2% "dmp logfile = xxx.log.

Seemingly only export tables, indexes, and triggers, so it is still using the specified schema way better

2. Export specified schema:

expdp system / xxx DIRECTORY = dump_dir schemas = xxx dumpfile = xxx_% DATE: ~ 0,4 %% DATE: ~ 5,2 %% DATE: ~ 8,2% "dmp logfile = xxx.log.

This way you can export all the objects under the schema

3. Export specified table:

expdp user / xxx DIRECTORY = dump_dir DUMPFILE = dept.dmpTABLES = T1, T2 logfile = xxx.log;

4. Parallel Export:

expdp system / xxx schemas = xxx DIRECTORY = dump_dir PARALLEL = 3 dumpfile = KDJM2008-11-28_% U.dmp logfile = xxx.log

5. Metadata export options:

content = metadata_only
     
         
       
         
  More:      
 
- Eight sorting algorithm implemented in Python (Programming)
- To use yum install VLC under CentOS (Linux)
- ORA-01157 & ORA-01110 Troubleshooting (Database)
- The Rabbitmq installation under CentOS 6.4 (Linux)
- C ++ input and output summary _ Input (Programming)
- Getting the Linux shell variable test (Programming)
- Confrontation dragged Library - Web front-end encryption slow (Linux)
- VMware virtual machine to use bridged mode fast Internet access (Linux)
- grep command Detailed and relevant examples (Linux)
- Ubuntu users to install household financial management tools HomeBank 5.0.0 (Linux)
- Install Linux Mint 17: 20 things to do (Linux)
- CMake Quick Start Tutorial (Linux)
- JavaScript prototype and prototype chain and project combat (Programming)
- Gitlab installation under CentOS 7 (Linux)
- Use libpq under Ubuntu 14.04 (Linux)
- The compiler installed Kaldi under Ubuntu 12.04 (Linux)
- IronPython and C # to interact (Programming)
- Optimized to minimize the installation of CentOS 5.8 (Linux)
- CentOS iptables firewall configuration (Linux)
- Linux Crontab Timing task command Detailed (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.