An Error ORA-01740 Is Being Caused By The Full Migration With Functional Index
(Doc ID 3036895.1)
Last updated on JULY 29, 2024
Applies to:
Siebel CRM - Version 22.12 and laterInformation in this document applies to any platform.
Symptoms
When performing the full migration, an error ORA-01740 is encountered due to the functional index.
Steps :
1. In the DR environment, add a function-based index to a table.
2. To apply the changes, click the Apply Button.
3. To publish the Table, execute the following command.
siebdev /c tools.cfg /l enu /d ServerDataSrc /u sadmin /p siebel /IncrementalTablePublish C:\Tables.txt
4. Login to the Migration Application, perform a full migration, and move the zip file to the RR Environment fs/Migration folder.
5. In the RR environment, log in to the Migration Application and import the file that was moved from DR.
6. The following error is present in the ddlimport file.
2024-01-19 14:44:18 S1000: [tp][ODBC Oracle driver][Oracle]ORA-00905: missing keyword
2024-01-19 14:44:18
2024-01-19 14:44:18 create index CX_LIGNE_FRESS_M61 on CX_LIGNE_FRESS
2024-01-19 14:44:18 ("STATUT_LGN", "X_ID_INDIVIDU", CAST(CREATED) parallel nologging
2024-01-19 14:44:18 tablespace siebel
2024-01-19 14:44:18
2024-01-19 14:44:18 ;
2024-01-19 14:44:18 writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
2024-01-19 14:44:18 writeExecDDL error (pOperCallback UTLDbDdlOperIndCreate33).
2024-01-19 14:44:19 Error in MainFunction (UTLDbDdlDbMerge).
2024-01-19 14:44:19 Error in Main function...
2024-01-19 14:44:19 (logapi.cpp (184) err=1 sys=2) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 2, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)
Changes
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 |
Changes |
Cause |
Solution |
References |