如何导入导出用户表
时间：2010-08-18 来源：cxm.cm
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);
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)
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.
[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);
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)
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.
相关阅读 更多 +
