Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Redo a Tablespace

RE: Redo a Tablespace

From: Larry Taylor <ltaylor_at_iq.com>
Date: Wed, 15 Nov 2000 12:43:37 -0800
Message-Id: <10681.122177@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_01C04F44.BAF78D10


Content-Type: text/plain;


        charset="iso-8859-1"


Content-Transfer-Encoding: quoted-printable



Laura, can you send me the scripts a well.
=20


Thanks,


Larry



-----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




please, may you send them to me... I'm also interested in them...
=20


thanks!  ;-)

 ---------------------------------------=20


 Javier Morales  - javier_at_infojobs.net=20
 Administraci=F3n Bases de Datos Oracle - InfoJobs.net=20
 Tel. +34  902 10 60 90  Ext. 2067=20


 Fax. +34 (93) 580 56 60=20


 =20




-----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




Laura, I would definitely be interested in it.  Can you forward me =
those


scripts please.


=20


Thanks


Krish



-----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





It comes from an article 'How to Stop Defragmenting and Start Living: =
The


Definitive Word on Fragmentation' by B. Himatsingka and J. Loaiza from =
the


Oracle Corporation.



SAFE =3D Simple Algorithm for Fragmentation Elimination=20



I made a script which contain queries for the rules referenced in the
article.  I'll send it to you if you want it.=20



Laura=20



-----Original Message-----=20


From: Maser, Donna (SEA) [ mailto:DonnaMaser_at_chiroscience.com


<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




Laura,=20


  What are the 'ofSAFE' rules that you refer to?=20
- Donna=20



-----Original Message-----=20


Sent: Tuesday, November 14, 2000 5:06 AM=20
To: Multiple recipients of list ORACLE-L=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



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



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



I really appreciate this list and the people like you who respond.  =
Although



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



Sorry for the book....Laura    =20



P.S.  Thanks for the 'offline' suggestion...that would be easier.=20



<snip>=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



+44 (0)1753 534655, or email 'is_at_celltech.co.uk'=20



Celltech Group plc=20


216 Bath Road, Slough, SL1 4EN, Berkshire, UK=20



Registered Office as above. Registered in England No. 2159282=20
--=20


Please see the official ORACLE-L FAQ: http://www.orafaq.com


<http://www.orafaq.com> =20



--=20


Author: Maser, Donna  (SEA)=20


  INET: DonnaMaser_at_chiroscience.com=20


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051=20
San Diego, California        -- Public Internet access / Mailing Lists=20
--------------------------------------------------------------------=20


To REMOVE yourself from this mailing list, send an E-Mail message=20
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20
the message BODY, include a line containing: UNSUB ORACLE-L=20
(or the name of mailing list you want to be removed from).  You may=20
also send the HELP command for other information (like subscribing).=20




------_=_NextPart_001_01C04F44.BAF78D10


Content-Type: text/html;


        charset="iso-8859-1"


Content-Transfer-Encoding: quoted-printable



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD>

<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">


<TITLE>RE: Redo a Tablespace</TITLE>




<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR></HEAD>

<BODY>

<DIV><SPAN class=3D884014620-15112000><FONT face=3DArial =

color=3D#0000ff size=3D2>Laura,=20


can you send me the scripts a well.</FONT></SPAN></DIV>


<DIV><SPAN class=3D884014620-15112000><FONT face=3DArial =

color=3D#0000ff=20


size=3D2></FONT></SPAN>&nbsp;</DIV>


<DIV><SPAN class=3D884014620-15112000><FONT face=3DArial =

color=3D#0000ff=20


size=3D2>Thanks,</FONT></SPAN></DIV>


<DIV><SPAN class=3D884014620-15112000><FONT face=3DArial =

color=3D#0000ff=20


size=3D2>Larry</FONT></SPAN></DIV>


<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">

  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20


  size=3D2>-----Original Message-----<BR><B>From:</B> Javier Morales=20
  [mailto:Javier_at_infojobs.net]<BR><B>Sent:</B> Wednesday, November 15, =
2000=20


  10:26 AM<BR><B>To:</B> Multiple recipients of list =
ORACLE-L<BR><B>Subject:</B>=20


  RE: Redo a Tablespace<BR><BR></FONT></DIV>
  <DIV><FONT face=3DVerdana color=3D#0000ff size=3D2><SPAN=20
  class=3D054211818-15112000>please, may you send them to me... I'm =
also=20


  interested in them...</SPAN></FONT></DIV>
  <DIV><FONT face=3DVerdana color=3D#0000ff size=3D2><SPAN=20
  class=3D054211818-15112000></SPAN></FONT>&nbsp;</DIV>

  <DIV><FONT face=3DVerdana color=3D#0000ff size=3D2><SPAN=20
  class=3D054211818-15112000>thanks!&nbsp; ;-)</SPAN></FONT></DIV>
  <DIV><FONT face=3DVerdana color=3D#0000ff size=3D2><SPAN =


class=3D054211818-15112000>


  <P><FONT face=3DVerdana=20

  size=3D2>&nbsp;---------------------------------------</FONT> =




<BR><FONT=20



  face=3DVerdana size=3D2>&nbsp;Javier Morales&nbsp; - =
javier_at_infojobs.net</FONT>=20


  <BR><FONT face=3DVerdana size=3D2>&nbsp;Administraci=F3n Bases de =
Datos Oracle -=20


  InfoJobs.net</FONT> <BR><FONT face=3DVerdana size=3D2>&nbsp;Tel. =
+34&nbsp;</FONT>=20


  <FONT face=3DVerdana size=3D2>902 10 60 90</FONT><FONT face=3DVerdana =
size=3D2>&nbsp;=20


  Ext. 2067</FONT> <BR><FONT face=3DVerdana size=3D2>&nbsp;Fax. +34 =
(93) 580 56=20


  60</FONT> <BR><FONT face=3DVerdana size=3D2>&nbsp;</FONT>=20
  </P><BR></SPAN></FONT></DIV>


  <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
    <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20


    size=3D2>-----Mensaje original-----<BR><B>De:</B> Anandarao, =
KrishnamurthyX=20


    [mailto:krishnamurthyx.anandarao_at_intel.com]<BR><B>Enviado el:</B> =
mi=E9rcoles=20


    15 de noviembre de 2000 18:01<BR><B>Para:</B> Multiple recipients =
of list=20


    ORACLE-L<BR><B>Asunto:</B> RE: Redo a =
Tablespace<BR><BR></DIV></FONT>


    <DIV><FONT face=3D"MS Sans Serif" color=3D#0000ff><SPAN=20
    class=3D860375916-15112000>Laura, I would definitely be interested =
in=20


    it.&nbsp; Can you forward me those scripts =
please.</SPAN></FONT></DIV>


    <DIV><FONT face=3D"MS Sans Serif" color=3D#0000ff><SPAN=20
    class=3D860375916-15112000></SPAN></FONT>&nbsp;</DIV>
    <DIV><FONT face=3D"MS Sans Serif" color=3D#0000ff><SPAN=20
    class=3D860375916-15112000>Thanks</SPAN></FONT></DIV>
    <DIV><FONT face=3D"MS Sans Serif" color=3D#0000ff><SPAN=20
    class=3D860375916-15112000>Krish</SPAN></FONT></DIV>
    <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
      <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20


      size=3D2>-----Original Message-----<BR><B>From:</B> Burton, Laura =
L.=20


      [mailto:BurtonL_at_prismplus.com]<BR><B>Sent:</B> Wednesday, =
November 15,=20

      2000 7:11 AM<BR><B>To:</B> Multiple recipients of list=20
      ORACLE-L<BR><B>Subject:</B> RE: Redo a =
Tablespace<BR><BR></DIV></FONT>
      <P><FONT size=3D2>It comes from an article 'How to Stop =
Defragmenting and=20
      Start Living: The Definitive Word on Fragmentation' by B. =
Himatsingka and=20
      J. Loaiza from the Oracle Corporation.</FONT></P>
      <P><FONT size=3D2>SAFE =3D Simple Algorithm for Fragmentation=20
      Elimination</FONT> </P>
      <P><FONT size=3D2>I made a script which contain queries for the =
rules=20
      referenced in the article.&nbsp; I'll send it to you if you want=20
      it.</FONT> </P>
      <P><FONT size=3D2>Laura</FONT> </P>
      <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20
      Maser, Donna (SEA) [<A=20
      =




href=3D"mailto:DonnaMaser_at_chiroscience.com">mailto:DonnaMaser_at_chiroscien=
ce.com</A>]</FONT>=20


      <BR><FONT size=3D2>Sent: Tuesday, November 14, 2000 2:41 =
PM</FONT> <BR><FONT=20


      size=3D2>To: Multiple recipients of list ORACLE-L</FONT> =


<BR><FONT=20


      size=3D2>Subject: RE: Redo a Tablespace</FONT> </P><BR>
      <P><FONT size=3D2>Laura,</FONT> <BR><FONT size=3D2>&nbsp; What =
are the=20
      'ofSAFE' rules that you refer to?</FONT> <BR><FONT size=3D2>- =
Donna</FONT>=20
      </P>
      <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>Sent:=20
      Tuesday, November 14, 2000 5:06 AM</FONT> <BR><FONT size=3D2>To: =
Multiple=20
      recipients of list ORACLE-L</FONT> </P><BR><BR>
      <P><FONT size=3D2>Thank you for responding to my question.&nbsp; =
Yes to #4=20
      and #5.&nbsp; An example of</FONT> <BR><FONT size=3D2>this is =
creating a=20
      user REFERENCE to own all the reference (static) tables</FONT> =


<BR><FONT=20

      size=3D2>and have the tables located in one tablespace called =
REFERENCE_DATA=20
      (one for</FONT> <BR><FONT size=3D2>indexes as well).&nbsp; I read =
in a book=20
      awhile back about how recovery might be</FONT> <BR><FONT =
size=3D2>easier if=20
      a user is contained in one tablespace because there is not =
a</FONT>=20
      <BR><FONT size=3D2>export option for tablespace.&nbsp; =


</FONT></P>

      <P><FONT size=3D2>When I created the tablespaces that I have I =
didn't put a=20
      whole lot of</FONT> <BR><FONT size=3D2>thought into the size, =
extents,=20
      etc.&nbsp; It's been about a year now since I</FONT> <BR><FONT=20
      size=3D2>started this, and now I am finding articles which =
address issues on=20
      tuning</FONT> <BR><FONT size=3D2>and fragmentation.&nbsp; =
Needless to say I=20
      flunked about 7 of the 12 rules of</FONT> <BR><FONT =
size=3D2>SAFE.&nbsp; Now=20
      I want to correct earlier mistakes.&nbsp; It would probably be=20
      easier</FONT> <BR><FONT size=3D2>to just call the tablespace =
something else=20
      and cut out some of the steps I</FONT> <BR><FONT size=3D2>listed, =
but I like=20
      the naming convention I'm using and want to use the same</FONT> =


<BR><FONT=20

      size=3D2>names.</FONT> </P>
      <P><FONT size=3D2>I really appreciate this list and the people =
like you who=20
      respond.&nbsp; Although</FONT> <BR><FONT size=3D2>sometimes we =
get a little=20
      'testy', it is still a great window of the 'real'</FONT> =


<BR><FONT=20

      size=3D2>world that classes just never seem to get too.</FONT> =


</P>

      <P><FONT size=3D2>Sorry for the =
book....Laura&nbsp;&nbsp;&nbsp;&nbsp;=20
      </FONT></P>
      <P><FONT size=3D2>P.S.&nbsp; Thanks for the 'offline' =
suggestion...that=20
      would be easier. </FONT></P>
      <P><FONT size=3D2>&lt;snip&gt;</FONT> </P><BR><BR>
      <P><FONT size=3D2>The information contained in this email is =
intended for=20
      the</FONT> <BR><FONT size=3D2>personal and confidential use of =
the addressee=20
      only. It may</FONT> <BR><FONT size=3D2>also be privileged =
information. If=20
      you are not the intended</FONT> <BR><FONT size=3D2>recipient then =
you are=20
      hereby notified that you have received</FONT> <BR><FONT =
size=3D2>this=20
      document in error and that any review, distribution or</FONT> =


<BR><FONT=20

      size=3D2>copying of this document is strictly prohibited. If you =
have</FONT>=20
      <BR><FONT size=3D2>received&nbsp; this communication in error, =
please notify=20
      Celltech</FONT> <BR><FONT size=3D2>Group immediately on:</FONT> =


</P>

      <P><FONT size=3D2>+44 (0)1753 534655, or email =
'is_at_celltech.co.uk'</FONT>=20
      </P>
      <P><FONT size=3D2>Celltech Group plc</FONT> <BR><FONT =
size=3D2>216 Bath Road,=20
      Slough, SL1 4EN, Berkshire, UK</FONT> </P>
      <P><FONT size=3D2>Registered Office as above. Registered in =
England No.=20
      2159282</FONT> <BR><FONT size=3D2>-- </FONT><BR><FONT =
size=3D2>Please see the=20
      official ORACLE-L FAQ: <A target=3D_blank=20
      href=3D"http://www.orafaq.com">http://www.orafaq.com</A></FONT> =


<BR><FONT=20

      size=3D2>-- </FONT><BR><FONT size=3D2>Author: Maser, Donna&nbsp; =
(SEA)</FONT>=20
      <BR><FONT size=3D2>&nbsp; INET: =
DonnaMaser_at_chiroscience.com</FONT> </P>
      <P><FONT size=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- =
(858)=20
      538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT size=3D2>San =
Diego,=20
      California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public =
Internet=20
      access / Mailing Lists</FONT> <BR><FONT=20
      =
size=3D2>---------------------------------------------------------------=
-----</FONT>=20
      <BR><FONT size=3D2>To REMOVE yourself from this mailing list, =
send an E-Mail=20
      message</FONT> <BR><FONT size=3D2>to: ListGuru_at_fatcity.com (note =
EXACT=20
      spelling of 'ListGuru') and in</FONT> <BR><FONT size=3D2>the =
message BODY,=20
      include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT =


Received on Wed Nov 15 2000 - 14:43:37 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US