the 10.2 dbca still leaves much to be desired

One might think that the current version of the database creation assistant - after being revised in 8.1.7, 9.0.1, 9.2, 10.1 - would be a mature product in the 10.2 release of the database server software.

Alright, no one that has actually used it would make that (wrongful) assumption.

What irked me today, was that for a Standard Edition install (do not create starter database) that the dbca still includes creation scripts for

Label Security
Spatial

Aren't there any loops closed there regarding feedback from customers? If 10g R2 will need less database administration, why is it that from a dbca-created database that one would manually have to remove the components that dbca is too brain-dead to determine require the enterprise edition of the database server software to be installed?

Anyone that has upgraded a dbca-created standard edition 9.2 database to 10.1 knowns that dba_registry will have stuff in there that isn't needed and is invalid after the upgrade.

Seeing that the past 2 critical patch updates had a rather larger number of gaping holes in objects owned by oracle-provided schemas such as mdsys - wouldn't the Oracle community in general have less vulnerabilities if such components were not installed by default - escpecially where they cannot even be leveraged?

I guess that's it for now.

Paul

<sample dbca-generated database create script>

set verify off
PROMPT specify a password for sys as parameter 1; DEFINE sysPassword = &1
PROMPT specify a password for system as parameter 2; DEFINE systemPassword = &2
host D:\oracle\product\10.2.0\db_2\bin\orapwd.exe file=D:\oracle\product\10.2.0\db_2\database\PWDmydb.ora password=&&sysPassword force=y
@D:\oracle\admin\mydb\dbca\CreateDB.sql
@D:\oracle\admin\mydb\dbca\CreateDBFiles.sql
@D:\oracle\admin\mydb\dbca\CreateDBCatalog.sql
@D:\oracle\admin\mydb\dbca\JServer.sql
@D:\oracle\admin\mydb\dbca\odm.sql
@D:\oracle\admin\mydb\dbca\context.sql
@D:\oracle\admin\mydb\dbca\xdb_protocol.sql
@D:\oracle\admin\mydb\dbca\ordinst.sql
@D:\oracle\admin\mydb\dbca\interMedia.sql
@D:\oracle\admin\mydb\dbca\cwmlite.sql
@D:\oracle\admin\mydb\dbca\spatial.sql
@D:\oracle\admin\mydb\dbca\ultraSearch.sql
@D:\oracle\admin\mydb\dbca\labelSecurity.sql
@D:\oracle\admin\mydb\dbca\ultraSearchCfg.sql
@D:\oracle\admin\mydb\dbca\postDBCreation.sql

--
http://www.freelists.org/webpage/oracle-l