1.6w+
社区成员
- 主页
- Oracle 基础和管理
- Oracle 高级技术
- Oracle 认证与考试
- 职位交流
- 问答
新建表時報ORA-00904錯~~?
-- Create table
create table TBL_ITEM_ESP
(
ITEMNO varchar2(15) not null,
DESC varchar2(500),
Mar varchar2(2) default 0 not null
)
tablespace USERS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 1M
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Grant/Revoke object privileges
create table TBL_ITEM_ESP
(
ITEMNO varchar2(15) not null,
DESC varchar2(500),
Mar varchar2(2) default 0 not null
)
tablespace USERS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 1M
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Grant/Revoke object privileges
...全文
请发表友善的回复…
发表回复
zlz_212 2006-03-07
来晚了 汗！
WeiCui 2006-03-06
ORA-00904 string: invalid identifier
Cause: The column name entered is either missing or invalid.
Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.
Cause: The column name entered is either missing or invalid.
Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.
ggygd 2006-03-03
ZJDING
boydgmx 2006-03-03
SQL> create table TBL_ITEM_ESP
2 (
3 ITEMNO varchar2(15) not null,
4 DESC varchar2(500),
5 Mar varchar2(2) default 0 not null
6 )
7 /
DESC varchar2(500),
*
ERROR 位于第 4 行:
ORA-00904: : 无效的标识符
看看报错时那个*号所在的位置，就知道哪里错了。
DESC 是个保留字，不能用的。
非要用的话，可以：
SQL> create table TBL_ITEM_ESP
2 (
3 ITEMNO varchar2(15) not null,
4 "DESC" varchar2(500),
5 Mar varchar2(2) default 0 not null
6 )
7 /
表已创建。
2 (
3 ITEMNO varchar2(15) not null,
4 DESC varchar2(500),
5 Mar varchar2(2) default 0 not null
6 )
7 /
DESC varchar2(500),
*
ERROR 位于第 4 行:
ORA-00904: : 无效的标识符
看看报错时那个*号所在的位置，就知道哪里错了。
DESC 是个保留字，不能用的。
非要用的话，可以：
SQL> create table TBL_ITEM_ESP
2 (
3 ITEMNO varchar2(15) not null,
4 "DESC" varchar2(500),
5 Mar varchar2(2) default 0 not null
6 )
7 /
表已创建。
bobfang 2006-03-03
ORA-00904 string: invalid identifier
Cause: The column name entered is either missing or invalid.
应该是desc字段名的问题，desc是保留字。
Cause: The column name entered is either missing or invalid.
应该是desc字段名的问题，desc是保留字。