Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Index tablespace

Re: Index tablespace

From: Randy DeWoolfson <randyd_at_cais.com>
Date: Wed, 27 Oct 1999 17:06:41 -0400
Message-ID: <38176961.AEE198D@cais.com>


I just had this dilemma on my development system... I wanted to move all indexes that were in the USR tablespace to the INDX tablespace...

I tried using the Oracel Data Manager (cr*p) and it hung my instance so badly that I could not recover it... ( yes I know how ). anyway, I was reading some peoples comments on the TOAD tool ( toadsoft.com i think ) and I downloaded it.

It has a neat button that allows you to move indexes to another tablespace...
I clicked it, and it worked...

TOAD is pretty good, but I'm still not a complete lover of it yet :)) randy

Alex Yevzelman wrote:
>
> Actually, I don't have RAID and the database is spread over two disks on the same
> controller.
> Since the database is in the development stage right now and if I decided not to
> put the indexes in the separate tablespace, how hard would it be to move the
> indexes into a separate tablespace once the database in production?
>
> Also, if there is a separate index tablespace, is there a way to force a new index
> to be created by a user in the index tablespace instead of the user's default
> tablespace, if no tablespace is specified during creation?
>
> Thanks.
> Alex.
>
> Allen wrote:
>
> > Yes, but what if you have a raid device? There should be no difference in
> > performance
> > it that case.
> >
> > Edwin Esser wrote:
> >
> > > Putting the indexes in a seperate tablespace can come in very handy when you
> > > put that tablespace on a different disk. That way when you do a query, the
> > > index will be accessed through disk 1, the table itself on disk 2 => better
> > > performance through better response times.
> > >
> > > Edwin
> > >
> > > "Alex Yevzelman" <yevz0001_at_tc.umn.edu> wrote in message
> > > news:3815E9F2.4EF2619B_at_tc.umn.edu...
> > > > I am wondering, what are the advantages and disadvantages of having a
> > > > separate tablespace for indexes.
> > > > We are converting an MS Access aplication that has ~80Mb and growing of
> > > > data into Oracle 8i. Also, we are developing an application, which will
> > > > have ~10Mb of data.
> > > > I created a tablespace for each of these applications.
> > > >
> > > > Should I create a separate tablespace specifically for indexes or should
> > > > I keep indexes together with the other schema object in each of the
> > > > corresponding tablespaces?
> > > > What are the general guidelines for this type of problem?
> > > >
> > > > Thanks.
> > > > Alex.
> > > >
Received on Wed Oct 27 1999 - 16:06:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US