我用了你的命令试了一下,结果报错,不知道为什么Import: Release 10.2.0.2.0 - Production on Mon Jan 25 12:33:41 2010Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.02.01 via conventional path import done in ZHS16GBK character set and AL16UTF16 NCHAR character set IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified IMP-00000: Import terminated unsuccessfully
如果使用toad或plsqldev,那么exp/imp就是简单的点点鼠标了。
如果要命令,参考:
ORACLE 数据库逻辑备份 简单 EXP/IMP
http://blog.csdn.net/tianlesoftware/archive/2009/10/24/4718366.aspx
exp b/b@tnsnames file=b.dmp rows=n owner=(b)
imp c/c@tnsnames file=b.dmp fromuser=(b) touser=(c) full=y ignore=y
以上假设b和c都有导入导出的权限
我用了你的命令试了一下,结果报错,不知道为什么Import: Release 10.2.0.2.0 - Production on Mon Jan 25 12:33:41 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified
IMP-00000: Import terminated unsuccessfully
同步表结构,表的结构会经常改变么,如果是的话,可能就要思考一下你们的体系设计了。如果不常改的话,最简单的方法就是导出,导入了,记得加上ROWS=N
用plsql
在plsql里找到这张表,右键选择编辑或者查看,右下角点击 查看sql(view sql)
把sql粘出来到那个库上执行一下
完事ok了