Hi all,
This is my first post to Progress Talk... now that the PEG has started charging!
When I pull an Oracle schema into a schema holder using the Dataserver "update/add table definitions" utility, I find that it creates duplicates of some of the objects in the schema. I might get a "customer_seq-1" sequence in addition to "customer_seq", a "customer-1" table in addition to "customer", a "cust-num-1" column in addition to "cust-num" and so on. I'm just using "customer" as an example... this problem affects maybe 20 of my 400+ tables. BTW, I only pull from a single schema, so it's not as if my Oracle DB has multiple schemas (each with the same table name) and is retrieving all of them...
Does anyone else have this problem? Is there a workaround? At the moment, I have to dump and edit the DF, then create a new schema holder...
TIA
Tarby
This is my first post to Progress Talk... now that the PEG has started charging!
When I pull an Oracle schema into a schema holder using the Dataserver "update/add table definitions" utility, I find that it creates duplicates of some of the objects in the schema. I might get a "customer_seq-1" sequence in addition to "customer_seq", a "customer-1" table in addition to "customer", a "cust-num-1" column in addition to "cust-num" and so on. I'm just using "customer" as an example... this problem affects maybe 20 of my 400+ tables. BTW, I only pull from a single schema, so it's not as if my Oracle DB has multiple schemas (each with the same table name) and is retrieving all of them...
Does anyone else have this problem? Is there a workaround? At the moment, I have to dump and edit the DF, then create a new schema holder...
TIA
Tarby