Jan
02
2020
T45-2019 MDDR 2019.2 database import requires modification on parfile
MDDR 2019.2
Database
MDDR 2019.2
Operating System
All operating systems supported for BIOVIA Direct
Description
MDDR 2019.2 database dump file import will fail on creating tables. Error messages look like:
ORA-39083: Object type TABLE:"MDDR"."MDDR2D_CAS" failed to create with error:
ORA-00959: tablespace 'ROB_DBS' does not exist
Resolution
Open the par file mddrdirect_dp.par with a text editor and replace the original tablespace name ‘mdl_data’ in remap_tablespace entry with ‘rob_dbs’, for example:
from
remap_tablespace=mdl_data:tablespace_name
to
remap_tablespace=rob_dbs:tablespace_name
where the ‘tablespace_name‘ must have your tablespace name for your MDDR database schema.
JIRA # CDB-771
How to contact BIOVIA Support
If you have any questions, please contact BIOVIA Support.