Re: Where can I find real-life-examples about ORACLE installation

Remedy is a different beast all right. I found out about the schema thing when a PL/SQL function I wrote to retrieve dates (stored in seconds since the epoch) went awry, and the Oracle Discoverer templates I set up for our engineers stopped working. There are a couple tables, ARSCHEMA and I think it's FIELDS that will tell you what the table and field names are. Seagate(Crystal Reports) has an ODBC driver (ugh) that I'm told map these, or you can do what I did which is to create your own view using dynamic SQL.

Good Luck.

David A. Barbour
Oracle DBA

Jared Still wrote:
>
> So, he hasn't told you yet that the schemas are
> generated on the fly?
>
> Jared
>
> On Friday 20 April 2001 06:00, Lanteigne, Mike wrote:
> > Hello all,
> >
> > Funny you mention Remedy. I've been recently introduced to Remedy here at
> > my new job. I was about to refresh our QA database with production data
> > when I discovered the schema's were different! I took a look at the two
> > schemas and WOW, was that a shock (uglyyyyyyyyyy). Seems the DEV schema is
> > different from QA schema too. Next week I will meet with one the
> > consultants that implemented the app here. I hope there is some method to
> > the apparent madness (at least mapping between schemas).
> >
> > Mike Lanteigne
> >
> > The views expressed here are mine and do not reflect the official position
> > of my employer or the organization through which the internet was accessed.
> >
> > > -----Original Message-----
> > > From: Seley, Linda [SMTP:LSeley_at_IQNavigator.com]
> > > Sent: Friday, April 20, 2001 12:30 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: Where can I find real-life-examples about ORACLE
> > > installation
> > >
> > > With your 'free time' now would be a good time to work on putting Remedy
> > > out
> > > of business. ;-) It wouldn't be too hard and you'd be the hero of
> > > countless DBAs!
> > >
> > > Linda
> > > (who is very grateful never to have had to deal with AR but sure heard
> > > some
> > > ugly stories!)
> > >
> > > -----Original Message-----
> > > Sent: Thursday, April 19, 2001 7:50 PM
> > > To: Multiple recipients of list ORACLE-L
> > > installations?
> > >
> > >
> > >
> > > Comments embedded
> > >
> > > On Thursday 19 April 2001 15:31, Eric D. Pierce wrote:
> > > ...
> > >
> > > > As far as I know, structured denormalization is considered to be a
> > > > method for modification of a normalized design. There should be
> > > > disipline/method/rules that try to get the best performance increase
> > > > in a trade-off for the least collateral damage (extra coding).
> > > >
> > > > I get the impression that this is standard operating procedure,
> > > > documented in industry journals, and so forth.
> > > >
> > > > In your experience, what percentage of "real world" dbs are using
> > > > pure normalized designs?
> > >
> > > In my experience, DBA's are scum and developers lobby the managers
> > > with tales of how terrible life will be if they're forced to write code
> > > for
> > > a normalized database.
> > >
> > > I guess I'm saying that I can't recall starting with a completely
> > > normalized
> > >
> > > database ( just 3rd normal form here ) and then denormalize if we found
> > > it necessary for some reason.
> > >
> > > We've usually have had some denormalization in as soon as we started
> > > doing physical modeling. Sigh.
> > >
> > > If you're familiar with the Help Desk software 'Remedy', you will know
> > > that
> > > it has one of the worst schemas ever designed by man or beast. If you
> > > haven't seen it, you would have a hard time imagining it. Yes, worse
> > > than Finanacials, Lawson, SAP, etc.
> > >
> > > ( 'where is he going with this?' you ask )
> > >
> > > One of my fantasies is to build a help desk system that runs on a
> > > normalized
> > > schema, open source it, and put Remedy out of business. The schema
> > > is that bad.
> > >
> > > > Has this changed as hardware becomes more powerful and cheaper?
> > >
> > > Hardware, and Oracle has improved in it's ability to join. I assume
> > > other databases are faster than in years past as well.
> > >
> > > > pss, aren't you *ever* going to tell us what happened at your last
> > > > job?
> > >
> > > Sorry, thought I had.
> > >
> > > My previous employer laid off several folks. I wasn't among them
> > > however. Damagement decided to take this opportunity to redeploy several
> > > positions to HQ in Houston TX.
> > >
> > > If you've spent any time in the Pacific NorthWest, you may understand why
> > > I chose to stay here. Likewise if you've been to Houston :)
> > >
> > > ( hope I didn't offend any Texicans :)
> > >
> > > I'm taking this opportunity to attempt a slight career change and get
> > > into
> > > the contracting side of things.
> > >
> > > Jared
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Jared Still
> > > INET: jkstill_at_cybcon.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Seley, Linda
> > > INET: LSeley_at_IQNavigator.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  INET: dbarbour_at_nucentrix.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).