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

Home -> Community -> Mailing Lists -> Oracle-L -> Fw: Index File Name

Fw: Index File Name

From: Alistair Orchard <alistair.b.orchard_at_btinternet.com>
Date: Tue, 20 Nov 2001 13:31:37 -0800
Message-ID: <F001.003CA050.20011120132331@fatcity.com>

Sorry for the assumption... :o)
I do find it best to specify the tablespace of the index to be different than the table, personally I use have a method of leaving:
DB Object code i.e. packages in the users default tablespace, Tables in one tablespace (i.e. Users_Tables) and indexes in another (User_indexes) over several disks to reduce <FONT face=Arial size=2>disk contention. Schemas will require a Temporary Tablespace and you of course will need the rollback tablespace as a non system tablespace cannot use the system rollback... a few public rollback segments, named in the init(SID).ora so they start up automatically with the instance etc etc.
 
 

<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

  Sent: Tuesday, November 20, 2001 8:20   PM
  Subject: RE: Index File Name   

  Alistair,
  The  index will be created in the
  default tablespace of the user, not in the tablespace of the table.  Try   it and check the results. 
  If you create the index in the same sql   statement as the table (like the primary key) then yes it may end up in the   same ts as the table.
  Lisa Koivu Oracle Database
  Monkey Fairfield Resorts, Inc. <FONT
  face=Georgia>954-935-4117   

    -----Original Message----- <FONT
    face=Arial size=1>From:   <FONT face=Arial     size=1>Alistair Orchard [SMTP:alistair.b.orchard_at_btinternet.com]     Sent:   <FONT face=Arial

    size=1>Tuesday, November 20, 2001 3:01 PM <FONT face=Arial 
    size=1>To:     <FONT face=Arial 
    size=1>Multiple recipients of list ORACLE-L <FONT face=Arial 
    size=1>Subject:        <FONT 
    face=Arial size=1>Re: Index File Name 
    If you don't specify an index tablespace the     index will occupy the same tablespace as     the Table... It's probably best to have a     tablespace for indexes and one for the tables <FONT face=Arial     size=2>If you create an index tablespace,  a good name might be     'User_Indexes' ? Received on Tue Nov 20 2001 - 15:31:37 CST

Original text of this message

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