Oracle database

How do I create a user and table space?

To clear and reestablish a user and table space for the repository database connection (for example, cds_user), issue the following set of commands:

DROP USER CDS_USER CASCADE; CREATE USER CDS_USER IDENTIFIED BY CDS_USERDEFAULT TABLESPACE CDS_USER TEMPORARY TABLESPACE TEMPQUOTA UNLIMITED ON CDS_USER;@$ORACLE_HOME/sqlplus/admin/pupbld;GRANT CONNECT, RESOURCE, UNLIMITED TABLESPACE TO CDS_USER;

Oracle schema evolve failed for namespace during migration

When migrating with a copy of the repository database, you might encounter the following error in engine.log while running configuration utility:

ERROR: registerOracleSchema schema evolve failed for 
namespace:http://xml.spss.com/dms/logging
java.sql.SQLException: [SPSSOEM][Oracle JDBC Driver][Oracle]ORA-30944: Error during 
rollback for XML schema 'http://xml.spss.com/dms/logging' table "XXXX"."InfoXXX_TAB" column 
''
ORA-02304: invalid object identifier literal
ORA-30942: XML Schema Evolution error for schema 'http://xml.spss.com/dms/logging' table 
<n/a> column ''

To address this problem, manually register the XML schema before migrating the database:

Export data from the source repository database.
In the target repository database, create a new user with the same name and privileges as the source database user.

Copy and register the following two schema files in the target repository database:

scoring-logging.xsd from the directory <CDS_INSTALL_DIR>\staging\scoring.package\logging\schemas\oracle
response-logging.xsd from the directory <CDS_INSTALL_DIR>\staging\DecisionManagement.package\logging\schemas\oracle

Here's example SQL for registering the schema:

CREATE DIRECTORY CADS_DIR_MIGR AS '<XSD_HOME>';
alter session set current_schema=<DB_SCHEMA>;
begin 
    dbms_xmlschema.registerschema(
    schemaurl => 'http://xml.spss.com/scoring/logging',
    schemadoc => bfilename('CADS_DIR_MIGR','scoring-logging.xsd')
    ); 
    end;
    /
    alter session set current_schema=<DB_SCHEMA>;
    begin 
    dbms_xmlschema.registerschema(
    schemaurl => 'http://xml.spss.com/dms/logging',
    schemadoc => bfilename('CADS_DIR_MIGR','response-logging.xsd')
    ); 
    end;
    /

Where <XSD_HOME> is the directory where scoring-logging.xsd and response-logging.xsd are located. <DB_SCHEMA> is the schema of your target database.

Import your data to the target database.
Install IBM® SPSS® Collaboration and Deployment Services and run the configuration utility. Map the database to the target destination.