MicroStrategy8升级到9时遇到的错误ora-00955.doc

Error, Failed to execute: CREATE TABLE DSSMDOBJTRNS. error appears at the summary page of Configuration Wizard when trying to upgrade a MicroStrategy 8.1.x Metadata on a MicroStrategy Intelligence Server 9.0.x SYMPTOM:When trying to upgrade a metadata by following the following Technical Note:TN32647 -How to upgrade MicroStrategy 8.1.x or 9.0.0 metadata repository and project definitions to MicroStrategy 9.0.1. the following error is received in the last window of the Configuration Wizard:Sample Code/ErrorFailed to execute CREATE TABLE DSSMDOBJTRNS( PROJECT_ID .CAUSE:The same databsae space where 8.1.x metadata tables have been restored and are being upgradedwas used previously as a testing tablespacefor a 9.0.x metadata and some 9.0.x metadata tables such as DSSMDOBJTRNSstill exist there. For a complete list of 8.1.x and 9.x metadata tables, please see:TN30515 -List of tables for MicroStrategy 8.1.x and 9.x metadata repositoriesACTION:Clean up the database space and make sure no table exist prior to restoring 8.1.x metadata tables from the back up file. Run the Configuration Wizard to upgrade metadata.List of tables for MicroStrategy 8.1.x and 9.x metadata repositories Below isa list of the 10 tables contained in a MicroStrategy 8.1.x metadata repository: DSSMDLNKITEM DSSMDLNKPROP DSSMDOBJCMNT DSSMDOBJDEFN DSSMDOBJDEPN DSSMDOBJINFO DSSMDOBJPROP DSSMDOBJSECU DSSMDSYSPROP DSSMDUSRACCT Starting with MicroStrategy 9.x,thirteen additional tables were included: seven for Distribution Services, five for the Change Journal feature, and one for Metadata Internationalization. Below isa list of the 23 tables contained in a MicroStrategy 9.x metadata repository.Tables available since MicroStrategy 8.1.x: DSSMDLNKITEM DSSMDLNKPROP DSSMDOBJCMNT DSSMDOBJDEFN DSSMDOBJDEPN DSSMDOBJINFO DSSMDOBJPROP DSSMDOBJSECU DSSMDSYSPROP DSSMDUSRACCT Additional tables for the Distribution Services feature: DSSCSADDRESS DSSCSCONTACT DSSCSPSNLZTN DSSCSRCOLCON DSSCSRINSTRG DSSCSSUBINST DSSCSSYSPROP Additional tables for the Change Journal feature: DSSMDJRNINFO DSSMDJRNLNKS DSSMDJRNOBJC DSSMDJRNOBJD DSSMDJRNOBJS Additional table for the Metadata Internationalization feature: DSSMDOBJTRNS Additional tables in 9.0.1: DSSMDOBJDEF2 DSSMDOBJLOCK For more information on the 9.0.1 metadata changes, see TN32546 MicroStrategy Metadata 9.0.1 Upgrade Considerations.WARNING: Manually editing values in the MicroStrategy Metadata incorrectly may cause serious, project-wide problems that may make your project unusable. Since these are user-initiated chan