Re: Regarding database instance creation via the scripts generated by dbassist

On 6 Aug 2003 12:24:40 -0700, avsrk_at_mailcity.com (Subrahmanyam Arya) wrote:

>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

Sounds like you're asking the wrong questions. Assuming you can make this work (others have tried this, apparently with mixed success. Search the archives of this ng.) why can't you alter the scripts to create all the tablespaces the size you really want in the first place? If you are captureing the scripts out of dbassist before you burn them to the CD, then just modify them to set the appropriate values. Received on Wed Aug 06 2003 - 15:36:44 CDT