My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.