Re: Physical File Layout / Tablespace control

From: AcCeSsDeNiEd <dillon_at_rm_accessdenied.darktech.org>
Date: Tue, 17 Dec 2002 10:48:20 +0800
Message-ID: <143tvukll1epv1mm61m9aaifc7mg6ga4ap@4ax.com>

On Mon, 16 Dec 2002 18:22:07 -0800, DA Morgan <damorgan_at_exesolutions.com> wrote:

>A tablespace can automatically grow but it can not automatically add another datafile.
>
>Your question reeks of lazyiness.

Bah! I'm not a god damn DBA.
I'm just an IT Exec. here and have my own duties. There's no DBA here and the company doesn't plan to hire one. I handle support, network admin, security, e-mail admin, development, vendor management and now DB management for 400+ people.

I don't think I'm being "lazy".
I'm just being more productive.

>The only way to handle something such as you have described is to
>create a tablespace large enough to handle the first year and then weekly or monthly monitor its
>progress.

Guess so.
So I just add a new datafile to the tablespace when I find record retrival/insert slow?

>And, in the future, please post to only a single usenet group. Thanks.

Sorry my news server's crapping up.
So I thought if it doesn't get posted to .misc then it get posted to the other one.

To e-mail me, remove "rm_" Received on Mon Dec 16 2002 - 20:48:20 CST