1) whats the recommended formulae to calculate which tablespace the relevant table or index should be created in for new tables which dont contain data?
2) for existing tables and indexes I thought I will look at current no of extents and size and order accordingly.


Three tablespaces will exist for creating tables and three will exist for indexes as per below

initial 128K next 1024K PCT Inc 0
initial 512K next 4096K PCT Inc 0
initial 5M next 10M PCT Inc 0

PCTFREE will be 10

NOTE Dictionary managed tablespaces will have to be used not LMT.

Please help