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 <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/10/2002 04:58 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Off Topic, slightly - Crystal Reports internal format
On Mon, 10 Jun 2002 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
