Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Basic: Index on Primary Key
You can specify the tablespace for the index in the CREATE TABLE or ALTER
TABLE.
"Praveen" <pmohanan_at_directvinternet.com> wrote in message
news:3CA416A5.A9311DFB_at_directvinternet.com...
> Hi..All,
>
> This might be a basic question. As far as I have learned, we should
> first create an Index(es) on the column(s) identified as primary key of
> a table. Then alter the table to create the primary key, so that the Key
> automatically uses the index instead of creating its own index in the
> system tablespace. How much of this is true?
>
> TIA
> --
>
>
> Regards,
>
> Praveen
>
>
Received on Fri Mar 29 2002 - 07:31:13 CST