Re: 9i server - how to avoid spatial, intermedia, jserver, etc

Never mind - answered my own question! You have to select a 'template' that does not include datafiles. Once you do that, you can deselect all optional components.

Reason I did not try that earlier was that when I read 'do not include datafiles', I thought the database would be created (instance, etc) but no datafiles - actual tablespace storage objects.

Now I realize that a template can include 'actual storage objects', which means it simply copies a bunch of ready-made datafiles for the creation of the new database.

On Sat, 15 Dec 2001 21:44:31 GMT, Chris S <cschofie_at_nospam.slip.net> wrote:

>I've just installed Oracle 9i server and am trying to migrate a ton of
>databases to this server - space is therefore at a premium.
>
>The source databases (8i) do not have intermedia, jserver, spatial,
>etc. In 8i, when I created those databases (using the database
>configuration assistant) I deselected these options.
>
>Now, when I create the target database in 9i, I don't seem to be able
>to deselect these 'options'. There are several screens that show
>these as options - (in the template, it shows 'common options' and
>lists them as 'true') But I can't find anywhere to make this 'false'!
>
>Thanks, Chris
Received on Sat Dec 15 2001 - 16:38:45 CST