Skip to content

Instantly share code, notes, and snippets.

@dincosman

dincosman/required_mdrt_tables.sql

Last active March 6, 2022 19:29
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dincosman/4c4add24a8c3b66a135ac8b1052d6a68 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dincosman/4c4add24a8c3b66a135ac8b1052d6a68 to your computer and use it in GitHub Desktop.
Download ZIP
The query to detect required mdrt_# tables
Raw
required_mdrt_tables.sql
SQL> SELECT SM.*
FROM ALL_TABLES T, ALL_SDO_INDEX_METADATA SM
WHERE T.TABLE_NAME LIKE 'MDRT%' AND T.TABLE_NAME = SM.SDO_INDEX_TABLE
ORDER BY SDO_INDEX_OWNER;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment