Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stupid Newbie Tricks
In our last gripping episode jkipp_at_mbna.com wrote:
>
> >
> > It may well be that the storage parameters for the tablespace will
> > suffice for the primary key index created therein. You should also
> > have access to USER_TABLESPACES which will provide the tablespace
names
> > you have access to. There should be an index tablespace named with
> > IDX, INDX, INDEX or some such derivative (including the '_'
character)
> > most probably named after the related data tablespace:
> >
> > USER_DATA
> > USER_INDX
> >
> > as an example. Once you have this information it is a simple task
to
> > move the index to the proper location:
> >
> > alter index pk_temp rebuild tablespace <your index tablespace>;
> >
> > To use the tablespace examples listed above your primary key would
be
> > located in USER_DATA (presuming that USER_DATA is your default
> > tablespace). To move the index, named pk_temp, you would execute:
> >
> > alter index pk_temp rebuild tablespace user_indx;
> >
> > When the command has successfully completed your primary key index
will
> > be located in the USER_INDX tablespace, separate from the table
data.
> >
> > If you have difficulty determining the proper index tablespace you
> > should be able to ask your friendly neighborhood DBA. He or she
should
> > be able to help you.
> >
> >
>
> Thanks David. Armed with this information, I should be able to bug the
> DBA without seeming to much like an annoying user :-)
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
You are most welcome. I am always happy to help.
-- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.Received on Fri Nov 17 2000 - 14:01:40 CST