Oracle10g使用imp命令导出数据为dmp:
imp system/password@orcl file=rd_online_20181102.dmp fromuser=user1 touser=user2

附录:imp命令help

[oracle@dbsrv3 ~]$ imp help=y

Import: Release 10.2.0.1.0 - Production on Thu Nov 22 13:19:38 2018

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

You can let Import prompt you for parameters by entering the IMP
command followed by your username/password: Example: IMP SCOTT/TIGER Or, you can control how Import runs by entering the IMP command followed
by various arguments. To specify parameters, you use keywords: Format: IMP KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
Example: IMP SCOTT/TIGER IGNORE=Y TABLES=(EMP,DEPT) FULL=N
or TABLES=(T1:P1,T1:P2), if T1 is partitioned table USERID must be the first parameter on the command line. Keyword Description (Default) Keyword Description (Default)
--------------------------------------------------------------------------
USERID username/password FULL import entire file (N)
BUFFER size of data buffer FROMUSER list of owner usernames
FILE input files (EXPDAT.DMP) TOUSER list of usernames
SHOW just list file contents (N) TABLES list of table names
IGNORE ignore create errors (N) RECORDLENGTH length of IO record
GRANTS import grants (Y) INCTYPE incremental import type
INDEXES import indexes (Y) COMMIT commit array insert (N)
ROWS import data rows (Y) PARFILE parameter filename
LOG log file of screen output CONSTRAINTS import constraints (Y)
DESTROY overwrite tablespace data file (N)
INDEXFILE write table/index info to specified file
SKIP_UNUSABLE_INDEXES skip maintenance of unusable indexes (N)
FEEDBACK display progress every x rows(0)
TOID_NOVALIDATE skip validation of specified type ids
FILESIZE maximum size of each dump file
STATISTICS import precomputed statistics (always)
RESUMABLE suspend when a space related error is encountered(N)
RESUMABLE_NAME text string used to identify resumable statement
RESUMABLE_TIMEOUT wait time for RESUMABLE
COMPILE compile procedures, packages, and functions (Y)
STREAMS_CONFIGURATION import streams general metadata (Y)
STREAMS_INSTANTIATION import streams instantiation metadata (N)
VOLSIZE number of bytes in file on each volume of a file on tape The following keywords only apply to transportable tablespaces
TRANSPORT_TABLESPACE import transportable tablespace metadata (N)
TABLESPACES tablespaces to be transported into database
DATAFILES datafiles to be transported into database
TTS_OWNERS users that own data in the transportable tablespace set Import terminated successfully without warnings.

最新文章

  1. Eclipse 显示所有文件
  2. springboot使用之一:连接生产数据库,添加连接池
  3. CF 702B Powers of Two(暴力)
  4. 自动化测试管理平台ATMS(V2.0.3_8.28)下载
  5. 6月27日 OGDF不同的布局算法
  6. ActiveMQ使用教程
  7. Android开发之异步通信Handler机制
  8. MongoDB@入门一
  9. 【转】git使用教程
  10. PHP5常量
  11. QTP脚本汇总比较有价值
  12. mongodb分片部署
  13. Ration Rose2003安装及破解
  14. 安卓高级Fresco图片框架的时候
  15. java反射案例详解
  16. 用JAVA代码获取Weblogic配置的JNDI 数据源连接
  17. html+css+js整体布局——[防止浏览器扩大,界面排版混乱]
  18. jdbc和odbc
  19. node 打开浏览器
  20. 【转】苹果App Store审核指南中文翻译(更新)

热门文章

  1. jquery在ajax新加入的元素后绑定事件click
  2. Scrum 常见错误实践 之 过长的站会
  3. http协议的相关知识
  4. Swift基础一(代码)
  5. Linux下通过find命令进行rm文件删除的小技巧
  6. 初识JVM虚拟机
  7. eclipse 重启/打开内置浏览器
  8. POJ - 3308 Paratroopers(最大流)
  9. 并不对劲的splay
  10. 牛客练习赛13D:幸运数字Ⅳ(康托展开) F:关键字排序