You can translate the question and the replies:

How to change database schema of Oracle base views

Hi, in our development system (denodo 6.0, latest update) we frequently want to change the database schema of many existing base views belonging to the same Oracle data source. The problem is that the schema name is included in every JDBC wrapper, for example: ``` CREATE OR REPLACE WRAPPER JDBC "TESTTAB" FOLDER = '/1_base' DATASOURCENAME=ora_sandbox_mb SCHEMANAME='SANDBOX_FRANZ' RELATIONNAME='TESTTAB' OUTPUTSCHEMA ( "A" = 'A' :'java.lang.String' (OPT) (sourcetyperadix='10', sourcetypename='VARCHAR2', sourcetypeid='12', sourcetypesize='10') SORTABLE ); ``` Changing the Oracle login in the data source does not change the JDBC wrappers. Our solution is to update the wrapper definition manually with the new schema name: ``` CREATE OR REPLACE WRAPPER JDBC "TESTTAB" FOLDER = '/1_base' DATASOURCENAME=ora_sandbox_mb SCHEMANAME='SANDBOX_HANS' RELATIONNAME='TESTTAB' OUTPUTSCHEMA ( "A" = 'A' :'java.lang.String' (OPT) (sourcetyperadix='10', sourcetypename='VARCHAR2', sourcetypeid='12', sourcetypesize='10') SORTABLE ); ``` This step is necessary for every single base view and it must be repeated everytime developer Hans does a VCS checkout that has been committed by developer Franz who uses a different schema name. Is there a better solution to change the DB schema for all base views belonging to the data source? Thank you.
user
03-05-2018 08:00:08 -0400

1 Answer

Hi, I would recommend you to create different environments in the Version Control System configuration for those users that will have different source configuration parameters. All the users should use their own database pointing to the same shared remote database. For the different environments, property files are created which contain the information like URI of the data source, schema of the tables and environment specific properties. So, modifying the schema in one users environment does not affect the other users. The [Environment Management](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/version_control_systems_integration/vcs_configuration/environment_management#environment-management) section of the VDP Administration Guide provides useful information about environments in VCS. If you have a Support user, do not hesitate to open a support case in the [Denodo Support site](https://support.denodo.com/). Hope this helps!
Denodo Team
07-05-2018 11:39:27 -0400
You must sign in to add an answer. If you do not have an account, you can register here