Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stupid Newbie Tricks
>
> 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.
Received on Fri Nov 17 2000 - 13:37:21 CST