ORA-00997: illegal use of LONG datatype 1. 错误原因 ORA-00997 错误表明在 Oracle 数据库中非法使用了 LONG 数据类型。LONG 数据类型是 Oracle 中一种较旧的大字段数据类型,用于存储可变长度的字符数据,但由于其限制较多,Oracle 推荐在新的开发中使用 CLOB(Character Large Object)或其他更现代的数据类型。 LO...
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options ---Use copy command: (TESTDB is the tns entry of source database) SQL> copy from system/oracle@TESTDB create TEST_SQLCL using sele...
During PeopleTools upgrade or PeopleSoft application upgrade, you may get an Oracle error: ORA-00997: illegal use of LONG datatype. This post will walk you through the steps to workaround and resolve the error. I encountered this error during PTools upgrade and based on the symptoms, it lo...
Oracle 10.2.0.4 中转换long类型到CLOB类型时出现ORA-00997: illegal use of LONG datatype错误。 最后用TO_LOB()函数解决: INSERT INTO T_CLOB SELECT A, TO_LOB(B) FROM T_LONG; Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 Connected as reporttest SQL> CREATE TABLE T_LO...
红色的字体是问题所在 tsp.durtime 我在tsp的基类中设置的Long类型 。使用就会报ORA-00997: illegal use of LONG datatype 不知道如何解决,我现在只能改成max((tsp.endTime-tsp.begTime)*24*60) 我想知道 如果我一定要用Long 该怎么做。为什么。谢谢。 Hibernate...
Oracle Database - Enterprise Edition - Version 9.2.0.6 to 9.2.0.8 [Release 9.2]: How To Workaround Error: Ora-00997: Illegal Use Of Long Datatype
引用一下ORACLE官方联机文档的解释:Import wizard throws error ORA-00997 when importing a table.Cause: When you import table definitions from an Oracle Database, you may encounter an error such as "Repository Error Message: ORA-00997: illegal use of LONG datatype...". This occurs ...
ORA-00997：使用LONG数据类型Oracle非法正如在注解中提到的，long不能用于SQL函数，所以您最好重新设计表...