ORACLE exp/imp备份单个表的用法

2014-03-21  来源:本站原创  分类:oracle  人气:1 

exp和imp属于逻辑备份和恢复,备份使用exp, 恢复使用imp!

exp有三种模式: 完全, 用户, 表。

完全:

exp user/[email protected] BUFFER=1000 FILE=/home/backup.data FULL=y

用户:

exp user/[email protected] BUFFER=1000 FILE=/home/backup.data OWER=username

表:

exp user/[email protected] BUFFER=1000 FILE=/home/backup.data TABLES=table1,table2,..tablen

imp同样有三种方式,完全, 用户, 表

imp user/[email protected] BUFFER=1000 FILE=/home/backup.data FULL=y

imp user/[email protected] BUFFER=1000 FILE=/home/backup.data fromuser=A touser=B

imp user/[email protected] BUFFER=1000 FILE=/home/backup.data OWER=username ignore=y

这些参数有些是可选的,根据实际情况选择。 ignore=y 是如果表已经存在,将会覆盖,否则导入失败。

相关文章
  • ORACLE exp/imp备份单个表的用法 2014-03-21

    exp和imp属于逻辑备份和恢复,备份使用exp, 恢复使用imp! exp有三种模式: 完全, 用户, 表. 完全: exp user/[email protected] BUFFER=1000 FILE=/home/backup.data FULL=y 用户: exp user/[email protected] BUFFER=1000 FILE=/home/backup.data OWER=username 表: exp user/[email protected] BUFFER=1000 FILE=/home/

  • ORACLE EXP/IMP导出导入命令及数据库备份 2014-12-15

    ORACLE EXP/IMP导出导入命令及数据库备份 Oracle数据导入导出imp/exp就相当于oracle数据还原与备份.exp命令可以把数据从远程数据库服务器导出到本地的dmp文件,imp命令可以把dmp文件从本地导入到远处的数据库服务器中.执行环境:可以在SQLPLUS.EXE或者DOS(命令行)中执行, DOS中可以执行时由于 在oracle 8i 中 安装目录\ora81 \BIN被设置为全局路径, 该目录下有EXP.EXE与IMP.EXE文件被用来执行导入导出. oracle用j

  • Reprinted: Oracle exp / imp backup (export / import backup) 2010-03-04

    Reprinted: Oracle exp / imp backup (export / import backup) ORACLE 2008-12-19 11:28:13 Read 15 Comments 0 font size: large, medium exp hely = y Description: USERID username / password FULL export entire file (N) BUFFER size of data buffer OWNER Owner

  • the oracle exp, imp Detailed use 2011-08-02

    the oracle exp, imp Detailed basic syntax and usage examples: 1, EXP: There are three main ways (full, user, table) 1, full: EXP SYSTEM / MANAGER BUFFER = 64000 FILE = C: \ FULL.DMP FULL = Y If you want to perform a full export, you must have special

  • ORACLE EXP / IMP of use 2011-10-08

    ORACLE EXP / IMP Detailed use Import / Export is the oldest surviving ORACLE two command-line tools, in fact, I never thought Exp / Imp is a good backup, correct to say that Exp / Imp dump can only be a good tool, especially dump in a small database,

  • Oracle EXP / IMP backup profile 2011-10-16

    EXP / IMP backup is one of the most common backup method, in fact, Exp / Imp is not considered a good backup, correct to say that Exp / Imp can only be a good dump tool Oracle EXP / IMP backup: Import / Export is the oldest surviving ORACLE two comma

  • ORACLE EXP不能导出空表的原因分析及解决方法 2014-01-15

    这篇文章主要介绍了ORACLE EXP不能导出空表的原因分析及解决方法,大家参考使用吧 一.不能导出空表的原因 1.Oracle11g默认对空表不分配segment,故使用exp导出Oracle11g数据库时,空表不会导出. 2.设置deferred_segment_creation 参数为FALSE后,无论是空表还是非空表,都分配segment. 在sqlplus中,执行如下命令: SQL>alter system set deferred_segment_creation=false; 查看

  • ORACLE EXP/IMP的使用详解 2015-01-10

    作者:eclipse 导入/导出是ORACLE幸存的最古老的两个命令行工具,其实我从来不认为Exp/Imp是一种好的备份方式,正确的说法是Exp/Imp只能是一个好的转储工具,特别是在小型数据库的转储,表空间的迁移,表的抽取,检测逻辑和物理冲突等中有不小的功劳.当然,我们也可以把它作为小型数据库的物理备份后的一个逻辑辅助备份,也是不错的建议.对于越来越大的数据库,特别是TB级数据库和越来越多数据仓库的出现,EXP/IMP越来越力不从心了,这个时候,数据库的备份都转向了RMAN和第三方工具.下面说

  • Oracle exp / imp Export Import tool use (change) 2010-04-09

    1. Export Tool exp 1. It is the operating system, an executable file storage directory / ORACLE_HOME / bin exp export tool will compress the database backup file into a binary system. you can move between different OS It has three modes: a. User mode

  • Oracle exp / imp the use of Export Import Tool 2010-10-22

    One. Export Tool exp First, in the linux platform, can not use root user guide data, you must first switch to the oracle user Command: su - oracle Note: oracle to have a space in front 1. It is the operating system, an executable file storage directo

  • Oracle exp / imp command to import and export database backup (transfer) is more 2011-01-05

    Oracle data import and export imp / exp is equivalent to oracle data restore and backup. exp command to export the data from the remote database server to the local dmp file, imp command to import the dmp file to the distance from the local database

  • oracle: exp / imp and expdp / impdp data backup instance 2011-08-02

    Recently made the oracle data backup tasks, checked, a cold backup, hot backup, considering, that the exp / imp and expdp / impdp more suitable one is not too large amount of data (estimated at most millions), the two real-time requirements low. exp

  • Oracle exp / imp Export Import tool use 2010-10-22

    I. Export tool exp First, in the linux platform, data can not be the root user guide, you must first switch to the oracle user Command: su - oracle Note: oracle to have a space in front 1 It is an executable operating system file storage directory /

  • oracle exp / imp import and export 2011-03-11

    Import / Export is the oldest surviving ORACLE two command-line tools, in fact, I never thought Exp / Imp is a good backup, Correct to say that Exp / Imp dump can only be a good tool, especially in the small database dump, the migration table space,

  • Oracle exp / imp command to import and export database backup (reproduced) 2011-04-02

    Oracle data import and export imp / exp is equivalent to oracle data restore and backup. exp command to export data from a remote database server to the local dmp file, imp command to import the dmp file to the distance from the local database server

  • the oracle exp / imp to learn to use (turn) 2011-08-30

    exp / imp oracle two commands can be said that the most commonly used commands. ORACLE database there are two types of backup methods. The first category is the physical backup, which implements the full database recovery, but the database must run i

  • ORACLE: EXP / IMP arguments detailed 2010-03-22

    1, Export / Import of use Oracle Export / Import tool is used to transfer data between databases. Export to export the data from the database to a dump file Import from a dump file to enter data in the database The following is a general guide to use

  • oracle exp / imp command 2010-08-27

    Oracle data import and export imp / exp is equivalent to oracle data restore and backup. exp command to export data from a remote database server to the local dmp file, imp command to import the dmp file to the distance from the local database server

  • oracle exp / imp command Detailed 2010-10-24

    Oracle data import and export imp / exp is equivalent to oracle data restore and backup. exp command to export the data from the remote database server to the local dmp file, imp command to import the dmp file to the distance from the local database

  • oracle exp \ imp data import and export (experience) 2011-04-20

    First, export the data step: 1, run the command line: cmd 2, the database export command: exp username / password @ service name 3, the export file: EXPDAT.DMP> Export file name 4, select the export type: <1> E <complete database>, <2>