Re: Oracle DBA Studio, almost useful
Date: Sat, 22 Nov 2003 08:53:27 -0800
Message-ID: <1069520036.239157_at_yasure>
Jarmo wrote:
> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1069481773.698748_at_yasure...
>
>>You've made at least two critical mistakes. >> >>First ... no table should ever, for any reason, be built as SYSTEM >>unless it is built as part of the Oracle installation.
>
>
> Ah, I'm not sure how I could have known that. I didn't explicitly request
> SYSTEM (or anything in fact). Thanks.
Ah but you did. You may not have known it which is why I am encouraging you, as strongly as possible, to get out of DBA Studio. It is a very bad place for you to be working if you want to become competent.
>
>>Second ... you named a column 'name' which is a reserved word in >>Oracle.
>
> Ouch. Is this because the designers of Oracle and/or SQL did a poor job of
> separating the column and SQL-syntax namespaces?
I have no idea why. I suspect because you typed it in but why doesn't
matter. See advice above.
>
>
>>See SELECT * FROM v_$reserved_words WHERE LOWER(keyword) LIKE 'n%'; >> >>Beyond that you should not be buiding in-line constraints and as far as >>I am concerned as an educator you shouldn't be touching or building >>anything in DBA Studio until you can first do it flawlessly in SQL*Plus.
>
>
> From a practical standpoint, this is probably a good suggestion. But from
> the outside looking in, it's competely backwards, of course -- you ought to
> use the GUI programs first because they hide the underlying complexity and
> only once you understand the underpinnings (should you ever actually need
> to) then you can move to the command line tools. But we're not living in an
> ideal world, of course.
This is Oracle. The GUI is there to help people that know what they are doing be more productive. It is not intended, as in perhaps a Microsoft product, to substitute for reading manuals and getting an education.
>
>>So close DBA Studio. Open SQL*Plus, log on as SYSTEM and create a user >>account and grant it appropriate privileges. Then log on as that user >>and start learning Oracle. >> >>And if my above instructions seem a bit cryptic ... that is with intent. >>The answers to the questions you will have can be found at >>http://tahiti.oracle.com.
>
>
> Thanks for that reference.
>
>
>>Learn to fish.
>
>
> Teach the fishing industry to make fishing rods that can actually be used
> without having to spend two weeks on a fishing DBA course ;-)
I like that. But think how hard it would be for Larry to afford his new boat, or me to afford any boat at all, if it were not for the complexity. ;-)
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Sat Nov 22 2003 - 17:53:27 CET