- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Cannot remote ODI Datastore because the table has a PK referenced by other tables' FKs
I have a datastore for a dimension table that has a PK that is being referenced by other tables' FKs. There are datastores for those other tables, too.
I need to drop and recreate the dimension table's datastore. However, when I do that, I get:
ODI-10090: Object Datastore : STU.ORA_STU_TRG.Global.HANDSHAKE_EMPLOYER_D is referenced by:
No matter if I have the other tables' FKs disabled in the database. I still get the error.
What is the "Reference" that ODI is alluding to? Is there a way to disable it, so that this datastore can be dropped and recreated?
The only way I can make this work is go and remove the other tables' mappings and datastores before this datastore can be removed, but that's silly.