Error

https://docs.oracle.com/en/error-help/db/

에러 코드 확인

oerr ora 955
oerr sp2 591


ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

ORA-00059: maximum number of DB_FILES exceeded

ORA-00439: feature not enabled: %s

ORA-00900: invalid SQL statement

ORA-00911: invalid character

ORA-00932: inconsistent datatypes: expected %s got %s

ORA-00955: name is already used by an existing object

ORA-00959: tablespace ‘%s’ does not exist

ORA-00972: identifier is too long

ORA-00988: missing or invalid password(s)

ORA-00997: illegal use of LONG datatype

ORA-01008: not all variables bound

ORA-01013: user requested cancel of current operation

ORA-01017: invalid username/password; logon denied

ORA-01153: an incompatible media recovery is active

ORA-01418: specified index does not exist

ORA-01438: value larger than specified precision allowed for this column

ORA-01476: divisor is equal to zero

ORA-01502: index ‘%s.%s’ or partition of such index is in unusable state

ORA-01549: tablespace not empty, use INCLUDING CONTENTS option

ORA-01555: snapshot too old: rollback segment number %s with name “%s” too small

ORA-01652: unable to extend temp segment by %s in tablespace %s

ORA-01654: unable to extend index %s.%s by %s in tablespace %s

ORA-01658: unable to create INITIAL extent for segment in tablespace %s

ORA-01688: unable to extend table %s.%s partition %s by %s in tablespace %s

ORA-01779: cannot modify a column which maps to a non key-preserved table

ORA-01790: expression must have same datatype as corresponding expression

ORA-01795: maximum number of expressions in a list is 1000 error

ORA-01861: literal does not match format string

ORA-01922: CASCADE must be specified to drop ‘%s’

ORA-01940: cannot drop a user that is currently connected

ORA-01950: no privileges on tablespace ‘%s’

ORA-02019: connection description for remote database not found

ORA-02287: sequence number not allowed here

ORA-02429: cannot drop index used for enforcement of unique/primary key

ORA-02437: cannot validate (%s.%s) - primary key violated

ORA-03214: File Size specified is smaller than minimum required

ORA-04031: unable to allocate %s bytes of shared memory (“%s”,”%s”,”%s”,”%s”)

ORA-08180: no snapshot found based on specified time

ORA-10631: SHRINK clause should not be specified for this object

ORA-10636: ROW MOVEMENT is not enabled

ORA-12014: table ‘%s’ does not contain a primary key constraint

ORA-12162: TNS:net service name is incorrectly specified

ORA-12537: TNS:connection closed

ORA-12545: Connect failed because target host or object does not exist

ORA-12703: this character set conversion is not supported.

ORA-12719: operation requires database is in RESTRICTED mode

ORA-12838: cannot read/modify an object after modifying it in parallel

ORA-12899: value too large for column %s (actual: %s, maximum: %s)

ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations

ORA-14086: a partitioned index may not be rebuilt as a whole

ORA-14400: inserted partition key does not map to any partition

ORA-14451: unsupported feature with temporary table

ORA-14511: cannot perform operation on a partitioned object

ORA-14701: partition-extended name or bind variable must be used for DMLs on tables partitioned by the System method

ORA-19573: cannot obtain %s enqueue for datafile %s

ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: %s, maximum: %s)

ORA-22858: invalid alteration of datatype

ORA-22868: table with LOBs contains segments in different tablespaces

ORA-24344: success with compilation error

ORA-28000: The account is locked

ORA-28040: No matching authentication protocol

ORA-29851: cannot build a domain index on more than one column

ORA-30036: ORA-30036: unable to extend segment by %s in undo tablespace ‘%s’

ORA-30052: invalid lower limit snapshot expression

ORA-30926: unable to get a stable set of rows in the source tables

ORA-32463: cannot create an object with a name matching private temporary table prefix

ORA-38029: object statistics are locked

ORA-38104: Columns referenced in the ON Clause cannot be updated: %s

ORA-39002: invalid operation, ORA-39070: Unable to open the log file., ORA-29283: invalid file operation, ORA-06512: at “SYS.UTL_FILE”, line 536, ORA-29283: invalid file operation

ORA-39809: Data saves are not allowed on tables with domain indexes.

ORA-60100: dropping temporary tablespace with tablespace ID number (tsn) %s is blocked due to sort segments

ORA-65096: invalid common user or role name


SP2-0591: Unable to allocate dynamic space needed (%s bytes)

SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled


LPX-00216: invalid character ~1u (~2X)