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

Last updated on OCTOBER 18, 2016

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

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