Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ imp / exp Oracle Database import and export commands     - Docker build private warehouse (Server)

- Windows environment Android Studio v1.0 Installation Guide (Linux)

- hexdump Linux command (Linux)

- CentOS 6.6 x64 Oracle Database 11gR2 RAC automated installation scripts (Database)

- Ubuntu install Vendetta Online 14.04 (Linux)

- CUDA (including GPU card driver) installation process under Ubuntu (Linux)

- Linux memory Cache Analysis (Linux)

- Oracle 11g RAC root.sh execution error second node failure example (Database)

- Ubuntu 12.04 install RTL8723BE wireless network card driver (Programming)

- Cobbler Add custom YUM source (Linux)

- iOS Sensor Development - add to APP phone password, fingerprint security authentication (Programming)

- Lsblk command lists using Linux block device information (Linux)

- Linux iptables firewall and vsftpd to resolve the issue (Linux)

- How apt-get limited use IPv4 or IPv6 protocol to download (Linux)

- Installation and use Docker under Ubuntu 14.04 (Linux)

- Oracle ORA-01691 error message, a single data file size limit problem (Database)

- Ubuntu15 core CLR (Server)

- How to find on Linux and delete duplicate files: FSlint (Linux)

- KVM QEMU virtual machine installation configuration under CentOS (Linux)

- Use Docker containers (Linux)

 
         
  imp / exp Oracle Database import and export commands
     
  Add Date : 2018-11-21      
         
       
         
  Oracle data import and export: imp / exp
Function: Oracle data import and export imp / exp is quite the oracle data restore and backup.
 
Most cases can be completed with the Oracle data import and export (does not cause the loss of data) to back up and restore data.
 Oracle has the advantage, though your computer is not a server, but you installed the oracle client, and the connection is established
 (Add the correct service name by Net Configuration Assistant, you can actually be thought of as a client and server-side repair of the road, then the data can be pulled over a)
 This allows you to export data to a local, although it may be a server far away from you.
 You can also import the dmp file from a local to a remote database server.
 You can use this feature to build two identical databases, one for testing, one for official use.
 
Execution Environment: You can SQLPLUS.EXE or DOS (command line) execute, DOS can be executed due when the oracle 8i in the installation directory \ $ ora10g \ BIN is set to the global path, there EXP.EXE with IMP the directory. EXE file is used to perform import and export.
 oracle using java prepared, I think SQLPLUS.EXE, EXP.EXE, IMP.EXE These three documents are the class files are packaged.
 SQLPLUS.EXE call EXP.EXE, IMP.EXE they wrapped the class to complete import and export functions.
 
Here is an instance of import and export, import and export to basically see examples can be completed, because the import and export is very simple.
Data Export:
 TEST 1 full export database, user name, password manager system to export to the D: \ daochu.dmp in
  exp system / manager @ TEST file = d: \ daochu.dmp full = y
 2 user Export system and sys user tables in the database
  exp system / manager @ TEST file = d: \ daochu.dmp owner = (system, sys)
 3 Export the database table table1, table2
  exp system / manager @ TEST file = d: \ daochu.dmp tables = (table1, table2)
 4 to "00" starts with the data export database table table1 fields in filed1
  exp system / manager @ TEST file = d: \ daochu.dmp tables = (table1) query = \ "where filed1 like '00% '\"
  
    The above is a common export, I do not care for the compression, the dmp file with winzip compression can be very good.
                    However, in the above command followed by compress = y on it

Importing data
 1 D: \ daochu.dmp the data into the TEST database.
  imp system / manager @ TEST file = d: \ daochu.dmp
  The above may be a problem, because some form already exists, then it will error, the table will not be imported.
  Followed by the ignore = y on it.
 2 d: \ daochu.dmp the import table table1
 imp system / manager @ TEST file = d: \ daochu.dmp tables = (table1)
 
 Export Import substantially above enough. I will watch many cases completely remove, and then import.
 
note:
 You have enough authority, enough authority it will prompt you.
 The database can be connected on. You can tnsping TEST TEST able to get connected to the database.

Data Export:
exp hkb / hkb @ boss_14 full = y file = c: \ orabackup \ hkbfull.dmp log = c: \ orabackup \ hkbfull.log;

Export Note: Exporting the data of the current user, and if the current user has permission to DBA, then export all the data!

Import data between users of the same name:
imp hkb / hkb @ xe file = c: \ orabackup \ hkbfull.dmp log = c: \ orabackup \ hkbimp.log full = y

Import data between different name:
imp system / test @ xe fromuser = hkb touser = hkb_new file = c: \ orabackup \ hkbfull.dmp

log = c: \ orabackup \ hkbimp.log;
     
         
       
         
  More:      
 
- Linux iptables port mapping settings (Server)
- JavaScript, some conclusions about the implicit conversion (Programming)
- Java string intern constant pool resolution Introduction (Programming)
- Nginx Module Development - get user ip (Server)
- using the ssh command to check the socket / Network Connections (Linux)
- Go Languages Reviews (Programming)
- Let you Fun Ubuntu desktop eleven weapon (Linux)
- How to use Aptik to backup and restore Apps/PPAs under ubuntu (Linux)
- How to build Mono 3.4.0 / 3.4.1 on Windows (Linux)
- Linux under HAProxy + Keepalived dual-availability program (Server)
- Linux System Getting Started Learning: Using the Linux command line detected DVD burner name and write speeds (Linux)
- Install the Solaris 10 operating system environment over the network to sparc (Linux)
- CentOS Linux firewall configuration and Close (Linux)
- Browser caching mechanism on the analysis (Linux)
- Large site architecture study notes (Server)
- Java implementation of stacks and queues (Programming)
- Varnish configuration language VCL and its built-in variables (Server)
- Install Java JDK 8 in CentOS 7 / 6.5 / 6.4 (Linux)
- Lenovo Ultrabooks Ubuntu system can not open the wireless hardware switch solutions (Linux)
- Ubuntu 14.04 install AMD graphics driver is fully dual monitor solution (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.