17,089
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE "TEST1"."BADSCORE"
( "NEWSCORE" NUMBER(20,1),
"ID" NUMBER,
"OLDSCORE" NUMBER(5,1),
CONSTRAINT "SCORE_PK_BCC" FOREIGN KEY ("ID")
REFERENCES "TEST1"."BCC" ("ID") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
[/quote]
建议你把所有双引号都去掉。。[/quote]
这个是系统自己生成的
CREATE TABLE "TEST1"."BADSCORE"
( "NEWSCORE" NUMBER(20,1),
"ID" NUMBER,
"OLDSCORE" NUMBER(5,1),
CONSTRAINT "SCORE_PK_BCC" FOREIGN KEY ("ID")
REFERENCES "TEST1"."BCC" ("ID") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
[/quote]
建议你把所有双引号都去掉。。
CREATE TABLE "TEST1"."BADSCORE"
( "NEWSCORE" NUMBER(20,1),
"ID" NUMBER,
"OLDSCORE" NUMBER(5,1),
CONSTRAINT "SCORE_PK_BCC" FOREIGN KEY ("ID")
REFERENCES "TEST1"."BCC" ("ID") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
select * from user_tab_privs
你通过上面的sql查询一下权限[/quote]
突然间好了,我SQL_developer重启了一下,然后我就那么一试,然后就可以删除了,
奇怪[/quote]
授权以后没重新登录吧。select * from user_tab_privs
你通过上面的sql查询一下权限[/quote]
突然间好了,我SQL_developer重启了一下,然后我就那么一试,然后就可以删除了,
奇怪select * from user_tab_privs
你通过上面的sql查询一下权限
CREATE TABLE "TEST1"."BADSCORE"
( "NEWSCORE" NUMBER(20,1),
"ID" NUMBER,
"OLDSCORE" NUMBER(5,1),
CONSTRAINT "SCORE_PK_BCC" FOREIGN KEY ("ID")
REFERENCES "TEST1"."BCC" ("ID") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
[/quote]
建议你把所有双引号都去掉。。[/quote]
这个是系统自己生成的[/quote]
反正你自己看着弄就行了,你现在的表名应该是 “表名”