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 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: 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:
CMS-XML KM-Dim8: max # extents (99) reached in table .SEC_CM_DBFILES
2. Do not proceed with the next steps if there are errors from the export command: sqlplus <basedb>/<password> SQL> drop table sec_cm_dbfiles;
CMS-XML KM-Dim9: How to Export a Product's Process Model
dmdba system/<password>@<SID> EXPM <exportfilename> <product-id> / basedb =<basedbname> Documentation References:
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs