| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ?: ?Problem with resize
I had a problem with resize of large datafiles under Oracle 7, I hit =
two
major bugs.
(see Information bulletins 112011.1 and 1012442.6)
The fix was to create the tablespace using the large size I wanted, and =
then
import. (see 1012442.6)
The import utility still tried to re-create the tablespace with =
ridiculous
sizing (18,446,744,072,560,312,320 bytes) , but the data was imported.
All they say in 1012442.6 is "This is a known bug (226644), that has =
not yet
been fixed. It should only occur for larger datafiles."
1012442.6 says that the large file problems affect many releases, right =
up
to 8.1.6.1. They state that it will probably be fixed in 8.1.7.
I don't know if it has been fixed in the later patches for 8i Release = 2.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-----Original Message----- From: Arvind Aggarwal [SMTP:oradba9_at_yahoo.com] Sent: Tuesday, January 16, 2001 1:31 PM To: Multiple recipients of list ORACLE-L Subject: 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:Received on Wed Jan 17 2001 - 06:22:19 CST
> Please Tell me I will go for resizeing a datafile
> or adding a new datafile.
> Which is better.
>=20
> Saroj.
>=20
> -----OE=B3'=CCf=81fbfZ=81[fW-----
> =8D=B7=8Fo=90l: Trassens, Christian
> [mailto:CTrassens_at_uni2.es]
> '-=90M"=FAZz: Tuesday, January 16, 2001 PM 05:31
> ^=B6=90=E6: Multiple recipients of list ORACLE-L
> OE=8F-=BC: RE: ?Problem with resize
>=20
> Hi,
>=20
> create_bytes and bytes will differ if you resize a
> datafile.=20
>=20
> 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.
>=20
> Regards.
>=20
> > -----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
> >=20
> > Hello all,
> >=20
> > I found one Oracle Bug while resizing a datafile.
> > Please suggest me what to do.
> >=20
> > After resizeing a datafile please see the column
> bytes size and
> > create_bytes
> > size in v$datafile.
> >=20
> > In my opinion both are must be same but it shows
> different.
> >=20
> > Help .
> > Saroj.
> >=20
> > --=20
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --=20
> > Author: Dash, Saroj (CAP,CEF)
> > INET: Saroj.Dash_at_gecapital.com
> >=20
> > Fat City Network Services -- (858) 538-5051=20
> 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).
> --=20
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --=20
> Author: Trassens, Christian
> INET: CTrassens_at_uni2.es
>=20
> 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
>=20
> 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).
__________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail.=20 http://personal.mail.yahoo.com/ --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 Author: Arvind Aggarwal INET: oradba9_at_yahoo.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
 |
 |