Re: what is the utility of the tablespace (newbie)

We have used the tablespace to separate all of 1 application's tables and indexes into separate files from other applications.

I think it is pretty common for applications to want (or say they need) their own tablespace for their application. This is not necessarily needed, but I like doing this unless the application is small (like less than 200Meg).

Before using the feature Locally Managed Tablespaces (LMT), I could see separating applications into separate tablespaces because they didn't all use a consistent segment size and ended up with fragmented tablespaces. But, with LMT this should not be an issue any more.

Note: With all of an application's data in 1 or 2 tablespaces ( although we haven't yet had a need to) you could easily move/copy an entire application from 1 server to another server using transportable tablespace feature.

-- 
"dominant" <member32241_at_dbforums.com> wrote in message
news:3548418.1067683782_at_dbforums.com...


>

> I would like someone to explain to me the utility of the tablespaces in

> a database.

>

>

>

> Is the tablespace equivalent to MyIsam (in Mysql)

>

>

> --

> Posted via http://dbforums.com