Can you send that scripts please.
Mala
>From: "Sandy Druar" <sdruar_at_eckerd.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Redo a Tablespace
>Date: Wed, 15 Nov 2000 09:31:19 -0800
>
>Can you please forward these scripts to me too.
>
>Thanks,
>Sandy Druar
>Oracle DBA
>sdruar_at_eckerd.com
>
>"Anandarao, KrishnamurthyX" wrote:
>
> > Laura, I would definitely be interested in it. Can you forward me
> > those scripts please.ThanksKrish
> >
> > -----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 = Simple Algorithm for Fragmentation Elimination
> >
> > I made a script which contain queries for the rules
> > referenced in the article. I'll send it to you if you want
> > it.
> >
> > Laura
> >
> > -----Original Message-----
> > From: Maser, Donna (SEA)
> > [mailto:DonnaMaser_at_chiroscience.com]
> > Sent: Tuesday, November 14, 2000 2:41 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Redo a Tablespace
> >
> > Laura,
> > What are the 'ofSAFE' rules that you refer to?
> > - Donna
> >
> > -----Original Message-----
> > Sent: Tuesday, November 14, 2000 5:06 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Thank you for responding to my question. Yes to #4 and #5.
> > An example of
> > this is creating a user REFERENCE to own all the reference
> > (static) tables
> > 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
> > easier if a user is contained in one tablespace because
> > there is not a
> > export option for tablespace.
> >
> > When I created the tablespaces that I have I didn't put a
> > whole lot of
> > thought into the size, extents, etc. It's been about a year
> > now since I
> > started this, and now I am finding articles which address
> > issues on tuning
> > and fragmentation. Needless to say I flunked about 7 of the
> > 12 rules of
> > SAFE. Now I want to correct earlier mistakes. It would
> > probably be easier
> > to just call the tablespace something else and cut out some
> > of the steps I
> > listed, but I like the naming convention I'm using and want
> > to use the same
> > names.
> >
> > 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'
> > world that classes just never seem to get too.
> >
> > Sorry for the book....Laura
> >
> > P.S. Thanks for the 'offline' suggestion...that would be
> > easier.
> >
> > <snip>
> >
> >
> > The information contained in this email is intended for the
> > personal and confidential use of the addressee only. It may
> > also be privileged information. If you are not the intended
> > recipient then you are hereby notified that you have
> > received
> > this document in error and that any review, distribution or
> > copying of this document is strictly prohibited. If you have
> >
> > received this communication in error, please notify
> > Celltech
> > Group immediately on:
> >
> > +44 (0)1753 534655, or email 'is_at_celltech.co.uk'
> >
> > Celltech Group plc
> > 216 Bath Road, Slough, SL1 4EN, Berkshire, UK
> >
> > Registered Office as above. Registered in England No.
> > 2159282
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Maser, Donna (SEA)
> > INET: DonnaMaser_at_chiroscience.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).
> >
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
Received on Wed Nov 15 2000 - 13:55:00 CST
