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

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

Re:Index File Name

From: <dgoulet_at_vicr.com>
Date: Tue, 20 Nov 2001 12:49:12 -0800
Message-ID: <F001.003C9F0E.20011120122534@fatcity.com>

Why do I get this awful feeling, something like a wet diaper, on this one?

Your script should have you create the database which will create the system tablespace by default and run a number of sql scripts from the $ORACLE_HOME/rdbms/admin directory. It then should create a tablespace for rollback segments, a temporary tablespace, a users tablespace, and a tools tablespace. The last two are somewhat optional, but I always put them there. You should then create a number of rollback segments in the appropriate tablespace from above. This forms your basic Oracle database. Now you are into creating those tablespaces needed by an application which should consist of data and index tablespaces. Then each application, IMHO, should have it's own schema owner whose default tablespace is for data and a specified tablespace for indexes. Now will Oracle create a separate tablespace for indexes? NO, it's more than happy to have the data and indexes in the same tablespace assuming there's enough room. Your performance may not be the best, but it's still happy.

Dick Goulet
Oracle Certified 8i DBA

____________________Reply Separator____________________
Author: Ken Janusz <ken.janusz_at_sufsys.com>
Date:       11/20/2001 11:25 AM

I am creating a database from a DDL SQL script. I have created the primary and temp tablespaces because their names were referenced in the code. However, there is no name reference anywhere that I can find for the "index" tablespace. Do I need to create one, or will Oracle take care of that for me? If I have to create on, what name do I give it, or does it matter?

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ken Janusz
  INET: ken.janusz_at_sufsys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: dgoulet_at_vicr.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 20 2001 - 14:49:12 CST

Original text of this message

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