ORA-31600: invalid input value TABLE_PARTITION for parameter OBJECT_TYPE in function GET_DDL

[GoogleCodeExporter]

Participationed table support missing?

What do you see instead?

Encountered an error executing the step
org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; 
uncategorized SQLException for SQL []; SQL state [99999]; error code [31600]; 
ORA-31600: invalid input value TABLE_PARTITION for parameter OBJECT_TYPE in 
function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 3025
ORA-06512: at "SYS.DBMS_METADATA", line 3076
ORA-06512: at "SYS.DBMS_METADATA", line 4787
ORA-06512: at line 1
; nested exception is java.sql.SQLException: ORA-31600: invalid input value 
TABLE_PARTITION for parameter OBJECT_TYPE in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 3025
ORA-06512: at "SYS.DBMS_METADATA", line 3076
ORA-06512: at "SYS.DBMS_METADATA", line 4787
ORA-06512: at line 1

What version of the product are you using? On what operating system?

$ java -jar scheme2ddl.jar -version
scheme2ddl version 2.0.1
$ java -version
java version "1.7.0_09"
Java(TM) SE Runtime Environment (build 1.7.0_09-b05)
Java HotSpot(TM) 64-Bit Server VM (build 23.5-b02, mixed mode)

Original issue reported on code.google.com by markd...@gmail.com on 12 Dec 2012 at 2:54

[GoogleCodeExporter]

Quick workaround: Exclude  TABLE_PARTITION object types from getting DDL.
run 
java -jar scheme2ddl.jar --config <path_to_config>
In config file add such entry:
    <util:map id="excludes">
       ...
        <entry key="TABLE_PARTITION">
            <set>
                <value>*</value>
            </set>
        </entry>
      ...
   </util:map>

I'll investigate this issue in detail later.

Original comment by resh...@gmail.com on 12 Dec 2012 at 3:45

• Changed state: Accepted

[GoogleCodeExporter]

Thanks. Didn't work at first, but I finally figured out that it should be 
"TABLE PARTITION". (With space, not underscore).

Original comment by markd...@gmail.com on 12 Dec 2012 at 4:47

[GoogleCodeExporter]

Ok, thanks for your feedback too.

Original comment by resh...@gmail.com on 12 Dec 2012 at 4:51

[GoogleCodeExporter]

I am running oracle standard edition which does not support partition.It might 
be the problem.

Original comment by pc8...@gmail.com on 22 Mar 2013 at 2:42

[GoogleCodeExporter]

fixed in release 2.1

Original comment by resh...@gmail.com on 30 Apr 2013 at 10:04

• Changed state: Fixed

[GoogleCodeExporter]

Original comment by resh...@gmail.com on 30 Apr 2013 at 10:20

• Changed state: Done