送分！送分！送分！

[GOUSHIJIE]

这个SQL语句有什么问题：
CREATE TABLE "MINIMIS"."CARINSURANCELNFO"("INSUR" VARCHAR2(20)
NOT NULL, "CARID" VARCHAR2(20) NOT NULL, "CARZBH" VARCHAR2(10),
"CARBXQ" DATE, "CARBXZ" DATE, "CARBXR" VARCHAR2(10), "CARGZRQ"
DATE, "CARGZF" VARCHAR2(10), "CARJYZ" VARCHAR2(10), "CARSGJL"
VARCHAR2(500), "CARSCTB" DATE, "CARTBGS" VARCHAR2(50), "CARTBJE"
VARCHAR2(8), "CARTBXZ" VARCHAR2(30), "CARBZ" VARCHAR2(20),
"CARRQ" DATE)
TABLESPACE "USERS" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING ;
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."INSUR" IS '投保编号当前时间';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARID" IS '车牌号';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARZBH" IS '保险自编号';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARBXQ" IS '保险起';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARBXZ" IS '保险止';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARBXR" IS '被保险人';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARGZRQ" IS '车辆购置日';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARGZF" IS '车辆购置费';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARJYZ" IS '车辆经营者';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARSGJL" IS '车辆事故记录';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARSCTB" IS '第一次投保日期';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARTBGS" IS '投保公司';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARTBJE" IS '投保金额';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARTBXZ" IS '投保险种';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARBZ" IS '备注';
COMMENT ON COLUMN "MINIMIS"."CARINSURANCELNFO"."CARRQ" IS '登记日期'

[yangzhangheng_jim]

没有问题，有问题也是你建表的用户不存在。

[jlandzpa]

你有什么问题？

[yuxuan]

把引号去掉试试

[jlandzpa]

19:20:43 jlanzpa817>CREATE TABLE "CARINSURANCELNFO"("INSUR" VARCHAR2(20)
19:21:09 2 NOT NULL, "CARID" VARCHAR2(20) NOT NULL, "CARZBH" VARCHAR2(10),
19:21:09 3 "CARBXQ" DATE, "CARBXZ" DATE, "CARBXR" VARCHAR2(10), "CARGZRQ"
19:21:09 4 DATE, "CARGZF" VARCHAR2(10), "CARJYZ" VARCHAR2(10), "CARSGJL"
19:21:09 5 VARCHAR2(500), "CARSCTB" DATE, "CARTBGS" VARCHAR2(50), "CARTBJE"
19:21:09 6 VARCHAR2(8), "CARTBXZ" VARCHAR2(30), "CARBZ" VARCHAR2(20),
19:21:09 7 "CARRQ" DATE)
19:21:09 8 TABLESPACE "USERS" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
19:21:09 9 STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096
19:21:09 10 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
19:21:09 11 LOGGING ;

表已创建。

已用时间: 00: 00: 01.52

[jlandzpa]

用户不存在

[GOUSHIJIE]

提示：超出表空间‘USER’的空间容量

[jlandzpa]

早说不就行了？
alter user MINIMIS quota 100m on USER;

[visc]

方法之一：
从DBA_DATA_FILES找到表空间user包含的数据文件 增大其大小
alter database datafile '........' resize ...M;

[jlandzpa]

不是数据文件小，而是user在表空间的限量小了.

[GOUSHIJIE]

还是同样的问题

[jlandzpa]

操作过程贴出错误来。

[GOUSHIJIE]

在ORACLE的DBA中新建立一个表,他提示:超出表空间'SYSTEM'的空间限量

[jlandzpa]

alter user username quota 100m on SYSTEM;

[GOUSHIJIE]

jlandzpa(欧高黎嘉陈) 谢谢，你有MSN吗

[jlandzpa]

几乎不用，很忙，最好不要在system上建东西.

[GOUSHIJIE]

jlandzpa(欧高黎嘉陈)写了