Re: HELP -- Change Oracle SID - Restore of Database

2011-05-12 Thread jham36
Make sure the tnsnames.ora file in your oracle client is pointing to the correct database. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

HELP -- Change Oracle SID - Restore of Database

2011-05-11 Thread Pam Hollis
Some data was deleted out of my Asset Mgmt System. I had a restore of he database(product) done and put onto my development server. The Oracle Sid is different since it was restored from production server. I want to change the SID on my dev box so that I can access data and pull out the