Talk:Tablespace

From Wikipedia, the free encyclopedia

[edit] Tablespace types

Regarding the three types of tablespaces: are those three types common to all databases which support tablespaces, or is that just an Oracle thing?

No, it's an oracle thing. PostgreSQL and MySQL only have a single type of tablespace, for example. There are often different ways of handling the same problem though. MySQL's InnoDB engine, for instance, does have seperate files for logs (effectively an undo tablespace), but it these aren't called "undo tablespaces". Rather, a tablespace is more like a collection of data files and log files together. I'm not sure specifics on how other databases externalize these concepts. Tablespace is a pretty universal concept, but these three subtypes is more of an oracle invention. These also weren't available in older versions of oracle - they evolved over time. Warthog32 18:24, 8 August 2006 (UTC)