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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Storage Parameters for Indexes

Re: Storage Parameters for Indexes

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 18 Oct 2001 05:35:40 +0200
Message-ID: <tsu7mnr00q0i1d@corp.supernews.com>

"DBA-Jim" <jbizzaro_at_jackpot.com> wrote in message news:d612576.0110171555.70e1fa60_at_posting.google.com...
> Hello DBAers,
>
> I'm rebuilding all my Oracle tables with more suitable storage
> parameters. In regards to the storage parameters for indexes, will
> they use the storage parameters I specified for the table or do I need
> to create separate storage parameters for each?
>
>
> Thanks in advance,
>
>
> JGB
If you don't specify storage parameters they will use the storage parameters from the default storage clause in the tablespace they are created in.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Wed Oct 17 2001 - 22:35:40 CDT

Original text of this message

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