Chinaunix首页 | 论坛 | 博客
  • 博客访问: 690524
  • 博文数量: 176
  • 博客积分: 4791
  • 博客等级: 上校
  • 技术积分: 1921
  • 用 户 组: 普通用户
  • 注册时间: 2006-05-24 18:47
个人简介

it江湖漂,怎能不挨刀;一朝机器当,看你怎么着!

文章分类

全部博文(176)

文章存档

2014年(2)

2012年(17)

2011年(27)

2010年(18)

2009年(6)

2008年(21)

2007年(43)

2006年(42)

分类: LINUX

2010-08-18 11:07:55

1 导出用户DCUSER所有的数据
[oracle@test1 ~]$ exp system/123456 owner=dcuser file=/backup/databackup/dcuser201008170630.dmp

2 把用户DCUSER下的表ATOM_PRODUCT_CATEGORY导入CHEN用户中
[oracle@test1 ~]$ imp system/123456 fromuser=dcuser touser=chen file=/backup/databackup/dcuser201008170630.dmp tables=(ATOM_PRODUCT_CATEGORY);
或者
[oracle@test1 ~]$ imp system/123456 fromuser=dcuser touser=chen file=/backup/databackup/dcuser201008170630.dmp tables=ATOM_PRODUCT_CATEGORY; 
Import: Release 10.2.0.4.0 - Production on Wed Aug 18 10:45:34 2010

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via direct path
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
. importing DCUSER's objects into CHEN
. . importing table        "ATOM_PRODUCT_CATEGORY"      43328 rows imported
Import terminated successfully without warnings.

3 导出用户CHEN下的表ATOM_PRODUCT_CATEGORY到/tmp/ATOM.dmp
oracle@test1 ~]$ exp chen/123456 file=/tmp/ATOM.dmp tables=(ATOM_PRODUCT_CATEGORY)
或者

oracle@test1 ~]$ exp chen/123456 file=/tmp/ATOM.dmp tables=ATOM_PRODUCT_CATEGORY

Export: Release 10.2.0.4.0 - Production on Wed Aug 18 10:56:09 2010

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table          ATOM_PRODUCT_CATEGORY      43328 rows exported

4 导入用户CHEN的表ATOM_PRODUCT_CATEGORY到用户DCUSER中
[oracle@test1 ~]$ imp system/ambowcm02 fromuser=chen touser=dcuser file=/tmp/ATOM.dmp

Import: Release 10.2.0.4.0 - Production on Wed Aug 18 10:12:51 2010

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by CHEN, not by you

import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
. importing CHEN's objects into DCUSER
. . importing table        "ATOM_PRODUCT_CATEGORY"      43328 rows imported
Import terminated successfully without warnings.

阅读(867) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~