Various Errors When Executing DDL on Streams Target After Custom Transformation and Multi-byte Charactersets Used
(Doc ID 1299650.1)
Last updated on JANUARY 28, 2020
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
ORA-00933: SQL command not properly ended
ORA-02158: invalid CREATE INDEX option (for create index DDL)
and so forth. Printing out the error from DBA_APPLY_ERROR using the procedures in Note 405541.1: "Procedure to Print LCRs" reveals that the DDL statement has extra characters inserted at the end of it that are blank spaces interspersed with the same characters that comprise the last part of the DDL statement. For example, for an original DDL statement of:
CREATE INDEX STREAMS_TEST.TEST_DUMMY ON STREAMS_TEST.TEST(C2)
NEXT 1M MAXEXTENTS 200 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4);
might result in something similar to the following in DBA_APPLY_ERROR (output of the print_transaction procedure):
ddl: CREATE INDEX STREAMS_TEST_2.TEST_DUMMY ON STREAMS_TEST.TEST(C2)
NEXT 1M MAXEXTENTS 200 PCTINCREASE 0 FREELISTS 4
FREELIST GROUPS 4) 0 F R E E L I S T S 4 F R E E L I S T G R O U P S
Note the echoed text at the end with blank spaces in between each character.
Note 783203.1: "How to Setup Custom Rule Based Transformation"
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