Re: problems creating new database

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 03 Sep 2006 19:35:54 -0700
Message-ID: <1157337355.353494@bubbleator.drizzle.com>

Richard Piasecki wrote:
> On 3 Sep 2006 11:47:46 -0700, "Michael42" <melliott42_at_yahoo.com>
> wrote:
>

>> MichalF,
>>
>> I am just curious why in this day and age (10g) you are not using the
>> DBCA to create your databases as it's interface helps to ensure these
>> type anomalies to not occur?
>>
>> Thanks,
>>
>> Michael

>
>
> Real DBAs don't use GUIs. :-)
> I make a habit of always knowing how to do something in SQLPLUS. I
> expect other DBAs to know the same. The last thing I want to hear at
> an interview when I ask a question like, "what command do you use to
> create a database?" is "There is no command. I start the DBCA GUI and
> ...". That person doesn't get a job at that point. I feel it is very
> important to understand what is involved in creating a database (or
> doing anything with the database, for that matter). The DBCA hides
> this information, making it too easy to perform the task without
> having the necessary knowledge.
>
> If I wanted to use a GUI, I'd use SQLServer.
>
> Then again, I'm a minimalist. I believe in using the bare minimum of
> tools to perform my tasks. I write all my software using VI. Heck, I
> debug my software using VI.
>
> I even write HTML code with VI.
> Seriously.
>
>
> --- Rich

I do too. And I agree with the sentiment that a decent DBA should know what is going on under the GUI. That is one reason in my Grid Control classes I always cover DBMS_SQLTUNE, DBMS_ADVISOR, etc.

But I sure wouldn't want some Jurassic DBA hand-writing a script to create a production database unless he was donating his time.

-- 
Puget Sound Oracle Users Group

Received on Sun Sep 03 2006 - 21:35:54 CDT