Identifier too long in Oracle

Question

I'm trying to create a table in SQL Developer but I get this error:

Error SQL: ORA-00972: Identifier too long

CREATE TABLE PACIENTE (
    IdentificacionID number(5),
    TipoIdentificacionID number(5),
    Nombre varchar(30),
    Apellido varchar(30),
    NumeroHistoriaClinica number(5),
    FechaNacimiento DATE,
    CiudadID number(5),
    SexoID number(5),
    EstadoCivilID number(5),
    OcupacionID number(5),
    NivelEscolaridadID number(5),
    EPSID number(5),
    IPSID number(5),
    Direccion varchar(30),
    Telefono number(10),
    AntecedentesFamiliares varchar(30),
    IndAntecedenteFamiliarTromboembolico varchar(1)
);

I tried to change the values of the varchar but it didn't work.

What is the problem?

buzzsawddog buzzsawddog · Accepted Answer · 2013-09-26T02:41:18

You can not have greater than 30 characters for your identifier. Just a quick count looks like IndAntecedenteFamiliarTromboembolico is your offender. It is 36 characters long.

Identifier too long in Oracle

2 Answers