Re: Tablespace for primary Key

If you've already created these tables and indexes, you can easily move the indexes to the appropriate tablespace (Oracle 7.3.4 & higher) by using:

   ALTER INDEX indexname REBUILD TABLESPACE new_tablespace;

HTH,
Brian

Edorta wrote:
>
> Hi, Shi
>
> I'm more used to scripts than to GUI tools, and there's no problem to
> do that using scripts:
>
> ALTER TABLE <table_name> ADD (
> CONSTRAINT <pk_name>
> PRIMARY KEY (<fields>)
> USING INDEX
> tablespace <tbsp_name>)
> /
>
> Hope this helps,
> Edorta
>
> Shi yousong wrote:
>
> > Hi,
> > I have a silly question here. Oracle treats the primary Key of a
> > table
> > as index. So the default storage location should be the same with
> > the
> > data segment of the table. What shall I do if I want to specify a
> > different location for the implicit index? Can I do that ? I can not
> >
> > find a correspondent method to do this in Enterprise Manager or
> > other
> > GUI tool.
> >
> > regards,
> >
> > Sam Shi
Received on Fri Oct 08 1999 - 09:36:36 CDT