Re: RTFM questions (formally RE: PL/SQL)

'Truncate table' drops existing extents, and basically recreates table with MINEXTENTS specified on table creation. That's how it 'empties space'.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, January 29, 2002 3:16 PM

> I'm a complete newbie, so I may be off-base here, but I believe that
> truncating a table does not delete any data from the table. It moves the
> cursor up, thereby closing up the "empty space" where data has previously
> been deleted.
>
> --JoJo
>
>
> -----Original Message-----
> Sent: Tuesday, January 29, 2002 10:46 AM
> To: Multiple recipients of list ORACLE-L
>
>
> To our resident Oracle Expert who just 6 months (July 26 2001) ago posted
> the following e-mail
>
>
> If I remember rightly, deleting rows from the table does NOT free up
> tablespace. In order to do that you have to trunctate the table (although
> this of course deletes all data from the table)...I can't for the life of
me
> remember how you adjust the space the table is actually using after doing
a
> delete...(to everyone else) would an analyze work?
>
> Kev.
>
> "would and analyze work", leave it out kev(or thomas), my sides are
> splitting Im laughing that much"
> "Dude you really are a sage"
> I agree dude, you tell them beginners how u became such an expert in 6
> months and didn't come out with stupid ****** comments like above, and
dude,
> explain more about this defrag,space adjusting tool "the analyze command":
>
> Unfortunately I only got dragged into this because I just saw one of your
> rude replies and I was having a bad day and didn't like your attitude., I
> have no idea about the guy you were slagging off as I don't get time to
read
> all the posts, but it looks like 6 months ago you were no better than him,
> and nobody on the list, I recall, treated you with the contempt that you
> actually deserved.
>
> As somebody on the list said "opinions are like arseholes, everybody's got
> one and they all stink" (classic ,classic quote):
>
> Anyhow I rest my case Kev (or thomas):
>
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, January 29, 2002 8:12 PM
>
>
> > And your point caller??
> >
> > TIC ;o)
> >
> > -----Original Message-----
> > Sent: 29 January 2002 15:41
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > No offense to anybody, but I think this is rather arrogant. The list is
> for
> > anybody (unless the list owner decides it's just for experienced dba's).
I
> > am brand new to Oracle, having just started learning it this week. I
can
> > easily foresee having what some might consider stupid or RTFM questions,
> and
> > being possibly unable to find the answer or having problems deciphering
> the
> > manual. I myself am somewhat of a Word pro (and my vba code samples
page
> is
> > the #1 ranked site of its kind on most major search engines) and I help
> all
> > kinds of newbies out on a Word list of which I am a member, as do all
the
> > other members of the list. Everybody on that list is extremely gracious
> and
> > nobody complains -- and the people with questions get the help they
need,
> > with nobody sitting back going "boy are you stupid / lazy". I am hoping
> > that I can get the same kind of help here, when I am ready for it, that
I
> > and others give on other lists.
> >
> > --JoJo
> >
> >
> > -----Original Message-----
> > Sent: Monday, January 28, 2002 10:20 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > The problem is that if you always ask the group for help, you never
learn
> > where the information is within the manuals or other reference
> documentation
> > and the group also gets cluttered with trivia.
> >
> > I agree with you that the list is here to help people and I personally
do
> > not mind the odd naive question from a new DBA, but it is the "...can't
be
> > bothered to look up the manual.." attitude that is most frustrating.
When
> > you ask the format of a command (for example) to the list, you are
> > potentionally asking 1000's of people the same question who will all
have
> to
> > spend the time to filter these questions - we are all busy people and I
> > personally do not want to use my time in this way. I'm sure you can see
> > that this is a much more expensive option than asking the person next to
> > you.
> >
> >
> > Cheers,
> > Craig.
> >
> >
> >
> > -----Original Message-----
> > <mailto:rabbit_at_emirates.net.ae> ]
> > Sent: Tuesday, 29 January 2002 2:55 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Why do you bother being on this List: The list is here to help fellow
> > DBA'S. Have you never said to one of your collegues , what is the format
> of
> > this command, or how can I do that, when you simply cant be bothered to
> > look it up in the manual (either your busy or just down right lazy):
> > Sometimes this list is useful for just that. So why dont u lighten up
> dude.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > <http://www.orafaq.com>
> > --
> > Author:
> > INET: rabbit_at_emirates.net.ae
> >
> > 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: Thomas, Kevin
> > INET: Kevin.Thomas_at_calanais.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: Sam Roberts
> INET: rabbit_at_emirates.net.ae
>
> 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: JoJo Al-Zawawi
> INET: jojo_at_jojo-zawawi.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: Igor Neyman
  INET: ineyman_at_perceptron.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).