JoJo, sorry -- but truncating does "delete" the data because as far as Oracle is concerned, if you do a select count(*) from the table after a delete, you will get 0 rows returned.
Cursors do not have anything to do with the location of the end of a table, they are a programming construct Rachel --- JoJo Al-Zawawi <[EMAIL PROTECTED]> wrote: > 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 > === message truncated === __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).