How to resolve ORA 00997 illegal use of LONG datatype?

This ORA-00997: errors are related with the LOB Objects conversion. To solve this error, you can use the TO_LOB function to convert long data to LOB as follows. Or you can use expdp impdp of related table if you want to move table.

What is long VARCHAR?

The LONG VARCHAR type allows storage of character strings with a maximum length of 32,700 characters. It is identical to VARCHAR, except that you cannot specify a maximum length when creating columns of this type.

Can long data type have decimals?

Long variables can hold numbers from -9,223,372,036,854,775,808 through 9,223,372,036,854,775,807. Operations with Long are slightly slower than with Integer . If you need even larger values, you can use the Decimal Data Type.

What is Oracle data length?

The Oracle LENGTH() function returns the number of characters of a specified string. It measures the length of the string in characters as defined by the input character set.

What is long varchar in Oracle?

Can long have decimals Java?

Values of type long that exceed the range of int can be created from long literals. Integer literals can be expressed by these number systems: Decimal: Base 10, whose digits consists of the numbers 0 through 9; this is the number system you use every day.

How to solve ora-00997 illegal use of long datatype error in Oracle?

I got ” ORA-00997: illegal use of LONG datatype ” error in Oracle database during create table as select * from ( CTAS ) Details of error are as follows. This ORA-00997: errors are related with the LOB Objects conversion. To solve this error, you can use the TO_LOB function to convert long data to LOB as follows.

What is ora-00997 in SQL?

ORA-00997: illegal use of LONG datatype It is a restriction on usage of LONG data type. You cannot create an object type with a LONG attribute. SQL> CREATE TABLE t AS SELECT data_default FROM user_tab_cols; CREATE TABLE t AS SELECT data_default FROM user_tab_cols * ERROR at line 1: ORA-00997: illegal use of LONG datatype SQL>

How to remove the long value from a function in Oracle?

Or you can use expdp impdp of related table if you want to move table. Or you can remove the LONG value from the function or clause in a DISTINCT, WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. Do you want to learn Oracle Database for Beginners, then read the following articles.

How many rows are there in user_tab_cols?

There are 100,000 rows in it , I have select from user_tab_cols about 1,000 records and d save them into a temp table with this query: create table temp table as select * from user_tab_cols where condition…