Re: Method for migrating schema from PROD to DEV
From: Andre van Winssen <dreveewee_at_gmail.com>
Date: Tue, 25 Nov 2008 12:12:12 +0100
Message-ID: <9b46ac490811250312u7c7522a7l44a6c376d33f79f3@mail.gmail.com>
Date: Tue, 25 Nov 2008 12:12:12 +0100
Message-ID: <9b46ac490811250312u7c7522a7l44a6c376d33f79f3@mail.gmail.com>
Hi Jeremy,
No matter which method you use for copying, there are some info security angles also that you should consider.
- it's not a good idea to develop on a production database (in case your DEV schema is in the same database as PROD). Also, in that case if you'd use public synonyms or other global objects such as DIRECTORY's, things can get complicated and dangerously mixed
- copying production data to development means endangering confidentiality of that production dataset
best be to run DEV in a separate database and use some datamasking mechanism to protect production data. GC 10.2.0.4 has a licensed pack for it but with some effort you could write a simple one for your own purpose.
-- regards, Andre -- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 25 2008 - 05:12:12 CST