Hello all, I have Analytics 7.6.06 installed in my development environment (Oracle database) and need to refresh it with a copy from production. That would mean losing all the objects (package, functions, stored procs, tables, views etc.). Is there any way I could rerun manually all the .sql scripts in the installation package to restore the schema, or is the only way to restore is by reinstalling analytics again? My second question would be, how about if I want to make my Analytics/BO installation point to a different Remedy database, could I BO ODBC to point to the new database and also run the SQL scripts or do I have to reinstall again? I am finding the option of reinstalling tedious and problematic so would appreciate if anyone who attempted this can shared their thoughts. Best Regards frex
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

