ipients of list
ORACLE-LSubject: RE: RTFM questions (formally RE:
PL/SQL)
JoJo, i'm also not a HiFi DBA like those few, and my purpose of being in the
list is to gain more knowledge.What i feel is that nobody has the right to
be arrogant, just bcoz the question is below their dignity to answer.I
Rachel and others,Well thats what i mentioned in my post, that he shud do some RTFM. I being a new joiner to the list was not aware that u guys had already advised him that.in that case, i'll say the blame directly falls on him rather than u guys.Sorry, sometimes little knowledge can be a harmful t
Naveen,
I don't think anyone here has said it was beneath their dignity to
answer. And the occasional question posted without having first tried
to find it in the manuals here is usually answered, and no one is
abused.
This is a particular case -- where the poster was bombarding the list
with qu
JoJo, i'm also not a HiFi DBA like those few, and my purpose of being in the list is to gain more knowledge.What i feel is that nobody has the right to be arrogant, just bcoz the question is below their dignity to answer.It wastes their time but if they only want complex questions they shud form th
Title: RTFM questions (formally RE: PL/SQL)
I
simply have rules in my MS Outlook that simply delete all messages posted by
certain individuals (we all know our usual suspects) and answeres to these
messages.
Alex
Hillman
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAI
ry 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, t
le 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)
>
>
>
]
> -Original Message-
> From: JoJo Al-Zawawi [SMTP:[EMAIL PROTECTED]]
> Sent: Tue, January 29, 2002 11:46 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RTFM questions (formally RE: PL/SQL)
>
> Yeahas I replied to a kind gentleman who wrote me off-l
Title: RE: RTFM questions (formally RE: PL/SQL)
Kevin,
I am afraid your post shows a distinct lack of ambition. :-)
No flames please
John
-Original Message-
From: Thomas, Kevin [mailto:[EMAIL PROTECTED]]
Sent: 30 January 2002 08:50
To: Multiple recipients of list ORACLE-L
Subject
JoJo,
Don't let this little episode put you off the list my friend.
I have seen you post to the list on a couple of occasions and they have been
valid questions. Keep reading, keep learning - stay subscribed.
Lee
-Original Message-
Sent: 29 January 2002 22:29
To: Multiple recipients o
Don't stop posting. I'm not a DBA either. Don't have any intention of being
one. I'm an Oracle duhveloper (as people sometimes point out..LOL). I read
this list to get a better understanding of how databases 'hang together'. I
never profess to being an expert in DBA related stuff...I'm far, far fr
RACLE-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
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
Rache
JoJo,
you said
"being possibly unable to find the answer or having problems
deciphering the manual." You try to find it first on your own.
I will answer beginner questions all day. Most of my presentations are
on beginner stuff. But you have to at least make an effort to find it
yourself. You
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 t
Thank you all for your kind replies, and I now definitely know the correct
answer to this.
Please let me reiterate that I am *not* yet an Oracle dba. I've only been
to one class so far, for crying out loud! Obviously it would be better for
me to just not post for a while, in any event.
No need
002 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
I strongly suggest you not experiment with this on your production database.
--Walt
-Original Message-
Sent: Tuesday, January 29, 2002 1:16 PM
To: Multiple recipients of list ORACLE-L
I'm a complete newbie, so I may be off-base here, but I believe that
truncating a table does not delet
And the funny(?) part is you can not rollback to recover it.
Just create, populate and truncate a test table and confirm (after reading
docs).
- Kirti
-Original Message-
Sent: Tuesday, January 29, 2002 3:05 PM
To: Multiple recipients of list ORACLE-L
Yup, you need to read up on this
> bothered to look up the manual.." attitude that is most frustra
ting.
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
'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
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, J
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
supe
Now, will someone tell me, if he is kidding, or is that a genuine serious
question ;-)
Raj
JoJo Al-Zawawi <[EMAIL PROTECTED]>@fatcity.com on 01/29/2002 03:16:07 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTEC
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
Ok folks, it's getting out of hand now.
Take it to the off topic list.
Jared
On Tuesday 29 January 2002 10:45, Sam Roberts wrote:
> 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 NO
Yup, you need to read up on this one.
Truncating a table will indeed delete data.
Jared
On Tuesday 29 January 2002 12:16, JoJo Al-Zawawi 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
> c
Hi JoJo,
This is incorrect. A truncate removes all data from the table and moves
the High Water Mark to the beginning of the table. Some internal's guru
might be able to tell you that the data is still there, but you can't get
to it, so it doesn't really matter. BTW , you can't issue a roll
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, 200
Wow, if you put *that* much work into helping the DBA poor/oppressed,
you'd be the Mother Theresa of the list.
I have to say I've gotten FAR MORE out of Kevin Thomas' posts than
I'm likely to ever see out of your private little sniping corner of
the Arab Emirates. But I'll keep an open mind,
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
his rant is directed at a list
abuser...
Tim
-Original Message-From: Sunrise DBA
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 29, 2002 11:36
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
RTFM questions (formally RE: PL/SQL)
Often, it isn't all that easy to
- Original Message -
From:
JoJo
Al-Zawawi
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, January 29, 2002 7:40
AM
Subject: RE: RTFM questions (formally
RE: PL/SQL)
No offense to
anybody, but I think this is rather a
I guess this is still "on topic" eh?
LoL.
-Original Message-
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 (unl
son).
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
JoJo
Al-Zawawi
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, January 29, 2002 10:40
AM
Subject: RE: RTFM questions (formally RE:
PL/SQL)
No offense to
anybody, but I think th
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
15:41To: Multiple recipients of list ORACLE-LSubject:
RE: RTFM questions (formally RE: PL/SQL)
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, h
Seriously though...
You would of course get as much help as the next person here and I don't
think it's out of place for me to say that newbies are always welcome! But
it starts to get ridiculous when a poster continually posts questions that
can be found on websites similar to your own without
m
-Original Message-From: JoJo Al-Zawawi
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 29, 2002 10:41
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
RTFM questions (formally RE: PL/SQL)
No offense to
anybody, but I think this is rather arrogant. The list is fo
chcox
- Original Message -
From:
JoJo
Al-Zawawi
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, January 29, 2002 7:40
AM
Subject: RE: RTFM questions (formally RE:
PL/SQL)
No offense to
anybody, but I think this is rather arrogant. The list is f
Title: RTFM questions (formally RE: PL/SQL)
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
Amen!
-Original Message-
Sent: 29 January 2002 06:20
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 tr
41 matches
Mail list logo