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