"ORA-00922: missing or invalid option" Error Generated When Creating ARCHIVE_C Tables During dbpatch.sh
(Doc ID 2411261.1)
Last updated on JULY 20, 2024
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
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
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |