Re: default tablespace for indexes

Thanks Daniel,

I guess if I had thought about it for a minute more I would have realised it was a default tablespace for everything. As for thinking about I/O, I do a bit, but it irks me. My move into the SQL world was an attempt to make life ultimately easier for myself and do my job more efficiently -- to move a set of badly structured (from the point of view of analysis) flat files to a properly structured, easily queryable database. In the process I have unfortunately found myself mired in concerns over number and size of rollback segments, number of db block buffers, reclaiming space from deletes, etc. It's like trading my bicyle for a ten ton truck. The bicyle worked fine for short trips, but was tiring for long ones. The ten ton truck uses a lot of gas, requires more maintenance, but is solid as a rock, and may, if I can work out the gears, eventually get me to the grocery store.

Jon

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D0916FC.BD186743_at_exesolutions.com...
> Jon Waterhouse wrote:
>
> > Is there a way to specify a default tablespace for indexes the same way
that
> > there is for tables created in a schema, or must the TABLESPACE whatever
> > always be included in the CREATE INDEX command?
> >
> > Thanks (using 8i and 9i - the 9i starter database comes with an INDX
> > tablespace I think I should be using more than I am).
> >
> > Jon
>
> You have misunderstood default tablespace.
>
> There is no default tablespace for tables. There is just 'a' default
tablespace
> for everything you build.
>
> It is up to developers to either let it, by default, all throw itself into
a
> single tablespace or demonstrate judgement and an understanding of their
> system's I/O to put things where they belong.
>
> Daniel Morgan
>
Received on Fri Jun 14 2002 - 06:59:44 CDT