We already have some TODO items about sorting out exactly how the defaulting behavior works here. In particular, what if anything is the difference between a child object inheriting a default tablespace TS, and explicitly saying "TABLESPACE TS" in its definition? If we attempt to reload this mess with a different default tablespace for the parent object, what happens to the child in each case?
Has anyone tested inheritance with tablespaces? ie. child in different tablespace to parent, select query that goes over both...?
Chris
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
