Re: problems creating new database

On Sun, 03 Sep 2006 19:35:54 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>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.

Hey, I resent that.
I'm at least Cretaceous. :-)

• Rich