Re: I can attach in SQL Server, but can I in Oracle?

Ron Fluegge wrote:

> Daniel,
>
> Again thanks for the civil response, but I will take issue with your
> statement that I have not taken the time to check this out.
>
> I have searched both Google and Deja for the topic at hand.
>
> I have the following books on Oracle and have attempted to read them all to
> the extent I can:
>
> Oracle Programming with Visual Basic
> Oracle 8 -- A Beginner's Guide
> Teach yourself Oracle 8 in 21 Days
> Oracle 8i for Windows NT -- Starter Kit
> Oracle 9i for Windows 2000 -- Tips & Techniques
> Oracle Essentials -- Oracle 9i, Oracle 8i & Oracle 8
> Oracle 9i -- The Complete Reference
>
> This is not counting the Oracle help and doc files installed with both 8i
> and 9i that I have searched and attempted to understand as well. I have
> read every MS/MDSN/Visual Studio/.NET Mag article regarding connecting with
> Oracle from the 1.0 and 1.1 versions of the Framework that I could find --
> some of which were written by Oracle staff. Could I have read more? Yes.
>
> I searched everything I could on the net, including the Oracle site without
> finding what I needed ... yes, it could be my fault that I didn't find the
> exact solution. So?
>
> Obviously, you and many others who respond to this newsgroup are much more
> knowledgeable and expert than I and others who post to this newsgroup.
>
> In response to your criticism, I have searched all that you referred to and
> have read as much as reasonably possible. You obviously are more expert
> than I in the area of Oracle.
>
> However, I find your responses and reactions interesting to requests for
> help even though you have no way of knowing whether I searched or read -- or
> did not.
>
> This group is no different than others I am familiar with ... some people
> are helpful and some are not. Some criticize the use of terms -- others,
> who understand, overlook the terminology issue and provide help to a person
> in need.
>
> As in every software application I have ever written, I always proceed at my
> own risk ... BTW, you will find my "solution" to the multi-source datalayer
> in an upcoming developer magazine article. Hope you get a chance to read it
> and enjoy it.
>
> Again, thanks for the response even though we may differ in our assessment
> of the situation.
>
> Ron
>
> "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3F344A59.F44197B5_at_exxesolutions.com...
> > Ron Fluegge wrote:
> >
> > > Daniel,
> > >
> > > Do you also criticize the non-English speaking posters as well for not
> using
> > > > > <snipped>
> > > >
> > > > If by database you mean the Oracle software ... read Oracle's license.
> If
> > > you
> > > > are trying to use a Microsoft term "database" to mean the equivalent
> > > Oracle term
> > > > "schema" this is done by putting the DDL used to create the objects
> into
> > > one or
> > > > more scripts and execute them from SQL*Plus as part of the install.
> Refer
> > > to
> > > > c:\oracle\ora92\rdbms\admin\sql.bsq for an example of how this is
> done.
> > > >
> > > > And ... in the future ...when posting in an Oracle group .... use
> Oracle
> > > terms
> > > > ... not Microsoft terms. You will get more valuable answers.
> > > > --
> > > > Daniel Morgan
> > > > http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> > > > damorgan_at_x.washington.edu
> > > > (replace 'x' with a 'u' to reply)
> > > >
> > > >
> >
> > Acknowlding that you are not an expert is not an excuse for not reading
> books,
> > looking at web sites, searching the google.com archives, etc. No I don't
> > criticize those that make an honest effort.
> >
> > When you misuse terms you must accept the responsibility for the responses
> you
> > get. And the responses you saw but didn't like were a direct result of
> your
> > misuse of the word database.
> >
> > BTW: I am very familiar with the framework you are using. That does not
> change
> > my opinion. Proceed at your own risk as the framework assumes that the
> person
> > using it understands Oracle architecture and concepts and as you seemingly
> > acknowledge you haven't time to study either.
> >
> > --
> > Daniel Morgan
> > http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> > damorgan_at_x.washington.edu
> > (replace 'x' with a 'u' to reply)
> >
> >

Good start ... but what you really need to do is go to http://tahiti.oracle.com [Quoted] and look up the database architecture and concepts documents.

The most critical part you must understand is the mutliversion concurrency model. If you don't you may be in for a rude surprise in the future. If you can [Quoted] find, borrow, or beg a copy of Tom Kyte's "Expert one-on-one Oracle" do so. The [Quoted] first three chapters are essential reading for what you are attempting.

BTW: My comments to you are based on many years and many projects that followed [Quoted] the pattern of SQL Server developers building something that appeared to work [Quoted] ... right up until it didn't. My notes are cautionary ... not screams that the sky is falling.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)