Re: Cannon create table with Primary Key in tablespace

From: Joe Seefeldt <joezaloom_at_hotmail.com>
Date: 2000/04/13
Message-ID: <QSyJ4.139723$Pa1.3631456@news6.giganews.com>#1/1

Thanks for the reply

Some more info:

The table is being created in the default tablespace 'DEV_DATA'

I don't think the tablespace is getting to tight on space to create an index - I just inserted 200 rows into the categories table.

I create another table, and specify a primary key using

create table elements (

 element_id  int,
 parent_id  int ,--references elements.element_id,
 format_id  int ,--references formats.format_id,

 dt_created date DEFAULT (sysdate),
 dt_modified date DEFAULT (sysdate),
 status int,
 elem_text long,
 PRIMARY KEY (element_id)
)

and this one works.

I try to 'alter table categories
add constraint pk_categories
primary key (category_id)'

and this bombs with the same error.

Thanks again,
js
Tom Zamani <tomz_at_redflex.com.au> wrote in message news:8d6c1i$i75$1_at_perki.connect.com.au...
> 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 Thu Apr 13 2000 - 00:00:00 CDT