| 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: Redo a Tablespace
OK, I've gotten any number of copies of this script. How about if =
everybody
checks their inbox for an already sent message from Laura which already =
has
the script attached? I already have all the copies that I need.
I hope nobody takes this wrong, but everybody asking for this and =
receiving
it via the list is simply wasting bandwidth.
Thanks,
John McKown
HealthAxis
> -----Original Message-----
> From: Larry Taylor [SMTP:ltaylor_at_iq.com]
> Sent: Wednesday, November 15, 2000 2:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Redo a Tablespace
>=20
>=20> =09
> -----Original Message-----
> From: Javier Morales [mailto:Javier_at_infojobs.net]
> Sent: Wednesday, November 15, 2000 10:26 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Redo a Tablespace
>=20 >=20> and Start Living: The Definitive Word on Fragmentation' by B. =
> -----Mensaje original-----
> De: Anandarao, KrishnamurthyX
> [mailto:krishnamurthyx.anandarao_at_intel.com]
> Enviado el: mi=E9rcoles 15 de noviembre de 2000 18:01
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: Redo a Tablespace
> =09
> =09
> Laura, I would definitely be interested in it. Can you
> forward me those scripts please.
> =20
> Thanks
> Krish
>=20
> -----Original Message-----
> From: Burton, Laura L.
> [mailto:BurtonL_at_prismplus.com]
> Sent: Wednesday, November 15, 2000 7:11 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Redo a Tablespace
> =09
> =09
>=20
> It comes from an article 'How to Stop Defragmenting
>=20> Elimination=20
> SAFE =3D Simple Algorithm for Fragmentation
>=20> referenced in the article. I'll send it to you if you want it.=20
> I made a script which contain queries for the rules
>=20> would be easier.=20
> Laura=20
>=20
> -----Original Message-----=20
> From: Maser, Donna (SEA) [
> <mailto:DonnaMaser_at_chiroscience.com>]=20
> Sent: Tuesday, November 14, 2000 2:41 PM=20
> To: Multiple recipients of list ORACLE-L=20
> Subject: RE: Redo a Tablespace=20
>=20 >=20
> Laura,=20
> What are the 'ofSAFE' rules that you refer to?=20
> - Donna=20
>=20
> -----Original Message-----=20
> Sent: Tuesday, November 14, 2000 5:06 AM=20
> To: Multiple recipients of list ORACLE-L=20
>=20 >=20 >=20
> Thank you for responding to my question. Yes to #4
> and #5. An example of=20
> this is creating a user REFERENCE to own all the
> reference (static) tables=20
> and have the tables located in one tablespace called
> REFERENCE_DATA (one for=20
> indexes as well). I read in a book awhile back
> about how recovery might be=20
> easier if a user is contained in one tablespace
> because there is not a=20
> export option for tablespace. =20
>=20
> When I created the tablespaces that I have I didn't
> put a whole lot of=20
> thought into the size, extents, etc. It's been
> about a year now since I=20
> started this, and now I am finding articles which
> address issues on tuning=20
> and fragmentation. Needless to say I flunked about
> 7 of the 12 rules of=20
> SAFE. Now I want to correct earlier mistakes. It
> would probably be easier=20
> to just call the tablespace something else and cut
> out some of the steps I=20
> listed, but I like the naming convention I'm using
> and want to use the same=20
> names.=20
>=20
> I really appreciate this list and the people like
> you who respond. Although=20
> sometimes we get a little 'testy', it is still a
> great window of the 'real'=20
> world that classes just never seem to get too.=20
>=20
> Sorry for the book....Laura =20
>=20
> P.S. Thanks for the 'offline' suggestion...that
>=20> access / Mailing Lists=20
> <snip>=20
>=20 >=20 >=20
> The information contained in this email is intended
> for the=20
> personal and confidential use of the addressee only.
> It may=20
> also be privileged information. If you are not the
> intended=20
> recipient then you are hereby notified that you have
> received=20
> this document in error and that any review,
> distribution or=20
> copying of this document is strictly prohibited. If
> you have=20
> received this communication in error, please notify
> Celltech=20
> Group immediately on:=20
>=20
> +44 (0)1753 534655, or email 'is_at_celltech.co.uk'=20
>=20
> Celltech Group plc=20
> 216 Bath Road, Slough, SL1 4EN, Berkshire, UK=20
>=20
> Registered Office as above. Registered in England
> No. 2159282=20
> --=20
> Please see the official ORACLE-L FAQ:
> <http://www.orafaq.com>=20
> --=20
> Author: Maser, Donna (SEA)=20
> INET: DonnaMaser_at_chiroscience.com=20
>=20
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051=20
> San Diego, California -- Public Internet
 |
 |