Re: Increase size of data files and rollback segments

I welcome David input always, especially when he is yanking the leg of someone who did not troubled himself to open the SQL manual and look at obvious commands like alter rollback segment and alter tablespace.

I liked his answer.

BTW, Please do not tell ANYONE on this list to shut up. It is bad behavior and, believe me, you need those guys the same as me.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, December 10, 2002 5:49 PM

> Jeremiah,
>
> I am seeking for help. If you are not willing to help then just SHUT your
> mouth. I don't think we welcome such people like you here.
>
>
> David
>
>
> -----Original Message-----
> Sent: Monday, December 09, 2002 5:39 AM
> To: Multiple recipients of list ORACLE-L
>
>
> On Mon, 9 Dec 2002, Nguyen, David M wrote:
>
> > How do I increase size of oracle data files and rollback segments and
Can
> I
> > do it when database is online?
>
> Unfortunately these sizes are fixed, and based on your level of
> license with Oracle Corp. If you need to increase the size of your
> datafiles or rollback segments, you must contact your Oracle sales
> representative and request additional power units.
>
> If you find that you run in a dynamic enough environment, you may wish
> to upgrade to a more sophisticated database system such as MS SQL
> Server or Filemaker Pro, both of which allow dynamic resizing.
>
> :-)
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeremiah Wilton
> INET: jwilton_at_speakeasy.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
> INET: david.m.nguyen_at_xo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).