Quote:
Originally Posted by cmcintos  Hi we upgrade our test environment from 4.0 to 5.5 finally and found several saved queries are now broken. We want to remove them completely but can't through the UI due to getting null pointer exception.
I am wanting to SQL delete out the problem saved queries but am missing the core tables. Can anyone direct me at finding them?
I know about these.
SAVED_QUERY,
SAVED_QUERY_VALUES,
SAVED_QUERY_SORT |
I generally use a query to find out the constraints related to the main table. For eg. Saved Query is the main table then execute following query
select * from user_constraints where table_name like '%SAVED%'
then i will look into constraint_type 'R' means - refers another table's column.. So you can track these constraints and find out those tables (child tables) that are referring to it which makes your deletion simpler.. Even it gives you more knowledge about hw the tables are being linked apart from functional knowledge.