Re: Cannon create table with Primary Key in tablespace

When you create a table and do not specify the table space it will be created in the system table space.
so you need to check the table spaces if there is enough space in them. Try to create your tables in your own table space. Tom

Joe Seefeldt <joezaloom_at_hotmail.com> wrote in message news:zquJ4.88970$17.1949987_at_news4.giganews.com...
> 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 Fri Apr 14 2000 - 00:00:00 CDT