Re: Off Topic, slightly - Crystal Reports internal format

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.

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

-- 
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).