Return
-
Title
Procedures to Import Stat Database -
Description
What is the correct procedure to import/export Stat Database?
-
Resolution
1. From PROD database, used Oracle import/export utility to export the stat schema. Save as stat.dmp file
2. From TEST database, run the attached script - NORAv550-1.sql. This will create Tablespaces, Users, Roles, Permissions. DO NOT run any other scripts.
3. Find out the correct password for stat schema on PROD database. From TEST database, change stat schema password accordingly to match stat schema password from PROD database.
4. From TEST database, import the stat.dmp schema using Oracle import/export utility.
-
Attachments