Ò»¸ö¼òµ¥µÄsqlÓï¾ä - Oracle / ¿ª·¢

create table user_b.abcd
( a number constraint abc_pk primary key 
using index
(create index abc_index on user_b.abcd(a) tablespace users),
b number
);

------------------
SQL> @h:\code\6.sql
(create index abc_index on user_b.abcd(a) tablespace users),
  *
µÚ 4 ÐгöÏÖ´íÎó:
ORA-00903: ±íÃûÎÞЧ

Óï¾äÓÐʲôÎÊÌ⣿£¿£¿£¿£¿£¿

---

±í»¹Ã»Óд´½¨³É¹¦¡£Äã¿ÉÒÔÏȽ¨±í£¬ÔÙ½¨Ë÷Òý
create table user_b.abcd
( a number );
alter table TGL_user_b.abcd
add 
constraint abc_pk primary key (a) tablespace users);

---

ÒýÓÃ

create table user_b.abcd
( a number constraint abc_pk primary key
using index
(create index abc_index on user_b.abcd(a) tablespace users),
b number
);

------------------
SQL> @h:\code\6.s¡­¡­

°Ñuser_b.È«²¿È¥µô

---

ÒýÓÃ

ÒýÓÃÂ¥Ö÷ liukai_happy µÄ»Ø¸´:
create table user_b.abcd
( a number constraint abc_pk primary key
using index
(create index abc_index on user_b.abcd(a) tablespace users),
b number
);

-------------¡­¡­

ÕâÑù¿ÉÒÔÁË°É£¿
˳±ã˵Ï Ö÷¼üĬÈϾÍÓÐindexµÄ û±ØҪн¨indexµÄ

---

ÒýÓÃ

create table user_b.abcd
( a number constraint abc_pk primary key
using index<