Database Extract: Extract a local database without encryption

Starting Siebel 8, it is by default that local database is encrypted. This creates a lot of headache. If you do not require a encrypted local database, it is a good idea to extract a local database without encryption.

When you extract the local database, specify below parameters:

Encrypt client Db password = False
Client Database encryption method = none

If you create a non-encrypted local database, you will still need to copy the file ‘mwc_storage.cfg’ file from the ${Tools}\bin directory to the ${Client}\bin directory and update the local ODBC section in the client CFG file (assumes extraction took place using Tools)

In some scenarios, you may need to have local database without encryption as a workaround. An example is mentioned in support.oracle.com, Parallel Siebel development for Siebel 8.1 using Terminal Server -one tools / multiple local encrypted databases [ID 1074091.1]