When using CLOB as Column Type there is an incomplete SYS_... Index in the Table Indexes

[GoogleCodeExporter]

1. Create a Column with Type CLOB  
2. Run scheme2ddl
3. There will be an incomplete SYS_.. Index in the Table Indexes. Which can't 
be excluded.

The SYS_.. Index should be omitted.

I'm using scheme2ddl 2.2.3

Original issue reported on code.google.com by [email protected] on 25 Jul 2013 at 10:56

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

This is behavior of DBMS_METADATA.GET_DEPENDENT_DDL("INDEX", , )

You can workaround for this issue with advanced config:
1 step) remove INDEX from set of dependencies for "TABLE" in "dependencies" bean
<util:map id="dependencies">
    <entry key="TABLE">
            <set>
                <value>COMMENT</value>
                <value>INDEX</value>   <!--remove this line -->
                <value>OBJECT_GRANT</value>
                <value>TRIGGER</value>
            </set>
   </entry>
2 step) replace exludes rule in "excludes" bean for INDEX
from 
   <entry key="INDEX"><set><value>*</value></set></entry>
to 
   <entry key="INDEX"><set><value>SYS_*</value></set></entry>

Original comment by [email protected] on 25 Jul 2013 at 12:16

• Changed state: Fixed

[GoogleCodeExporter]

This works, But.
Now you have the DDL saved in different files and folders.

Whats about an internal workaround for that Oracle issue?

...
select DBMS_METADATA.get_ddl('INDEX',I.INDEX_NAME)
  from USER_OBJECTS T
      ,USER_INDEXES I
 where T.OBJECT_NAME = 'TABLE_NAME'
   and T.OBJECT_TYPE = 'TABLE'
   and I.TABLE_NAME(+) = T.OBJECT_NAME
...

Original comment by [email protected] on 25 Jul 2013 at 1:11

[GoogleCodeExporter]

Ok, I reopen this issue with low priority.

Original comment by [email protected] on 25 Jul 2013 at 6:14

• Changed state: New
• Added labels: Priority-Low
• Removed labels: Priority-Medium