操作系统是Solaris.建两张表中的任何一张都不会出错,但是两张同时建的话,就会报错。下面是建表语句:
CREATE TABLE TABLE_OWNER.aq_port_range_conf
(
port_range_id integer NOT NULL,
logical_machine_id integer NOT NULL,
range_size integer NOT NULL,
port_start integer NOT NULL,
CONSTRAINT pk_aq_port_range_conf PRIMARY KEY (port_range_id) using index tablespace TINYINDEXSPACE,
CONSTRAINT fk_aq_port_range_conf FOREIGN KEY (logical_machine_id) REFERENCES node_cluster(logical_machine_id) ON DELETE CASCADE)
STORAGE (initial TINYTABLESIZE next TINYTABLESIZE pctincrease TINYTABLEPCTINCREASE) tablespace TINYTABLESPACE;CREATE TABLE TABLE_OWNER.aq_port_range (
logical_machine_id integer NOT NULL,
port_range_id integer NOT NULL,
port integer NOT NULL,
logical_process_name VARCHAR2(10) NULL,
logical_process_instance integer NULL,
pid integer NULL,
CONSTRAINT pk_aq_port_range PRIMARY KEY (logical_machine_id,port_range_id,port) using index tablespace TINYINDEXSPACE,
CONSTRAINT fk_aq_port_range FOREIGN KEY (port_range_id) REFERENCES aq_port_range_conf(port_range_id) ON DELETE CASCADE)
STORAGE (initial TINYTABLESIZE next TINYTABLESIZE pctincrease TINYTABLEPCTINCREASE) tablespace TINYTABLESPACE;
这里是错误提示:
CREATE TABLE swpro_xyz_1101.sequences
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace STAFFWAR上面所说的sequences表的建表语句是:
CREATE TABLE TABLE_OWNER.sequences
(
seq_id number(5) NOT NULL,
seq_val number(20) NOT NULL,
seq_name varchar2(24) NOT NULL,
CONSTRAINT pk_sequences PRIMARY KEY (seq_id) using index tablespace TINYINDEXSPACE
) STORAGE (initial TINYTABLESIZE next TINYTABLESIZE pctincrease TINYTABLEPCTINCREASE) tablespace TINYTABLESPACE;
grant select, insert, delete, update on TABLE_OWNER.sequences to FOREGROUND_USER;折磨我一整天了,现在所知道的就是:单独建aq_port_range_conf或aq_port_range都不会出错,但是放一起就会报错,真郁闷哪位大大给说说啊,谢谢了
CREATE TABLE TABLE_OWNER.aq_port_range_conf
(
port_range_id integer NOT NULL,
logical_machine_id integer NOT NULL,
range_size integer NOT NULL,
port_start integer NOT NULL,
CONSTRAINT pk_aq_port_range_conf PRIMARY KEY (port_range_id) using index tablespace TINYINDEXSPACE,
CONSTRAINT fk_aq_port_range_conf FOREIGN KEY (logical_machine_id) REFERENCES node_cluster(logical_machine_id) ON DELETE CASCADE)
STORAGE (initial TINYTABLESIZE next TINYTABLESIZE pctincrease TINYTABLEPCTINCREASE) tablespace TINYTABLESPACE;CREATE TABLE TABLE_OWNER.aq_port_range (
logical_machine_id integer NOT NULL,
port_range_id integer NOT NULL,
port integer NOT NULL,
logical_process_name VARCHAR2(10) NULL,
logical_process_instance integer NULL,
pid integer NULL,
CONSTRAINT pk_aq_port_range PRIMARY KEY (logical_machine_id,port_range_id,port) using index tablespace TINYINDEXSPACE,
CONSTRAINT fk_aq_port_range FOREIGN KEY (port_range_id) REFERENCES aq_port_range_conf(port_range_id) ON DELETE CASCADE)
STORAGE (initial TINYTABLESIZE next TINYTABLESIZE pctincrease TINYTABLEPCTINCREASE) tablespace TINYTABLESPACE;
这里是错误提示:
CREATE TABLE swpro_xyz_1101.sequences
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace STAFFWAR上面所说的sequences表的建表语句是:
CREATE TABLE TABLE_OWNER.sequences
(
seq_id number(5) NOT NULL,
seq_val number(20) NOT NULL,
seq_name varchar2(24) NOT NULL,
CONSTRAINT pk_sequences PRIMARY KEY (seq_id) using index tablespace TINYINDEXSPACE
) STORAGE (initial TINYTABLESIZE next TINYTABLESIZE pctincrease TINYTABLEPCTINCREASE) tablespace TINYTABLESPACE;
grant select, insert, delete, update on TABLE_OWNER.sequences to FOREGROUND_USER;折磨我一整天了,现在所知道的就是:单独建aq_port_range_conf或aq_port_range都不会出错,但是放一起就会报错,真郁闷哪位大大给说说啊,谢谢了
解决方案 »
- 一个接口类型的属性映射到表字段要怎么做
- Linux平台上oracle的安装
- 不用SQL语句建表问题
- ORACLE的默认日期格式如何修改?在线等!高手请指点!
- 我是新手,那位能告诉我关于日期的问题
- 导数据-菜鸟问题-操作成功马上给分
- 怎么查看一条SQL语句的执行情况,如有没有执行成功??在SQL/PL里
- 请指出这两个SQL语句的问题,谢谢!
- c语言编写oracle数据库,使用游标,然后死在循环里了
- mysql的数据迁移到oracle上
- 菜鸟提问: procedure中使用execute时报ora-00928为什么?
- c_identityno=decode(:GSysParameter.ModifyIdentity,1,:ar.identityno[k],c_identityno)怎么用
对ORACLE的建表不是很熟悉。
alter user xxx quota 10m on tablespaceName;
查看限额:
select *from dba_ts_quotas;
1 SYSAUX DMSYS 262144 209715200 32 25600 NO
2 SYSAUX OLAPSYS 16318464 -1 1992 -1 NO
3 SYSAUX SYSMAN 55902208 -1 6824 -1 NO有什么地方需要修改吗?另,谢谢oracledbalgtu 的回复。