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!

Spatial Table Design

449863Aug 12 2005 — edited Aug 20 2005

In mvdemo(Demo tables from oracle) we have tables STATES, COUNTIES, INTERSTATES and CITIES. So can I say that u should have a separate table for each Feature(Layer).
Suppose I have two Features CITIES and TOWNS both of them have the same non spatial fields. Here should I create two separate tables or a single table where I can put both the CITIES and TOWNS data.

Is there any advantage of putting similiar kind of data in two separate tables just because they are of different layers.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2005

Added on Aug 12 2005

#database-key-features, #spatial

8 comments

599 views