Duplicate objects when pulling Oracle schema

Tarby777

Member
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
 
In case it helps anyone... it turned out to be a problem with the "foreign owner" column in the _file and _sequence records. In the tables and sequences that were causing me problems, this column contained the unknown value, and should have contained the name of the user who owns the schema. Editing the DF (changing / adding FOREIGN-OWNER tokens as necessary) and creating a new schema holder DB from the DF fixed the problem.

HTH
Tarby
 
Back
Top