Various Errors When Executing DDL on Streams Target After Custom Transformation and Multi-byte Charactersets Used
Last updated on FEBRUARY 28, 2011
Applies to:Oracle Server - Enterprise Edition - Version: 220.127.116.11
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"
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