Home IT Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle Data Pump Example     - About Auto Layout and frame (Programming)

- JDK installation under CentOS (Linux)

- Bash variable expansion modifier (Programming)

- How to use the Linux terminal Git commands (Linux)

- Linux System Getting Started Learning: Change the name of the network interface on CentOS7 (Linux)

- Change all child files and subdirectories in the owner permissions Ubuntu (Linux)

- Usage Linux device tree (Programming)

- AngularJS - Getting Started with Routing (Programming)

- How to monitor Linux system performance Nmon (Linux)

- Linux ldconfig command (Linux)

- To setup Cocos2dx project under Ubuntu (Linux)

- How to customize your Linux desktop: Gnome 3 (Linux)

- How to Install Winusb in Ubuntu 14.04 (Linux)

- Bash environment is automatically install and initialize oh-my-zsh & autojump zsh (Linux)

- Installation and management of Linux applications (Linux)

- Python console achieve progress bar (Programming)

- Install Ubuntu open source drawing program MyPaint 1.2.0 (Linux)

- Strategy Games Ubuntu installation of Wesnoth 1.12.1 (Linux)

- CentOS6 installed Tomcat (Server)

- Based on Google Cloud Storage Mirroring open Maven Central Repository (Server)

  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
- MySQL5.7 implement virtual column expression index (Database)
- Ubuntu Learning Advanced article - to teach you to further enhance system security (Linux)
- Three minutes to teach you to easily grasp the grep command regular expression (Linux)
- Specifies the open ports of the SUSE firewall settings (Linux)
- Tor Browser: under Linux for anonymous Web browsing ultimate browser (Linux)
- Through Oracle to help restore MySQL data problems (Database)
- Nginx Module Development - get user ip (Server)
- iOS developers - a simple factory pattern and OC reflection (Programming)
- How do you change the default browser and Email Client in Ubuntu (Linux)
- Schema snapshot rollback (Database)
- Linux environment to build next Cocos2dx-3.3.1 (Linux)
- Use Docker / LXC quickly launch a desktop system (Linux)
- C language files update in real time (Programming)
- Change CentOS 7 NIC name eno16777736 to eth0 (Linux)
- Linux security configuration (Linux)
- After installing minimize RHEL / CentOS 7 need to do some things (Linux)
- To install Gitolite in Ubuntu / Fedora / CentOS (Linux)
- Recycle Bin function realization in Linux (Linux)
- Grep, Ack, Ag searches Efficiency Comparison (Linux)
- Linux tool curl and wget advanced use (Linux)
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.