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" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]> ] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
