Oracle Error Messages ORA-02001 to ORA-02400

In this post, we will be listing all the Oracle error messages or error codes from ORA-00201 to ORA-02400.

Oracle Error Messages ORA-02001 to ORA-02400

 

ORA-02001

user SYS is not permitted to create indexes with freelist groups

ORA-02004

security violation

ORA-02007

can’t use ALLOCATE or DEALLOCATE options with REBUILD

ORA-02009

the size specified for a file must not be zero

ORA-02014

cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.

ORA-02015

cannot select FOR UPDATE from remote table

ORA-02020

too many database links in use

ORA-02021

DDL operations are not allowed on a remote database

ORA-02022

remote statement has unoptimized view with remote object

ORA-02024

database link not found

ORA-02025

all tables in the SQL statement must be at the remote database

ORA-02026

missing LINK keyword

ORA-02027

multi-row UPDATE of LONG column is not supported

ORA-02028

fetching an exact number of rows is not supported by the server

ORA-02029

missing FILE keyword

ORA-02030

can only select from fixed tables/views

ORA-02031

no ROWID for fixed tables or for external-organized tables

ORA-02032

clustered tables cannot be used before the cluster index is built

ORA-02033

a cluster index for this cluster already exists

ORA-02034

speed bind not permitted

ORA-02035

illegal bundled operation combination

ORA-02036

too many variables to describe with automatic cursor open

ORA-02037

uninitialized speed bind storage

ORA-02038

define is not allowed for array type

ORA-02039

bind by value is not allowed for array type

ORA-02040

remote database string does not support two-phase commit

ORA-02041

client database did not begin a transaction

ORA-02042

too many distributed transactions

ORA-02043

must end current transaction before executing string

ORA-02044

transaction manager login denied: transaction in progress

ORA-02045

too many local sessions participating in global transaction

ORA-02046

distributed transaction already begun

ORA-02047

cannot join the distributed transaction in progress

ORA-02048

attempt to begin distributed transaction without logging on

ORA-02049

timeout: distributed transaction waiting for lock

ORA-02050

transaction string rolled back, some remote DBs may be in-doubt

ORA-02051

another session or branch in same transaction failed or finalized

ORA-02052

remote transaction failure at string

ORA-02053

transaction string committed, some remote DBs may be in-doubt

ORA-02054

transaction string in-doubt

ORA-02055

distributed update operation failed; rollback required

ORA-02056

2PC: string: bad two-phase command number string from string

ORA-02057

2PC: string: bad two-phase recovery state number string from string

ORA-02058

no prepared transaction found with ID string

ORA-02059

ORA-2PC-CRASH-TEST-string in commit comment

ORA-02060

select for update specified a join of distributed tables

ORA-02061

lock table specified list of distributed tables

ORA-02062

distributed recovery received DBID string, expected string

ORA-02063

preceding stringstring from stringstring

ORA-02064

distributed operation not supported

ORA-02065

illegal option for ALTER SYSTEM

ORA-02066

missing or invalid DISPATCHERS text

ORA-02067

transaction or savepoint rollback required

ORA-02068

following severe error from stringstring

ORA-02069

global_names parameter must be set to TRUE for this operation

ORA-02070

database stringstring does not support string in this context

ORA-02071

error initializing capabilities for remote database string

ORA-02072

distributed database network protocol mismatch

ORA-02073

sequence numbers not supported in remote updates

ORA-02074

cannot string in a distributed transaction

ORA-02075

another instance changed state of transaction string

ORA-02076

sequence not co-located with updated table or long column

ORA-02077

selects of long columns must be from co-located tables

ORA-02079

cannot join a committing distributed transaction

ORA-02080

database link is in use

ORA-02081

database link is not open

ORA-02082

a loopback database link must have a connection qualifier

ORA-02083

database name has illegal character ‘string’

ORA-02084

database name is missing a component

ORA-02085

database link string connects to string

ORA-02086

database (link) name is too long

ORA-02087

object locked by another process in same transaction

ORA-02088

distributed database option not installed

ORA-02089

COMMIT is not allowed in a subordinate session

ORA-02090

network error: attempted callback+passthru

ORA-02091

transaction rolled back

ORA-02092

out of transaction table slots for distributed transaction

ORA-02093

TRANSACTIONS_PER_ROLLBACK_SEGMENT(string) more than maximum possible(string)

ORA-02094

replication option not installed

ORA-02095

specified initialization parameter cannot be modified

ORA-02096

specified initialization parameter is not modifiable with this option

ORA-02097

parameter cannot be modified because specified value is invalid

ORA-02098

error parsing index-table reference (:I)

ORA-02140

invalid tablespace name

ORA-02141

invalid OFFLINE option

ORA-02142

missing or invalid ALTER TABLESPACE option

ORA-02143

invalid STORAGE option

ORA-02144

no option specified for ALTER CLUSTER

ORA-02145

missing STORAGE option

ORA-02146

SHARED specified multiple times

ORA-02147

conflicting SHARED/EXCLUSIVE options

ORA-02148

EXCLUSIVE specified multiple times

ORA-02149

Specified partition does not exist

ORA-02150

invalid new tablespace name

ORA-02151

invalid tablespace name: string

ORA-02152

Invalid ALTER TABLESPACE … RENAME option

ORA-02153

invalid VALUES password string

ORA-02154

a tablespace with the name ‘string’ is found

ORA-02155

invalid DEFAULT tablespace identifier

ORA-02156

invalid TEMPORARY tablespace identifier

ORA-02157

no options specified for ALTER USER

ORA-02158

invalid CREATE INDEX option

ORA-02159

installed DLM does not support releasable locking mode

ORA-02160

index-organized table can not contain columns of type LONG

ORA-02161

invalid value for MAXLOGFILES

ORA-02162

invalid value for MAXDATAFILES

ORA-02163

invalid value for FREELIST GROUPS

ORA-02164

DATAFILE clause specified more than once

ORA-02165

invalid option for CREATE DATABASE

ORA-02166

ARCHIVELOG and NOARCHIVELOG specified

ORA-02167

LOGFILE clause specified more than once

ORA-02168

invalid value for FREELISTS

ORA-02169

FREELISTS storage option not allowed

ORA-02170

FREELIST GROUPS storage option not allowed

ORA-02171

invalid value for MAXLOGHISTORY

ORA-02172

The PUBLIC keyword is not appropriate for a disable thread

ORA-02173

invalid option for DROP TABLESPACE

ORA-02174

Missing required thread number

ORA-02175

invalid rollback segment name

ORA-02176

invalid option for CREATE ROLLBACK SEGMENT

ORA-02177

Missing required group number

ORA-02178

WRITE }

ORA-02179

READ COMMITTED }

ORA-02180

invalid option for CREATE TABLESPACE

ORA-02181

invalid option to ROLLBACK WORK

ORA-02182

savepoint name expected

ORA-02183

READ COMMITTED }

ORA-02184

resource quotas are not allowed in REVOKE

ORA-02185

a token other than WORK follows COMMIT

ORA-02186

tablespace resource privilege may not appear with other privileges

ORA-02187

invalid quota specification

ORA-02188

Cannot enable instance publicly

ORA-02189

ON <tablespace> required

ORA-02190

keyword TABLES expected

ORA-02191

correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT <rbs>

ORA-02192

PCTINCREASE not allowed for rollback segment storage clauses

ORA-02194

event specification syntax error string (minor error string) near ‘string’

ORA-02195

Attempt to create string object in a string tablespace

ORA-02196

PERMANENT/TEMPORARY option already specified

ORA-02197

file list already specified

ORA-02198

ONLINE/OFFLINE option already specified

ORA-02199

missing DATAFILE/TEMPFILE clause

ORA-02200

WITH GRANT OPTION not allowed for PUBLIC

ORA-02201

sequence not allowed here

ORA-02202

no more tables permitted in this cluster

ORA-02203

INITIAL storage options not allowed

ORA-02204

ALTER, INDEX and EXECUTE not allowed for views

ORA-02205

only SELECT and ALTER privileges are valid for sequences

ORA-02206

duplicate INITRANS option specification

ORA-02207

invalid INITRANS option value

ORA-02208

duplicate MAXTRANS option specification

ORA-02209

invalid MAXTRANS option value

ORA-02210

no options specified for ALTER TABLE

ORA-02211

invalid value for PCTFREE or PCTUSED

ORA-02212

duplicate PCTFREE option specification

ORA-02213

duplicate PCTUSED option specification

ORA-02214

duplicate BACKUP option specification

ORA-02215

duplicate tablespace name clause

ORA-02216

tablespace name expected

ORA-02217

duplicate storage option specification

ORA-02218

invalid INITIAL storage option value

ORA-02219

invalid NEXT storage option value

ORA-02220

invalid MINEXTENTS storage option value

ORA-02221

invalid MAXEXTENTS storage option value

ORA-02222

invalid PCTINCREASE storage option value

ORA-02223

invalid OPTIMAL storage option value

ORA-02224

EXECUTE privilege not allowed for tables

ORA-02225

only EXECUTE and DEBUG privileges are valid for procedures

ORA-02226

invalid MAXEXTENTS value (max allowed: string)

ORA-02227

invalid cluster name

ORA-02228

duplicate SIZE specification

ORA-02229

invalid SIZE option value

ORA-02230

invalid ALTER CLUSTER option

ORA-02231

missing or invalid option to ALTER DATABASE

ORA-02232

invalid MOUNT mode

ORA-02233

invalid CLOSE mode

ORA-02234

changes to this table are already logged

ORA-02235

this table logs changes to another table already

ORA-02236

invalid file name

ORA-02237

invalid file size

ORA-02238

filename lists have different numbers of files

ORA-02239

there are objects which reference this sequence

ORA-02240

invalid value for OBJNO or TABNO

ORA-02241

must of form EXTENTS (FILE <n> BLOCK <n> SIZE <n>, …)

ORA-02242

no options specified for ALTER INDEX

ORA-02243

invalid ALTER INDEX or ALTER MATERIALIZED VIEW option

ORA-02244

invalid ALTER ROLLBACK SEGMENT option

ORA-02245

invalid ROLLBACK SEGMENT name

ORA-02246

missing EVENTS text

ORA-02247

no option specified for ALTER SESSION

ORA-02248

invalid option for ALTER SESSION

ORA-02249

missing or invalid value for MAXLOGMEMBERS

ORA-02250

missing or invalid constraint name

ORA-02251

subquery not allowed here

ORA-02252

check constraint condition not properly ended

ORA-02253

constraint specification not allowed here

ORA-02254

DEFAULT <expression> not allowed here

ORA-02255

obsolete 7.1.5

ORA-02256

number of referencing columns must match referenced columns

ORA-02257

maximum number of columns exceeded

ORA-02258

duplicate or conflicting NULL and/or NOT NULL specifications

ORA-02259

duplicate UNIQUE/PRIMARY KEY specifications

ORA-02260

table can have only one primary key

ORA-02261

such unique or primary key already exists in the table

ORA-02262

ORA-string occurs while type-checking column default value expression

ORA-02263

need to specify the datatype for this column

ORA-02264

name already used by an existing constraint

ORA-02265

cannot derive the datatype of the referencing column

ORA-02266

unique/primary keys in table referenced by enabled foreign keys

ORA-02267

column type incompatible with referenced column type

ORA-02268

referenced table does not have a primary key

ORA-02269

key column cannot be of LONG datatype

ORA-02270

no matching unique or primary key for this column-list

ORA-02271

table does not have such constraint

ORA-02272

constrained column cannot be of LONG datatype

ORA-02273

this unique/primary key is referenced by some foreign keys

ORA-02274

duplicate referential constraint specifications

ORA-02275

such a referential constraint already exists in the table

ORA-02276

default value type incompatible with column type

ORA-02277

invalid sequence name

ORA-02278

duplicate or conflicting MAXVALUE/NOMAXVALUE specifications

ORA-02279

duplicate or conflicting MINVALUE/NOMINVALUE specifications

ORA-02280

duplicate or conflicting CYCLE/NOCYCLE specifications

ORA-02281

duplicate or conflicting CACHE/NOCACHE specifications

ORA-02282

duplicate or conflicting ORDER/NOORDER specifications

ORA-02283

cannot alter starting sequence number

ORA-02284

duplicate INCREMENT BY specifications

ORA-02285

duplicate START WITH specifications

ORA-02286

no options specified for ALTER SEQUENCE

ORA-02287

sequence number not allowed here

ORA-02288

invalid OPEN mode

ORA-02289

sequence does not exist

ORA-02290

check constraint (string.string) violated

ORA-02291

integrity constraint (string.string) violated – parent key not found

ORA-02292

integrity constraint (string.string) violated – child record found

ORA-02293

cannot validate (string.string) – check constraint violated

ORA-02294

cannot enable (string.string) – constraint changed during validation

ORA-02295

found more than one enable/disable clause for constraint

ORA-02296

cannot enable (string.string) – null values found

ORA-02297

cannot disable constraint (string.string) – dependencies exist

ORA-02298

cannot validate (string.string) – parent keys not found

ORA-02299

cannot validate (string.string) – duplicate keys found

ORA-02300

invalid value for OIDGENERATORS

ORA-02301

maximum number of OIDGENERATORS is 255

ORA-02302

invalid or missing type name

ORA-02303

cannot drop or replace a type with type or table dependents

ORA-02304

invalid object identifier literal

ORA-02305

only EXECUTE, DEBUG, and UNDER privileges are valid for types

ORA-02306

cannot create a type that already has valid dependent(s)

ORA-02307

cannot alter with REPLACE option a type that is not valid

ORA-02308

invalid option string for object type column

ORA-02309

atomic NULL violation

ORA-02310

exceeded maximum number of allowable columns in table

ORA-02311

cannot alter with COMPILE option a valid type with type or table dependents

ORA-02313

object type contains non-queryable type string attribute

ORA-02314

illegal use of type constructor

ORA-02315

incorrect number of arguments for default constructor

ORA-02320

failure in creating storage table for nested table column string

ORA-02322

failure in accessing storage table of the nested table column

ORA-02324

more than one column in the SELECT list of THE subquery

ORA-02327

cannot create index on expression with datatype string

ORA-02329

column of datatype string cannot be unique or a primary key

ORA-02330

datatype specification not allowed

ORA-02331

cannot create constraint on column of datatype string

ORA-02332

cannot create index on attributes of this column

ORA-02333

cannot create constraints on attributes of this column

ORA-02334

cannot infer type for column

ORA-02335

invalid datatype for cluster column

ORA-02336

column attribute cannot be accessed

ORA-02337

not an object type column

ORA-02338

missing or invalid column constraint specification

ORA-02339

invalid column specification

ORA-02340

invalid column specification

ORA-02342

replacement type has compilation errors

ORA-02344

cannot revoke execute on a type with table dependents

ORA-02345

cannot create a view with column based on CURSOR operator

ORA-02347

cannot grant privileges on columns of an object table

ORA-02348

cannot create VARRAY column with embedded LOB

ORA-02349

invalid user-defined type – type is incomplete

ORA-02351

internal error: string

ORA-02352

error setting an OCI attribute: string

ORA-02353

error fetching an OCI attribute: string

ORA-02354

error in exporting/importing data string

ORA-02355

error opening file: string

ORA-02356

The database is out of space. The load cannot continue

ORA-02357

header in file string may not contain correct information

ORA-02358

error in exporting or importing data

ORA-02359

database version in file string is not valid

ORA-02360

fatal error during data export/import initialization

ORA-02361

error while attempting to allocate number bytes of memory

ORA-02362

error closing file: string

ORA-02363

error reading from file: string

ORA-02364

error writing to file: string

ORA-02365

error seeking in file: string

ORA-02366

The following index(es) on table string were processed:

ORA-02367

read ended but had expected more data from file string

ORA-02368

the following file is not valid for this load operation

ORA-02369

internal number in header in file string is not valid

ORA-02370

internal metadata in file string is not valid

ORA-02371

Loader must be at least version string.string.string.string.string for direct path

ORA-02372

data for row: string

ORA-02373

Error parsing insert statement for table string.

ORA-02374

conversion error loading table string.string

ORA-02375

conversion error loading table string.string partition string

ORA-02376

invalid or redundant resource

ORA-02377

invalid resource limit

ORA-02379

profile string already exists

ORA-02380

profile string does not exist

ORA-02381

cannot drop PUBLIC_DEFAULT profile

ORA-02383

illegal cost factor

ORA-02391

exceeded simultaneous SESSIONS_PER_USER limit

ORA-02396

exceeded maximum idle time, please connect again

ORA-02397

exceeded PRIVATE_SGA limit, you are being logged off

ORA-02398

exceeded procedure space usage

ORA-02399

exceeded maximum connect time, you are being logged off

ORA-02400

explain plan output buffer size limit exceeded

ORA-02401

cannot EXPLAIN view owned by another user

ORA-02402

PLAN_TABLE not found

ORA-02403

plan table does not have correct format

ORA-02404

specified plan table not found

ORA-02405

invalid sql plan object provided

ORA-02420

missing schema authorization clause

ORA-02421

missing or invalid schema authorization identifier

ORA-02422

missing or invalid schema element

ORA-02423

schema name does not match schema authorization identifier

ORA-02424

potential circular view references or unknown referenced tables

ORA-02425

create table failed

ORA-02426

privilege grant failed

ORA-02427

create view failed

ORA-02428

could not add foreign key reference

ORA-02429

cannot drop index used for enforcement of unique/primary key

ORA-02430

cannot enable constraint (string) – no such constraint

ORA-02431

cannot disable constraint (string) – no such constraint

ORA-02432

cannot enable primary key – primary key not defined for table

ORA-02433

cannot disable primary key – primary key not defined for table

ORA-02434

cannot enable unique(string) – unique key not defined for table

ORA-02435

cannot disable unique(string) – unique key not defined for table

ORA-02436

date or system variable wrongly specified in CHECK constraint

ORA-02437

cannot validate (string.string) – primary key violated

ORA-02438

Column check constraint cannot reference other columns

ORA-02439

Unique index on a deferrable constraint is not allowed

ORA-02440

Create as select with referential constraints not allowed

ORA-02441

Cannot drop nonexistent primary key

ORA-02442

Cannot drop nonexistent unique key

ORA-02443

Cannot drop constraint – nonexistent constraint

ORA-02444

Cannot resolve referenced object in referential constraints

ORA-02445

Exceptions table not found

ORA-02446

CREATE TABLE … AS SELECT failed – check constraint violated

ORA-02447

cannot defer a constraint that is not deferrable

ORA-02448

constraint does not exist

ORA-02449

unique/primary keys in table referenced by foreign keys

ORA-02450

Invalid hash option – missing keyword IS

ORA-02451

duplicate HASHKEYS specification

ORA-02452

invalid HASHKEYS option value

ORA-02453

duplicate HASH IS specification

ORA-02454

Number of hash keys per block (string) exceeds maximum of string

ORA-02455

The number of cluster key column must be 1

ORA-02456

The HASH IS column specification must be NUMBER(*,0)

ORA-02457

The HASH IS option must specify a valid column

ORA-02458

HASHKEYS must be specified for a HASH CLUSTER

ORA-02459

Hashkey value must be a positive integer

ORA-02460

Inappropriate index operation on a hash cluster

ORA-02461

Inappropriate use of the INDEX option

ORA-02462

Duplicate INDEX option specified

ORA-02463

Duplicate HASH IS option specified

ORA-02464

Cluster definition can not be both HASH and INDEX

ORA-02465

Inappropriate use of the HASH IS option

ORA-02466

The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.

ORA-02467

Column referenced in expression not found in cluster definition

ORA-02468

Constant or system variable wrongly specified in expression

ORA-02469

Hash expression does not return an Oracle Number.

ORA-02470

TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.

ORA-02471

SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expre\ssion.

ORA-02472

PL/SQL functions not allowed in hash expressions

ORA-02473

Error while evaluating the cluster’s hash expression.

ORA-02474

Fixed hash area extents used (string) exceeds maximum allowed (string)

ORA-02475

maximum cluster chain block count of string has been exceeded

ORA-02476

can not create index due to parallel direct load on table

ORA-02477

can not perform parallel direct load on object string

ORA-02478

merge into base segment would overflow MAXEXTENTS limit

ORA-02479

error while translating file name for parallel load

ORA-02481

Too many processes specified for events (max string)

ORA-02482

Syntax error in event specification (string)

ORA-02483

Syntax error in process specification (string)

ORA-02484

Invalid _trace_buffers parameter specification (string)

ORA-02485

Invalid _trace_options parameter specification (string)

ORA-02486

Error in writing trace file string

ORA-02487

Error in converting trace data

ORA-02488

Error encountered when accessing file [string] for trace conversion

ORA-02490

missing required file size in RESIZE clause

ORA-02491

missing required keyword ON or OFF in AUTOEXTEND clause

ORA-02492

missing required file block increment size in NEXT clause

ORA-02493

invalid file increment size in NEXT clause

ORA-02494

invalid or missing maximum file size in MAXSIZE clause

ORA-02495

cannot resize file string, tablespace string is read only