Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Purpose of MD$ tables

480197Jan 3 2006 — edited Jan 3 2006

I am running Oracle 9.2.0.7 with the spatial option installed. In my MDSYS schema I have the following MD$ tables: MD$COL, MD$DICTVER, MD$DIM, MD$EXC, MD$LER, MD$PTAB, MD$PTS, MD$RELATE, MD$TAB.

We are new to Oracle Spatial, and have created a few tables which have spatial data. What are the MD$ tables used for? My guess is that they are dictionary tables for spatial similar to v$ tables, but there is no data in these tables except for the MD$RELATE and the MD$DICTVER.

I looked in the installation scripts for spatial and only find reference to the MD$RELATE table.

Basically, I am wondering if these other MD$ tables are from an older version of Oracle spatial and perhaps are not needed any more.

Thanks in advance for you time.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 31 2006

Added on Jan 3 2006

#database-key-features, #spatial

1 comment

921 views