| |
Results |
|
Dimensions: How to export/import base databases
|
sqlplus system/<password>@<dsn> SQL> create user < basedb > identified by <password> default tablespace pcms_data
|
|
|
|
KM-Dim10: To create a new base database or export a process model you must issue the CRDB or EXPM commands in DMDBA
|
dmdba system/<password>@<SID> EXPM <exportfilename> <product-id> / basedb =<basedbname> To create a new base database with the recently exported process model, the command is a follows:
|
|
|
|
KM-Dim9: What the base database exports contains?
|
KM-Dim9: What the base database exports contains?
|
|
|
|
KM-Dim9: Is it possible to do an export of just the Dimensions 8.0.1.x schema instead of a full export as documented in the Upgrade Users Guide?
|
KM-Dim9: Is it possible to do an export of just the Dimensions 8.0.1.x schema instead of a full export as documented in the Upgrade Users Guide?
|
|
|
|
Dim CM 14.x: Unable to connect to new Base Database created with Process Model export
|
A new base database was created using a Process Model export created with the EXPM command. However when an attempt was made to connect to the new base database the following errors occurred:
|
|
|
|
KM-Dim7: Creating a Dimensions 7 Base Database with a Dimensions 6 Process Model Export
|
Create the new Base Database as normal and run the Dimensions 7 upgrade scripts
|
|
|
|
KM-Dim9: How to create a base database based on a process model export
|
For Dimensions 8.x and 9.1.x: To create a new base database with a recently exported process model, you must issue the CRDB command in DMDBA. Note: In order to perform the below commands you will need to connect to DMDBA as system.
|
|
|
|
2009R2 : crdb using an export file fails: "An error occurred while creating the base database - will now delete it."
|
Creating the new base database DEMO_CM. Please wait...
|
|
|
|
DimCM: Oracle: “EXP-00003: no storage definition found for segment(0, 0)” when exporting base database schema.
|
The purpose of this was to save space on disk, as no space was being used up by these empty tables. The side effect is that the EXP utility, which is an old utility to export data, cannot properly handle empty tables without segments. As a result these tables will not be included in the export file and, subsequently, will be missing from the schema after it's imported.
|
|
|
|
KM-Dim9: When trying to run the CRDB command with a Process Model export from Dimensions 7, error of Error: unknown command , Error detected in basedb_cpl.exp, line 1 occurs.
|
This is because the export file format in Dimensions 8.x and 9.1.x is very different and the scripts that create the new Base Database cannot interpret the file generated from Dimensions 7 installations. The errors you receive will look like this:
|
|
|
