Re: What is a TABLESPACE?

From: Doug Welch <doug.welch_at_home.com>
Date: Sat, 24 Mar 2001 20:10:55 GMT
Message-ID: <jb7v6.111319$x27.5637346@news1.rdc2.on.home.com>

A tablespace is an database object that binds the logical (tables) to the physical (disk drives or at least what the target operating system exposes as disk abtractions). There are lots of options and best practices for defining tablespaces that vary from vendor to vendor and application to application. Some DBMS vendors don't even have tablespaces!

If you are just learning and aren't going to be creating a database with specific performance goals you can choose either value. I believe if you choose "none" your table will be created in the default tablespace (which is usually USERSPACE1).

"Wyvette Banks" <gwbanks_at_att.net> wrote in message news:3ABC3106.59A2_at_att.net...
> Hi,
>
> I am a novice in the Database world. What is a TABLESPACE, and when do I
> use it?
>
> I was creating a Table in DB2 and it gave me two default choices for a
> TABLESPACE name:
> 1. None
> 2. USERSPACE1
> What is happening if I choose None or if I choose USERSPACE1? I noticed
> this in Oracle as well, so image this is a DBMS thing.
>
> Gil
Received on Sat Mar 24 2001 - 14:10:55 CST