ORA-00932: inconsistent datatypes: expected BINARY got NUMBER

Bless_you 发布于 2013/11/06 16:11
阅读 3K+
收藏 0

插入数据的时候遇到这个问题: ORA-00932: inconsistent datatypes: expected BINARY got NUMBER

这是什么原因导致的那?
加载中
0
MrZQ
MrZQ

Solution #1
Run following scripts while connected as SYS user:

> sqlplus /nolog
SQL> connect / as sysdba 
SQL> @?/rdbms/admin/catmetx.sql 
SQL> @?/rdbms/admin/utlrp.sql 

SQL> exit

Afterwards, re-run the export.

or:

Solution #2
Run the export with the Export DataPump client. E.g.:

> expdp system/manager directory=my_dir \

dumpfile=expdp_full.dmp logfile=expdp_full.log full=y

原文地址:http://wenwen.soso.com/z/q318771546.htm

0
Bless_you
Bless_you

引用来自“MyKings”的答案

Solution #1
Run following scripts while connected as SYS user:

> sqlplus /nolog
SQL> connect / as sysdba 
SQL> @?/rdbms/admin/catmetx.sql 
SQL> @?/rdbms/admin/utlrp.sql 

SQL> exit

Afterwards, re-run the export.

or:

Solution #2
Run the export with the Export DataPump client. E.g.:

> expdp system/manager directory=my_dir \

dumpfile=expdp_full.dmp logfile=expdp_full.log full=y

原文地址:http://wenwen.soso.com/z/q318771546.htm

我已经找到答案了,,是我自己粗心创建表的时候写错了类型,但是还是谢谢你。
返回顶部
顶部