ORA-00997: illegal use of LONG datatype

ORA-00997: illegal use of LONG datatype

Cause: A value of datatype LONG was used in a function or in a DISTINCT, WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in a SELECT clause.

Action: Remove the LONG value from the function or clause

ORA-00997: "illegal use of LONG datatype":

When trying to reorganize a database table that includes a LONG column, there is likely to be an Oracle error message such as:

ORA-00997: illegal use of LONG datatype

This is because it is not possible to use a LONG column in any SQL statement. It can only be used where the application is retrieving part of the column - by specifying the start byte and the number of bytes.

The following will cause the above error:

ALTER TABLE tablename MOVE TABLESPACE tablespacename;

or

CREATE TABLE newtablename AS SELECT * FROM oldtablename;

ORA-00060: deadlock detected while waiting for resource

ORA-00936:missing expression

ORA-02063 remote db error and how to fix it

ORA-00054: resource busy and acquire with NOWAIT specified

ORA-04091: table is mutating trigger

ORA-00604: error occurred at recursive SQL level string

PLS-00222: no function with name exists

ORA-00600: internal error code arguments:

ORA-21000:error number argument to raise_application_error is out of range

ORA-00257: archiver error. Connect internal only, until freed.

ORA-00001: unique constraint

ORA-00017: session requested to set trace event

ORA-00018: maximum number of sessions exceeded

ORA-00019: maximum number of session licenses exceeded

ORA-00020: maximum number of processes exceeded.

ORA-00021: session attached to some other process; cannot switch session

ORA-00022: invalid session ID; access denied

ORA-00023: session references process private memory; cannot detach session

ORA-00024: logins from more than one process not allowed in single-process mode

ORA-00025: failed to allocate string

ORA-00026: missing or invalid session ID

ORA-00027: cannot kill current session

ORA-00028: your session has been killed

ORA-00029: session is not a user session

ORA-00030: User session ID does not exist.

ORA-00054: resource busy and acquire with NOWAIT specified

ORA-00055: maximum number of DML locks exceeded

ORA-00060: deadlock detected while waiting for resource

ORA-00257: archiver error. Connect internal only, until freed.

ORA-00600: internal error code arguments

ORA-00604: error occurred at recursive SQL level string

ORA-00936:missing expression

ORA-00997: illegal use of LONG datatype

ORA-01000:maximum open cursors exceeded

ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces

ORA-01480: trailing null missing from STR bind value

ORA-01555: snapshot too old: rollback segment number string with name "string" too small

ORA-03237: Initial Extent of specified size cannot be allocated in tablespace

ORA-04030: out of process memory when trying to allocate string bytes

ORA-04031: unable to allocate string bytes of shared memory

ORA-04091: table is mutating trigger

ORA-12154: TNS:could not resolve the connect identifier specified - Oracle Error

ORA-21000:error number argument to raise_application_error is out of range

ORA-28009: connection to sys should be as sysdba or sysoper

PLS-00222: no function with name exists

ORA-01422: exact fetch returns more than requested number of rows

Share on Google Plus

About Mindsforest