Hi,

> Is there any other reason why we should have the separate tablespaces??

I can't see any other than "put cats in the CATS tablespace and dogs in
DOGS"
So the PETS tbs would fit too.

IMHO, it is just old habits that are no more usefull with modern hardware.

Erwan


Oracle LazyDBA home page