Find Answers

Filter Search Results
All Operating Systems:
All Products:

All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
Pages [Next]
  Results
CMS-XML Dimensions: How to export/import base databases
sqlplus system/<password>@<dsn> SQL> create user < basedb > identified by <password> default tablespace pcms_data
CMS-XML 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:
CMS-XML KM-Dim9: What the base database exports contains?
KM-Dim9: What the base database exports contains?
CMS-XML 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?
CMS-XML 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:
CMS-XML 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
CMS-XML 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.
CMS-XML 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.
CMS-XML 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:
CMS-XML KM-Dim9: User unable to define basedb on a network node in Admin Console
table is blank in some rows. To fix the problem user will need to export pcms_sys.schema for backup, then logon to SQL*Plus as pcms_sys and run the following:
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs