A table space parameter will be added to DDL commands which create physical database objects (CREATE DATABASE/INDEX/TABLE/SEQUENCE) and to CREATE SCHEMA. The associated routines, as well as the corresponding DROP commands will need to be updated. Adding the ability to ALTER <object> TABLESPACE <name> seems a little painful. Would people use it? Comments?
How about allowing the specification on schemas and databases of different default tablespaces for TEMP, TABLE and INDEX?? Is there any point to that?
Chris
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])