Linux系统中imp导入dmp文件
[oracle@ocm1 ~]$ ll
total 32
-rw-r--r-- 1 oracle oinstall 24576 Mar 27 15:26 COUNTRIES.dmp
drwxr-xr-x 2 oracle oinstall 4096 Mar 27 12:39 script
drwxr-xr-x 2 oracle oinstall 4096 Mar 19 14:51 temp
下面是导入:
[oracle@ocm1 ~]$ imp
Import: Release 10.2.0.1.0 - Production on Thu Mar 27 15:31:30 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Username: sh
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Import file: expdat.dmp > /home/oracle/COUNTRIES.dmp
Enter insert buffer size (minimum is 8192) 30720>
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
[oracle@ocm1 ~]$
头部验证失败是由于版本号不同所致,经试验可以通过如下方法进行修改:
可以看到头部信息 -TEXPORT:V11.01.00,即为源数据库的版本号,将其修改为目的数据库的版本号,
如本机为10.02.01,再次进行导入操作,导入成功
[oracle@ocm1 ~]$ vi COUNTRIES.dmp --直接使用vi修改下头部的版本号即可
^C^CiEXPORT:V10.02.00--之前是EXPORT:V11.02.00
USH
再次导入,成功:
[oracle@ocm1 ~]$ imp
Import: Release 10.2.0.1.0 - Production on Thu Mar 27 15:36:22 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Username: sh
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Import file: expdat.dmp > /home/oracle/COUNTRIES.dmp
Enter insert buffer size (minimum is 8192) 30720>
Export file created by EXPORT:V10.02.00 via conventional path
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no >
Ignore create error due to object existence (yes/no): no >
Import grants (yes/no): yes >
Import table data (yes/no): yes >
Import entire export file (yes/no): no >
Username: sh
Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done:
. importing SH's objects into SH
IMP-00008: unrecognized statement in the export file:
. importing SH's objects into SH
. . importing table "COUNTRIES" 23 rows imported
Import terminated successfully with warnings.
[oracle@ocm1 ~]$
SYS@PROD> conn sh/sh
Connected.
SH@PROD> desc COUNTRIES
Name Null? Type
----------------------------------------- -------- ----------------------------
COUNTRY_ID NOT NULL NUMBER
COUNTRY_ISO_CODE NOT NULL CHAR(2)
COUNTRY_NAME NOT NULL VARCHAR2(40)
COUNTRY_SUBREGION NOT NULL VARCHAR2(30)
COUNTRY_SUBREGION_ID NOT NULL NUMBER
COUNTRY_REGION NOT NULL VARCHAR2(20)
COUNTRY_REGION_ID NOT NULL NUMBER
COUNTRY_TOTAL NOT NULL VARCHAR2(11)
COUNTRY_TOTAL_ID NOT NULL NUMBER
COUNTRY_NAME_HIST VARCHAR2(40)
SH@PROD>
SH@PROD> select count(*) from COUNTRIES;
COUNT(*)
----------
23
备注:随笔中内容来源于网上资料整理,仅供参考。
最新文章
- Android-RecyclerView
- iOS - 文件操作(File Operating)
- jfreechart 实例
- Eclipse实现图形化界面插件-vs4e
- python之进程----Queue
- Okio 之初探黄龙
- Django 项目中添加静态文件夹
- 一天一个Linux命令--find
- numpy和matplotlib
- centos7下kubernetes(1。kubernetes---start)
- 帝国cms自动保存图片
- [Python]查询oracle导出结果至Excel并发送邮件
- source、sh、bash
- CentOS7 系统升级,删除centos7开机界面多余选,升级至最新的内核
- ES6的新API如Promise,Proxy,Array.form(),Object.assign()等,Babel不能转码, 使用babel-polyfill来解决
- python中for循环的底层实现机制 迭代
- unity-----------------------四元数与欧拉旋转方法
- js图片跟随鼠标移动
- Android Studio Note
- 谷歌上不去了,长久解决方式。能够稳定高速上Google和Gmail
热门文章
- Robot Framework安装部署详细教程
- #Week 11 - 343.Integer Break
- SpringBoot(六) -- SpringBoot错误处理机制
- css的继承之width属性(容易忽略)
- Developer Express 第三方控件使用系列方法
- AtCoder Beginner Contest 133 B - Good Distance
- 键盘按键KeyCode大全
- JavaScript之基础语法
- 使用ssh协议在linux主机之间快速上传和下载文件
- 2019牛客暑期多校训练营(第七场) - C - Governing sand - 平衡树