My Oracle Support Banner

DDL Generation Fails for Table Name that Include $ Sign in the Name (Doc ID 2187798.1)

Last updated on JULY 31, 2018

Applies to:

Oracle SQL Developer Data Modeler - Version All and later
Information in this document applies to any platform.

Symptoms

Trying to generate DDL for a table that in the name has $ sign fails as follows.

2016-09-07 17:25:41,898 [AWT-EventQueue-0] ERROR DDLGenerator - Error while generating DDL for TMD01C_E$_SNP_CHK_TAB
java.lang.IllegalArgumentException: Illegal group reference
at java.util.regex.Matcher.appendReplacement(Matcher.java:857)
at java.util.regex.Matcher.replaceAll(Matcher.java:955)
at java.lang.String.replaceAll(String.java:2210)
at oracle.dbtools.crest.exports.ddl.oracle.SSBAutoIncrementColumnOracle.generateAutoIncrementObjectName(SSBAutoIncrementColumnOracle.java:282)
at oracle.dbtools.crest.exports.ddl.oracle.SSBAutoIncrementColumnOracle.generateSequenceName(SSBAutoIncrementColumnOracle.java:187)
at oracle.dbtools.crest.exports.ddl.oracle.SSBAutoIncrementColumnOracle.appendAutoIncrementSequenceAndTrigger(SSBAutoIncrementColumnOracle.java:131)
at oracle.dbtools.crest.exports.ddl.oracle.SSBAutoIncrementColumnOracle.appendAutoIncrementSequenceAndTrigger(SSBAutoIncrementColumnOracle.java:81)
at oracle.dbtools.crest.exports.ddl.oracle.SSBAutoIncrementColumnOracle.doAppend(SSBAutoIncrementColumnOracle.java:67)
at oracle.dbtools.crest.exports.ddl.SQLStatementBuilder.appendTo(SQLStatementBuilder.java:88)

 

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!


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