MQSeries.net :: View topic

dkeister

I am trying to create a server on AIX with workflow 3.5 to using Oracle 9.2.0.6.0 for runtime database. I am using an existing Oracle SID. When fmczutil tries to create the database, I get an error:

FMC31000E A database error occurred. SQL code: -942

I am wondering if I have missed a step. Do I need to create tablespaces before the tables within an existing database can be created?

The fmcztab.log indicates it is trying to execute SQL:

SQL> CREATE TABLE CONTAINER
2 (
3 BIID RAW(16) NOT NULL
4 , CIID NUMBER(10,0) NOT NULL
5 , LAST_UPDATED TIMESTAMP_WF NOT NULL
6 , SHORT_DATA RAW(1024)
7 , CONSTRAINT PK_CONTAINER PRIMARY KEY
8 (
9 BIID
10 , CIID
11 ) USING INDEX TABLESPACE INSTINDX
12 )
13 TABLESPACE CONTAINR;
TABLESPACE CONTAINR
*
ERROR at line 13:
ORA-0059: tablespace 'CONTAINR' does not exist

Any suggestions?

Dean Keister