Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Off Topic, slightly - Crystal Reports internal format

Re: Off Topic, slightly - Crystal Reports internal format

From: <Jared.Still_at_radisys.com>
Date: Mon, 10 Jun 2002 16:33:21 -0800
Message-ID: <F001.00479C0A.20020610163321@fatcity.com>


Jeff,

I can't use the production database name to point to the reporting database.

That might mess up the apps that are actually supposed to connect to the production database. :) The name resolution all takes place in the Oracle
Names server.

As far as recreating the schema to match production: I already have folks using it as is. Matching the Account and table names exactly just goes against my grain. :) A reasonable tool could handle this with aplomb.

Perl, or even SQL*Plus for example. Users could handle SQL*plus w/o too much trouble. :) But they like the pretty charts. Of course if they
learn Perl, they could use DBD::Chart...

Jared

Jeff Herrick <jherrick_at_host.ott.igs.net> Sent by: root_at_fatcity.com
06/10/2002 04:58 PM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: Off Topic, slightly - Crystal Reports internal format




On Mon, 10 Jun 2002 Jared.Still_at_radisys.com wrote:

> 1) for the dbname...why not just change the SID in TNSNAMES
> that the ODBC DSN is using to point to the snap-shotted(?)
> instance
>
> I'm eliminating tnsnames.ora files on the desktop, so that is out.
>

Sorry...I haven't used onames or OID yet; but does it not still provide the same level of abstraction as TNSNAMES without the file? The ODBC DSN is still separate and will have to resolve whether it is doing so through names or whatever. I still think you would change the logical side (service_name) to point at a different physical db and Bill's fine ODBC software won't care. The risk is that they use the same DSN for updating; then you would have a problem.

> 2) I think private synonyms would be the way to go for the
> table naming problem. Why did they not just use the same
> names on the snapshot site....been there done that, got the
> T-shirt
>
> Private synonyms will either:
> * not work
> * confuse the user.
>
> 'They' is me. The table names reflect the fact that the
> tables are materialized views. FWIW there are public
> synonyms for the tables, but Crystal doesn't use them.
>
> Jared

'Crystal doesn't use them'??? then the schema must be encoded in the SQR SQL statements. If this is true then you have another problem because you want to rename the schema. If you don't want to modify/recompile the SQR then why not create the schema that SQR expects and front the MV tables with synonyms.

Oh...and when did we start caring if the user was confused? =8-) j/k

Cheers

Jeff H.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Herrick
  INET: jherrick_at_host.ott.igs.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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.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).
Received on Mon Jun 10 2002 - 19:33:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US