Re: Question about "alter" command.

From: Stephen Bell <stephen.bell_at_cgi.ca>
Date: Mon, 13 Aug 2001 08:21:28 -0400
Message-ID: <tBPd7.9101$KG2.813433@news20.bellglobal.com>

Hi Jordan,

First off, thanks to Howard for summarizing this issue so well.... All I would add is that this is one of those areas that may qualify as one of Howard's "exceptions" in
that it is perfectly natural to assume that the tablespace size can be altered via "alter tablespace"...in
my opinion, this is just one of those situations where the standard pattern doesn't quite apply.

As you've correctly ascertained, your options are to increase the size of existing datafile(s) in the tablespace or add a datafile to the tablespace...in either event, the tablespace size is a product of its datafiles.

Hth,
Steve

"Jordan" <mj_at_nba.com> wrote in message
news:9l6dcd$56s2_at_imsp212.netvigator.com...
> I always confuse when to use the alter xxx command. e.g. alter database,
> alter system, alter tablespace .....
> e.g. I want to resize the tablespace size, I will think 'alter tablespace
> .... resize 10M'. However, the actual result is 'alter database datafile
..
> 10M'. Can anyone there when I should use alter database, alter system,
> alter tablespace or others. THANKS.
>
>
Received on Mon Aug 13 2001 - 07:21:28 CDT