Cannon create table with Primary Key in tablespace

Am I stupid? Probably.

I create a simple table, with a PK:

create table categories (
 category_id int PRIMARY KEY,
 cat_name varchar2(40),
 cat_desc varchar2(64)
)

or

create table categories (
 category_id int ,
 cat_name varchar2(40),
 cat_desc varchar2(64),
 PRIMARY KEY (category_id)
)

and I get the error message: ORA-01658: unable to create INITIAL extent for segment in tablespace DEV_DATA

I remove the reference to PK, i.e:

create table categories (
 category_id int ,
 cat_name varchar2(40),
 cat_desc varchar2(64)
)

and it is successful. What am I missing?

thanks,
js Received on Thu Apr 13 2000 - 00:00:00 CDT