Re: Creating database manually

Rauf Sarwar wrote:
> GreyBeard wrote:
> <snip>
>
> > Why do you want to create the database manually?
>
> Why not? It's a good learning exercise to get intimate with Oracle.
As
> a personal choice, I don't use DBCA and prefer to create a database
> using scripts.
>
> > While there is nothing wrong with doing so, many who ask that
> question
> > have a basic misunderstanding of Oracle.
> Care to elaborate on this.
>
> Regards
> /Rauf

Apparently you've not experienced someone used to SQL Server, Sybase, Access or MySQL thinking that creating a database in Oracle is just as simple as issuing a 'create databse mydb' command. Many who ask think such is the 'end of the line', yet those of us who do know realise this is not the case. Creating a database in Oracle is far more involved, starting with the 'Create database' command and running through the catalog creation scripts, tabkespace creation commands, and package installation scripts, as well as creating the init.ora file, the directory locations for all of the files (control files, redo logs, tablespaces, archive logs) and whether or not to configure the database for archivelog mode. Mistakes in any of these scripts will be difficult for anyone not familiar with the process to discover, much less resolve.

It is far better for a newbie to use DBCA, choose the option of creating scripts for the database creation, then using those scripts as a roadmap or blueprint for any further databases they may choose to create. Having a solid example to follow is worth far more than letting someone unfamiliar with database creation start from scratch, make mistakes, become disillusioned or frustrated and curse Oracle becuase it is not like the above mentioned database products.

Simpluy because you and I (and most others who contribute here) are capable of creating a database from scratch, calling it a 'good learning experience', in no way qualifies someone completely unfamiliar with the product to do so. In such a case compassion is better than throwing someone to the wolves, so to speak. making DBCA the logical starting point for a persons first Oracle database.

David FItzjarrell Received on Tue Jan 04 2005 - 07:45:59 CST