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.
阅读(870) | 评论(0) | 转发(0) |