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

Home -> Community -> Usenet -> c.d.o.server -> Re: Stupid Newbie Tricks

Re: Stupid Newbie Tricks

From: David Fitzjarrell <oratune_at_aol.com>
Date: Fri, 17 Nov 2000 20:01:40 GMT
Message-ID: <8v42qu$342$1@nnrp1.deja.com>

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

Original text of this message

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