我用exp/imp 导入导出时 表里面的数据好象没有导出 为什么呢?
解决方案 »
- Oracle数据库dmp文件导入问题,跪求解答,一天一来查贴
- 关于java获取clob字段的问题
- v_$session问题
- SQL 计算某行某字段值咱所有行 该字段和的比例
- 怎样把XML文件用IF-THEN-ELSE PL/SQL表现出来?
- Oracle 行级触发器共享数据问题
- 关于Oracle中的特殊字符“&”(&)
- 存入Oracle的数据与取出时的数据有误差!
- user_tables之类的视图是属于sys用户的,但是为什么其他用户可以不使用sys.前缀就可以直接访问?
- 在sql plus下能提取oracle的所有数据表吗?
- Oracle如何使用游标对数据进行修改,删除操作呢?
- oracle表空间的FSFI值过低
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)About to export specified tables via Conventional Path ...
EXP-00011: LXJ.RT does not exist
Export terminated successfully with warnings.
[oracle@S85-A]:/oracle>ls
11.txt eygle01.dbf oradata smit.script
Mail flash_recovery_area product smit.transaction
TT_DB o1_mf_1_1057_4l8xchh7_.arc share01 sqlnet.log
admin o1_mf_1_901_4kvfyo5y_.arc share02 sqlplus
dbca_raw.txt oraInventory smit.log test.dmp
[oracle@S85-A]:/oracle>imp lxj/lxj@lxjorcl file=test.dmp fromuser=lxj touser=lxjImport: Release 10.2.0.3.0 - Production on Fri Nov 21 15:54:43 2008Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.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
import server uses WE8ISO8859P1 character set (possible charset conversion)
Import terminated successfully without warnings.
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion) --lxj.rt不存在
About to export specified tables via Conventional Path ...
EXP-00011: LXJ.RT does not exist
rt 这个表的属主不是lxj吧。exp lxj/lxj@lxjorcl file=test.dmp tables=owner.rt
前提,lxj有exp_full_database的权限