Problem with "TEIID60013 Duplicate Table <MYTABLE>"
fandre Jun 27, 2016 4:03 PMHy guys,
Im having some trouble when I'm trying to import a VDB, look my .xml import file:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="GEDIG_RIO" version="1"> <description></description> <!-- Setting to use connector supplied metadata. Can be "true" or "cached". "true" will obtain metadata once for every launch of Teiid. "cached" will save a file containing the metadata into the deploy/<vdb name>/<vdb version/META-INF directory --> <property name="UseConnectorMetadata" value="true" /> <!-- Each model represents a access to one or more sources. The name of the model will be used as a top level schema name for all of the metadata imported from the connector. NOTE: Multiple model, with different import settings, can be bound to the same connector binding and will be treated as the same source at runtime. --> <model name="GEDIG_RIO"> <!-- Each source represents a translator and data source. There are pre-defined translators, or you can create one. ConnectionFactories or DataSources in JBoss AS they are typically defined using "xxx-ds.xml" files. --> <!-- Property to let DSDataserver know of what type is the VDB model so that it we can be grouped accordingly. --> <property name="importer.importKeys" value="true"/> <property name="importer.useFullSchemaName" value="false"/> <property name="importer.tableTypes" value="TABLE"/> <property name="importer.widenUnsignedTypes" value="false"/> <property name="importer.schemaPattern" value="%"/> <property name="importer.excludeTables" value="(?!ADM.*|APR.*|EEP.*|GDIGPAC.*|GEDIG_RIO.*|MAG.*|SINPBC.*|TBB.*|ADEPD1.*).*"/> <property name="supports-multi-source-bindings" value="false"/> <property name="multisource.columnName" value="TEIID_MULTI_DATA_SOURCE_COLUMN"/> <property name="multisource.addColumn" value="true"/> <source translator-name="delegate" connection-jndi-name="java:/BDPEPBR" name="BDPEPBR" /> <metadata type="NATIVE,DDL"><![CDATA[ .............My DDL HERE ........ ]]> </metadata> </model> <translator name="delegate" type="interceptor"> <property name="delegateName" value="oracle" /> </translator> </vdb>
I saw in my db has a duplicate tables for two different owners:
OWNER | TABLE | TABLE SPACE NAME |
RPREV | SQLN_EXPLAIN_PLAN | RPREV_DADOS |
ADEPD1 | SQLN_EXPLAIN_PLAN | USERS |
Im try to change my excludeTable including one of this owners, like this:
<property name="importer.excludeTables" value="(?!ADM.*|APR.*|EEP.*|GDIGPAC.*|GEDIG_RIO.*|MAG.*|SINPBC.*|TBB.*|ADEPD1.*).*"/>
But without success, can anyone may help me?
Thx in advance