Return
-
Title
DDL replication fails for tables with names longer than 30 characters. -
Description
When you run the alter statements for the tables having more than 30 characters, an aliased name will be used for original table name in forming the query and send the DDL record with the short name, which will cause poster to fail to post the DDL due to the wrong object / table name.
Post process fails with ORA--00942 table or view doesn't exist.
For Ex:
Source DDL : ALTER TABLE "T_CLEARANCE_SFTP_CONFIG_RECIEVE" MODIFY ("A_CONFIG_NAME" NOT NULL ENABLE);DDL comes to target as : "ALTER TABLE "_NK_0100086_NS_1" MODIFY ("A_CONFIG_NAME" NOT NULL ENABLE)"
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.