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.