Yeah....as I replied to a kind gentleman who wrote me off-list, I think I will simply refrain from posting at all, since this place is a bit touchy. As I said, I'm totally a newbie (I just started my classes last week).
--JoJo -----Original Message----- Travis Sent: Tuesday, January 29, 2002 1:28 PM To: Multiple recipients of list ORACLE-L prepare for the flood.... > -----Original Message----- > From: JoJo Al-Zawawi [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 29, 2002 3:16 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: RTFM questions (formally RE: PL/SQL) > > > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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).