Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle Data Pump Example     - Ubuntu 12.04 installation instructions under GAMIT10.40 (Linux)

- cat command uses the Linux redirection merge files (Linux)

- Python implementation Bursa transition model (Programming)

- exp / imp Export Import version of the problem and the ORA-6550 error (Database)

- MySQL various log summary (Database)

- MyCAT read and write separation of MySQL (Database)

- MySQL monitoring tools -orzdba (Database)

- The next key to install Linux bash script PowerShell (Linux)

- How to configure Ceph stored on CentOS 7.0 (Server)

- Workspace Go language and environment variables GOPATH (Linux)

- Achieve single backup of MySQL by innobackupex (Database)

- C ++ How to determine the types of constants (Programming)

- Heartbeat (v1, v2, pacemaker) cluster components Overview (Server)

- Ora-1092: OPI colleague K aborting process --- killed by OO Well killer (Database)

- Linux Getting Started tutorial: Ubuntu 14.04 in the installation Sogou Pinyin (Linux)

- Java programmers talk about those advanced knowledge and direction (Programming)

- MySQL 5.6 database code changes (Database)

- The difference between equals and == in Java (Programming)

- Hadoop + Zookeeper NameNode achieve high availability (Server)

- Use PuTTY to access the virtual machine Linux under Windows xp (Programming)

 
         
  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:      
 
- Lua non-blocking write log (Programming)
- Talking about modern programming language syntax and standard library tightly bound phenomenon (Programming)
- Axel install plug under CentOS 5/6 acceleration yum downloads (Linux)
- Oracle Data Guard LOG_ARCHIVE_DEST_n optional attribute parameters (Database)
- Ubuntu GCC, G ++ and fortran Version Switch (Linux)
- Parse Server supports iOS and Android push messaging (Programming)
- Linux disk and File System Concepts (Linux)
- About Nginx 7 (Server)
- Linux system using the command line shutdown or restart (Linux)
- ASP.NET 5 (vNext) Linux deployment (Server)
- Use scripts easily install the latest Linux kernel in Ubuntu (Linux)
- Ubuntu is not in the sudoers file problem solving (Linux)
- Ubuntu 15.10 install the latest Arduino IDE 1.6.7 (Linux)
- Writing Better Bash build script 8 (Programming)
- Improve the Ubuntu SSH login authentication approach speed (Linux)
- Figlet use (Linux)
- Linux data redirection (Linux)
- Oracle can not change the tablespace to backup mode in non-archive mode (Database)
- LVM mirrored logical volume to achieve (Linux)
- MySQL 5.7 perfectly distributed transaction support (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.