"ORA-00922: missing or invalid option" Error Generated When Creating ARCHIVE_C Tables During dbpatch.sh

(Doc ID 2411261.1)

Last updated on JUNE 14, 2018

Applies to:

Oracle Transportation Management - Version 6.3.1 to 6.4.3 [Release 6.3 to 6.4]
Information in this document applies to any platform.

Symptoms

When running dbpatch.sh to migrate to Version 6.4.3, the following errors are generated in the logs when setting up the new ARCHIVE_C tables.

Setting up ARCHIVE_C tables...
No errors.
ERROR AT create table ARCHIVE_C.DM_TRANSACTION_STATUS(DM_TRANSACTION_SEQ_NO NUMBER ,STATUS_TYPE_GID VARCHAR2(101
CHAR),STATUS_VALUE_GID VARCHAR2(101 CHAR),DOMAIN_NAME VARCHAR2(50 CHAR),INSERT_USER VARCHAR2(128 CHAR),INSERT_DATE
DATE,UPDATE_USER VARC
ORA-00922: missing or invalid option
ERROR AT create table ARCHIVE_C.DM_TRANSACTION_REMARK(DM_TRANSACTION_SEQ_NO NUMBER ,REMARK_SEQUENCE NUMBER
,REMARK_QUAL_GID VARCHAR2(101 CHAR),REMARK_TEXT VARCHAR2(4000 CHAR),DOMAIN_NAME VARCHAR2(50 CHAR),INSERT_USER
VARCHAR2(128 CHAR),INSERT_DATE D
ORA-00922: missing or invalid option

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms