If there is the need to clone a Stat database repository the Admin has to take care of the following:
1. Take a good back-up of the STAT DEV that you are going to perform the test upgrade on
2. Export the STAT schema from STAT PROD
3. If the stat db that you are going to run the test upgrade on already contain all the tablespaces, stat user then there is no need to run the first install script in step a.
Step a. The first script is located in the stat download software. For example, 6.2\scripts\oracle\install. Locate the file called NORAv620-1.sql to create the proper tablespaces and etc.
4. Drop the stat schema from STAT DEV environment
5. Create a new STAT schema using the same password as STAT PROD. If not, user will end up getting second pass login when trying to login to STAT DEV db after the importing of the db.
5. From the STAT DEV database, import the stat.dmp schema.
6. Configure stat.ini to point to your STAT DEV db if you haven't done so
7. Try to login to STAT DEV db via Stat windows client, which is the exact copy of STAT PROD before proceeding with the upgrade.
