Re: ?: ?Problem with resize

Saroj,

This is not a bug.

Create_bytes referes to the size when initially created the datafile. It never changes even when u resize the datafile. On the other hand bytes refers to the existing size of the datafile. Whenever u resize the datafile only bytes column of v$datafile changes.

Arvind

• "Dash, Saroj (CAP,CEF)" <Saroj.Dash_at_gecapital.com> wrote:
  > Please Tell me I will go for resizeing a datafile
  > or adding a new datafile.
  > Which is better.
  >
  > Saroj.
  >
  > -----OE�'�f�fbfZ�[fW-----
  > ���o�l: Trassens, Christian
  > [mailto:CTrassens_at_uni2.es]
  > '-�M"�Zz: Tuesday, January 16, 2001 PM 05:31
  > ^���: Multiple recipients of list ORACLE-L
  > OE�-�: RE: ?Problem with resize
  >
  > Hi,
  >
  > create_bytes and bytes will differ if you resize a
  > datafile.
  >
  > There are bugs. I don't know which you found. I had
  > one in early version of
  > 7.3 on NT and another one resizing RBS on AIX in
  > 7.3.4.....and so on (
  > generally in 7.3 ). However, if you refer to the
  > difference of those fields
  > as a bug, you are wrong.
  >
  > Regards.
  >
  > > -----Mensaje original-----
  > > De: Dash, Saroj (CAP,CEF)
  > [SMTP:Saroj.Dash_at_gecapital.com]
  > > Enviado el: martes 16 de enero de 2001 7:40
  > > Para: Multiple recipients of list ORACLE-L
  > > Asunto: ?Problem with resize
  > >
  > > Hello all,
  > >
  > > I found one Oracle Bug while resizing a datafile.
  > > Please suggest me what to do.
  > >
  > > After resizeing a datafile please see the column
  > bytes size and
  > > create_bytes
  > > size in v$datafile.
  > >
  > > In my opinion both are must be same but it shows
  > different.
  > >
  > > Help .
  > > Saroj.
  > >
  > > --
  > > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > > --
  > > Author: Dash, Saroj (CAP,CEF)
  > > INET: Saroj.Dash_at_gecapital.com
  > >
  > > 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).
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Trassens, Christian
  > INET: CTrassens_at_uni2.es
  >
  > 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).
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Dash, Saroj (CAP,CEF)
  > INET: Saroj.Dash_at_gecapital.com
  >
  > 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).
  

  ---