> [EMAIL PROTECTED] wrote: >> Thats good enough for me, thats exactly what I want. > > In that case, why use partitions at all? They are simple independent > tables.
For two reasons, - the data logically belongs together. - because its more practical to create tables as childs of a parent table than as independent tables. - changes to the table is applied to all partitions, and prohibits tables with different dd. - performing the create operation does not require the source code to contain the ddl of the parent table. regards thomas ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
