Re: Cannon create table with Primary Key in tablespace

The other thing which you need look at is the inital and the next extend which has been set for that table space. when it is not defined in table creation it will be picked up from table space set up.
Tom

Joe Seefeldt <joezaloom_at_hotmail.com> wrote in message news:QSyJ4.139723$Pa1.3631456_at_news6.giganews.com...
> 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 Fri Apr 14 2000 - 00:00:00 CDT