Re: Tablespace for primary Key

From: Edorta <edortta_at_yahoo.es>
Date: Fri, 08 Oct 1999 08:12:12 +0200
Message-ID: <37FD8B3C.3B4DC3C8@yahoo.es>

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 - 01:12:12 CDT