RE: tablespace resize Q

From: Siva_Chintalapati <Siva_Chintalapati_at_satyam.com>
Date: Mon, 24 Jul 2000 17:54:44 +0530
Message-Id: <10568.112740@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF56A.21B8BAE0
Content-Type: text/plain

Hi,
We have done it on Production database.We did not face any problem.U can go ahead..

Regards
Siva

> ----------
> From: Weerd de E.C. Kirsten[SMTP:Kirsten.deWeerd_at_Oranjewoud.nl]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, July 24, 2000 6:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: tablespace resize Q
>
> Hi Jack.
>
> I use resize fairly frequent and can't say I have come across problems so
> far ...
> (Oracle 7.2.3 on HP-UX 10.20)
>
> Greets,
>
> Kirsten
>
> > -----Original Message-----
> > From: Jack van Zanen [SMTP:nlzanen1_at_ey.nl]
> > Sent: Monday, July 24, 2000 9:55 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: tablespace resize Q
> >
> >
> >
> >
> > Hi All,
> >
> >
> > I am close to increasing one of our production tablespaces size. Can you
> > share
> > your opinions/experience on this.
> >
> > Did anybody experience any problems/corruption/crash while executing the
> > "alter
> > database datafile '<file>' resize xxxM;" command
> >
> > or is it on a live system preferable to add a datafile(not really my
> > favorite on
> > a reasonable small database! 6G total )?
> >
> > Personally I have not yet experienced any problems doing this (all on
> test
> > environment far less busy).
> >
> >
> > TIA
> >
> >
> >
> >
> > Jack
> >
> --
> Author: Weerd de E.C. Kirsten
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>

------_=_NextPart_001_01BFF56A.21B8BAE0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: tablespace resize Q</TITLE>
</HEAD>
<BODY>

Hi, We have done it on = Production database.We did not face any problem.U can go ahead..

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Siva</FONT>
</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> &nbsp; =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">Weerd de E.C. =

Kirsten[SMTP:Kirsten.deWeerd_at_Oranjewoud.nl] Reply To: =       ORACLE-L_at_fatcity.com
 Sent:   = Monday, July 24, 2000 6:04 = PM
 To: =     Multiple = recipients of list ORACLE-L
 Subject: =        RE: tablespace resize Q

Hi Jack.

I use resize fairly frequent and can't = say I have come across problems so

<BR><FONT SIZE=3D2 FACE=3D"Arial">far ...</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">(Oracle 7.2.3 on HP-UX 10.20)</FONT>
</P>

Greets,

Kirsten

> -----Original Message----- > From: Jack van Zanen = [SMTP:nlzanen1_at_ey.nl]
 > Sent: Monday, July 24, 2000 9:55 = AM

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; To:&nbsp;&nbsp; Multiple =
recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; =
Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tablespace resize Q</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Hi All,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

> > I am close to increasing one of = our production tablespaces size. Can you > share > your opinions/experience on = this.
 > > Did anybody experience any = problems/corruption/crash while executing the > "alter > database datafile '<file>' = resize xxxM;" command
 > > or is it on a live system = preferable to add a datafile(not really my > favorite on > a reasonable small database! 6G = total )?
 > > Personally I have not yet = experienced any problems doing this (all on test > environment far less = busy).

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; TIA</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Jack</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Weerd de E.C. Kirsten</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

Kirsten.deWeerd_at_Oranjewoud.nl

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 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 Received on Mon Jul 24 2000 - 07:24:44 CDT