Re: Question about "alter" command.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 12 Aug 2001 22:11:42 +0200
Message-ID: <997647105.4247.0.pluto.d4ee154e@news.demon.nl>

"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.
>
>

That is why Oracle comes with documentation, in this case the Sql reference manual.
Please don't expect anyone is going to abstract it.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Sun Aug 12 2001 - 15:11:42 CDT