Ok, some of you may recall that a few months ago I completly banned off topic posts from this list. If it was not of a technical nature, and not related to Oracle you couldn't post it.
Please stop this thread now, so I don't have ban off topic *again*, and spend too much of my time monitoring this list. Thank You. Jared Still ( the list owner, for those of you that don't know it ) On Tuesday 29 January 2002 13:27, Sam Roberts wrote: > Im defending this - how did i get here ? > > nevertheless - the mighty Mohan Ross speaks - I do read your e-mails (never > for oracle help) just too see if u can ever make me laugh- Im not actually > into camp humour though. > > How ironic - I always imagined you as the type who dresses up as a mother > superior in your spare time: > > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, January 30, 2002 12:16 AM > > > 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: Jared Still 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).