| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:Index File Name
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).
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
 |
 |