Oracle建表时为什么提示“ORA-00972:标识符过长”

[bamnm666]

CREATE TABLE T_Integration_GetServicePersonHaving
(
ID INTEGER NOT NULL,
Person_ID RAW(16) NULL,
ServiceType_ID INTEGER NULL,
Service_ID INTEGER NULL,
Service_Name varchar2(256) NULL,
Photo varchar2(1024) NULL,
Sort_ID INTEGER NULL,
System_ID INTEGER NULL
)

有什么错误吗

[cosio]

ORA-00972 identifier is too long

Cause: The name of a schema object exceeds 30 characters. Schema objects are tables, clusters, views, indexes, synonyms, tablespaces, and usernames.

Action: Shorten the name to 30 characters or less.

[小灰狼W]

表名太长

[bamnm666]

表名太长还不行?

[cosio]

表名太长了!

CREATE TABLE T_Integration_GetService
(
ID INTEGER NOT NULL,
Person_ID RAW(16) NULL,
ServiceType_ID INTEGER NULL,
Service_ID INTEGER NULL,
Service_Name varchar2(256) NULL,
Photo varchar2(1024) NULL,
Sort_ID INTEGER NULL,
System_ID INTEGER NULL
)

就可以了!

[小灰狼W]

规定不能超过30个字符
你应该可以缩短这个长度的，实在没有必要
看起来也难受

[ngx20080110]

1.Names must be from 1 to 30 bytes long with these exceptions:

◦Names of databases are limited to 8 bytes.

◦Names of database links can be as long as 128 bytes.

If an identifier includes multiple parts separated by periods, then each attribute can be up to 30 bytes long. Each period separator, as well as any surrounding double quotation marks, counts as one byte. For example, suppose you identify a column like this:

"schema"."table"."column"
The schema name can be 30 bytes, the table name can by 30 bytes, and the column name can be 30 bytes. Each of the quotation marks and periods is a single-byte character, so the total length of the identifier in this example can be up to 98 bytes.

[huangdachuan]

表名或者字段过长

[liucheng335210510]

oracle中表明，列明，标识列字符不能超过30个