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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
