Regarding database instance creation via the scripts generated by dbassist

From: Subrahmanyam Arya <avsrk_at_mailcity.com>
Date: 6 Aug 2003 12:24:40 -0700
Message-ID: <25c1993e.0308061124.1b624972@posting.google.com>

Dear oracle gurus,

We are productizing our application that bundles oracle software (oracle 8.1.7 standard and target platform sun sparc ) and instance in its installation package. To acheive this, i used dbassist to create a db instance. Instead of dbassist actaully creating the instance, i save instance creation as scripts so that i could invoke from my installer.
I want my product/oracle software/databse instance every thing in one CD-ROM. I cannot be using the default sizes in the SIZE clause for various tablespaces.

Question is ? How much low/minimum value can i specify in the SIZE clause for various tablespaces ( tools,rollback,temp,user,index). Is there any consequence of doing so like this.

After the product/oracle/database is installed, i would then like to do ALTER TABLESPACE ADD DATA FILE to each one of them and increase the size.

-Any suggestions regarding this would be appreciated
-thx,

avsrk Received on Wed Aug 06 2003 - 14:24:40 CDT