defaulting index tablespaces

Is there a way to default the tablespace names (Oracle) for indexes created for foreign keys, primary keys and alternate keys? It would be nice not to have to explicitly put in the tablespace names for these.

Interesting idea. We have similar capabilities on reorg/rebuild screens in toad - i.e. place certain object types and/or object sizes into different tablespaces with different settings. I wonder if that would be useful to define generally as well. Suggest place the idea on the toad world idea pond and seeing if you can get votes :slight_smile: