ORA-00972: identifier is too long

Hi there,

ORA-00972 error occurred while creating DB.
Since I use Oracle 10g XE, build.xml needs to dummy sql file which is not included in build.xml.
So, I modified to copy two files as following.
		<copy file="${database.src.sql.dir}/${generatesql.database.type}/prepare-oracle-dummy-tables.sql" 
              todir="${database.instance.sql.dir}/${generatesql.database.type}"
              filtering="true" overwrite="true"/>
		<copy file="${database.src.sql.dir}/${generatesql.database.type}/standard-oracle-init.sql" 
              todir="${database.instance.sql.dir}/${generatesql.database.type}"
              filtering="true" overwrite="true"/>

And ORA-00972 error occurred while crating DB because the length of table name is too long (SCARAB_DEFAULT_NOTIFICATION_FILTER).

Has anyone faced the same problem?
Do I just rename the table with short length on every file that uses that table?

Please, advise me if you fix this.
Thanks a lot.

Below is output of creating DB.

=======================================================================================
=======================================================================================

    [mkdir] Created dir: C:\tasks\scarab_build_01\scarab-0.21\target\scarab\database\instance\sql\oracle
     [move] Moving 1 file to C:\tasks\scarab_build_01\scarab-0.21\target\scarab\database\instance\sql\oracle
     [move] Moving 1 file to C:\tasks\scarab_build_01\scarab-0.21\target\scarab\database\instance\sql\oracle
     [move] Moving 1 file to C:\tasks\scarab_build_01\scarab-0.21\target\scarab\database\instance\sql\oracle
     [copy] Copying 1 file to C:\tasks\scarab_build_01\scarab-0.21\target\scarab\database\instance\sql\oracle
     [copy] Copying 1 file to C:\tasks\scarab_build_01\scarab-0.21\target\scarab\database\instance\sql\oracle

create-db-schema:

create-empty-db:

load-default-data:
     [echo]
     [echo]             Calling initialization scripts:
     [echo]             dbtype   : [oracle]
     [echo]             url      : [=jdbc:oracle:thin:@***.***.***.***:1521:XE]
     [echo]             driver   : [oracle.jdbc.driver.OracleDriver]
     [echo]             userid   : [scarab]
     [echo]             password : [*******]
     [echo]
      [sql] Executing resource: C:\Sean\tasks\SRsystem\scarab_build_01\scarab-0.21\target\scarab\database\instance\sql\oracle\prepare-oracle-dummy-tables.sql
      [sql] Failed to execute:  create table SCARAB_DEFAULT_NOTIFICATION_FILTER (A char(1))
BUILD FAILED
C:\tasks\scarab_build_01\scarab-0.21\build\build.xml:441: The following error occurred while executing this line:
C:\tasks\scarab_build_01\scarab-0.21\target\scarab\WEB-INF\conf\build.xml:426: java.sql.SQLException: ORA-00972: identifier is too long

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1126)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311)
        at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2000)
        at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1970)
        at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:775)
        at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:745)
        at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:1055)
        at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:985)
        at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:653)
        at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
        at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
        at org.apache.tools.ant.Task.perform(Task.java:348)
        at org.apache.tools.ant.Target.execute(Target.java:390)
        at org.apache.tools.ant.Target.performTasks(Target.java:411)
        at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1397)
        at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
        at org.apache.tools.ant.Project.executeTargets(Project.java:1249)
        at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)
        at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
        at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
        at org.apache.tools.ant.Task.perform(Task.java:348)
        at org.apache.tools.ant.Target.execute(Target.java:390)
        at org.apache.tools.ant.Target.performTasks(Target.java:411)
        at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1397)
        at org.apache.tools.ant.Project.executeTarget(Project.java:1366)
        at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
        at org.apache.tools.ant.Project.executeTargets(Project.java:1249)
        at org.apache.tools.ant.Main.runBuild(Main.java:801)
        at org.apache.tools.ant.Main.startAnt(Main.java:218)
        at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
        at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)

=======================================================================================
=======================================================================================

------------------------------------------------------
http://scarab.tigris.org/ds/viewMessage.do?dsForumId=458&dsMessageId=2632366

To unsubscribe from this discussion, e-mail: [[email protected]].