使用PL/SQL工具导入表数据,日志如下,但是在库中没有发现数据。请问可能导致的原因,谢谢!Import started on 2010-4-23 10:09:35
C:\oracle\product\10.1.0\Db_1\bin\IMP.EXE log=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsimp.log file=C:\tmp\ztuser2010-04-02.dmp userid="sys/******@ASANCE as sysdba" buffer=30720 commit=no full=yes grants=yes ignore=yes indexes=yes rows=yes show=no constraints=yesIMP-00058: ORACLE error 28009 encountered
ORA-28009: connection to sys should be as sysdba or sysoperUsername:
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.01.00 via conventional pathWarning: the objects were exported by TESTUSER, not by youimport done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing TESTUSER's objects into SYSTEM
. . importing table "AAAA" 0 rows imported
. . importing table "BBBB" 16 rows importedAbout to enable constraints...
Import terminated successfully with warnings.Import finished on 2010-4-23 10:09:36
select * from TESTUSER.AAAA;
或者直接查询一下该表在系统里存不存在:
select * from ALL_tables t where UPPER(t.table_name) like 'AAAA';
访问表的时候要带用户名.
importing table "BBBB" 16 rows imported
BBB应该是有数据的
. . importing table "AAAA" 0 rows imported
. . importing table "BBBB" 16 rows imported
应该是有表的啊。
select * from ALL_tables t where UPPER(t.table_name) IN ('AAAA', 'BBBB');
这样找不到记录?
select * from DBA_tables t where UPPER(t.table_name) IN ('AAAA', 'BBBB');
imp log=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsimp.log file=C:\tmp\ztuser2010-04-02.dmp userid="testuser/******@ASANCE" buffer=30720 commit=no full=yes grants=yes ignore=yes indexes=yes rows=yes show=no constraints=yes
你的表以及数据导入到 sys.BBBB里面去了
应该 select * from sys.bbbb 这样就有数据了
如果你用a用户登陆进去的话你就直接是select * from a;就好啦!在试试。
而且像13楼说的 ,imp命令,最好加上fromuser=? touser=?