-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 paul rivers wrote: > Out of curiosity, which "big, expensive enterprise database" are > you spoiled by? Many that I support do not allow DDL within an > transaction, or if they allow it, there are many caveats and > rules.
Oracle Rdb. Built by DEC back in the early 1980s. It's had tablespaces (Storage Areas in Rdb parlance) since the late 80s. Tables (including the system catalog, which itself is a set of tables) all go in a Storage Area. If you don't specify one, it does in the default: RDB$SYSTEM. Creating a table is no more than inserting records into a few system tables, and allocating a few pages in the relevant Storage Area. Thus, rolling back most all DDL is built deep into the engine. http://www.oracle.com/technology/products/rdb/index.html - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEpVAZS9HxQb37XmcRArUOAKDFNtLVqr9BeYi7k6nhp/GnVI7M6QCfV7hJ wNUUCx2sGUmRklxtwu6hoUA= =CLgH -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match