| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 2nd Req URGENT help- needed (deletes)
Hello all
Iam tring to delete rows (million or more) from a table which currently has
around 45 million rows. The primary key is composed of (mem_id, join_date,
rt_code, rm_code, month). The values in the where clause are used from
another temp table which has only three column (mem_id, rt_code,
rm_code)similar to main table. As for join_date column value has to match >=
'given_date' (DD-MON-YY format ). I have created a cursor which read mem_id,
rt_code, rm_code from temp table & deletes from main table. Somehow its not
deleting any rows it just hangs & do nothing.
Would really appreciate any help.
Below is my cursor:
declare
cursor c_mem is
select mem_id, rt_code, rm_code
from temp_rc;
v_count number(10) :=0; v_deletes number(10) :=0; v_join_date mem_check.join_date%type :='01-JAN-01';begin
commit;
v_count := 0;
Thanks
salu
From: "aaaa wwwwww" <krisibm_at_lycos.com>
Date: Tue, 05 Dec 2000 19:25:35 -0800
Subject: RE: FreeOCP
Dear Seniors
Most of U felt bad it seems !
When we are generalising U shouldn't bring case by case example
Rao
-- On Tue, 05 Dec 2000 16:45:22 Rachel Carmichael wrote:Received on Tue Dec 05 2000 - 20:57:14 CST
>Jeff,
>
>Forgive me for jumping in on your rant, but I didn't see the original
>message.
>
>All -
>
>I do love this quote from the original email:
>
>"In my humble opinion, any OCP DBA with experience is lot better than a OCP
>DBA without experience or an experienced DBA without OCP."
>
>Really? Let's see.... I've been working as a DBA for 10+ years. I have met
>DBAs with OCP and experience, DBAs with experience and no OCP and DBAs with
>OCP and no experience.
>
>OCP does not in and of itself confer anything. You can pass the tests and
>never have used the products that the tests are about. I passed the 8.0 to
>8i upgrade without ever having worked with RMAN, partitioned tables,
>Advanced Queuing, local and global partitioned indexes etc -- I hadn't
>worked with 8i at ALL. What I *did* have were some hours spent at
>conferences listening to people present on these topics, and a really good
>ability to guess on standardized tests. I passed the 7.3 to 8.0 upgrade the
>same way.
>
>So I have OCP and it still does not mean that I have experience in these
>things.
>
>Jeff is right -- what counts is what the person knows, not how he/she
>learned it. The best explanation I have ever heard was from Michael Abbey
>who said "OCP will get you in the door, but it's up to you and your
>abilities to keep you there".
>
>All OCP does is give upper management a warm and fuzzy (and often incorrect)
>feeling about the abilities of the candidate.
>
>I don't look to see OCP on a resume before I interview someone. I don't
>reject the candidate if it is there, but it doesn't get you in the door to
>see me. Your resume does.
>
>End of *MY* rant -- thanks Jeff :)
>
>Rachel
>
>>From: Jeffery Stevenson <jeff_at_mpv.com>
>>Reply-To: ORACLE-L_at_fatcity.com
>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>Subject: RE: FreeOCP
>>Date: Tue, 05 Dec 2000 06:41:28 -0800
>>
>> Every person should be judged on their own individual merits...a veteran
>>DBA without OCP might have a box at home (or at work) where they take the
>>latest and greatest and play with all the new features to figure out how
>>they work and see what kind of advantages they bring. You could have a DBA
>>with lots of years of experience recorded and an OCP that has just been
>>soaking up money in a big contract for a consulting firm somewhere (and not
>>really doing much), but they've had lots of time to take the tests (until
>>they passed them all). There are too many variables in this world to judge
>>a situation without getting all of the details...keeping that in mind, I
>>cannot agree with your viewpoint that an OCP DBA with experience is going
>>to
>>be better than any other DBA--every situation is different. When
>>interviewing other DBAs, I might make initial judgements after reviewing
>>their resume, but (unless that resume is really, really bad) I won't rule
>>them out until I've had a chance to talk with them. The DBA market is a
>>tight market, why rule out any potentially good employee/help based on
>>years
>>of experience or a piece of paper? None of that can tell me exactly what
>>kind of heart, will, intelligence, common sense, personality, or learning
>>ability a person has. OCP and years of experience have definite merits
>>when
>>trying to get HR's attention and jacking prices in contracts, but if the
>>person behind all that isn't really that good...
>>
>> Sorry about the rant, but I just couldn't sit back and listen to all
>>this
>>without saying something...
>>
>>Jeffery Stevenson
>>Chief Databeast Tamer
>>Medical Present Value, Inc.
>>Austin, TX
>>
>>-----Original Message-----
>>Sent: Monday, December 04, 2000 4:51 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>Hi friends!
>> There is a lots of talk about Paper DBAs on this message board. With due
>>respect to all the veteran DBAs without OCP and new DBAs with OCP, I would
>>like to make few comments from my own personal experience (spanning 9
>>years+
>>in USA, Europe and India)
>>
>> I have come across lots of long time DBAs with no OCP, who frown on OCP
>>DBAs. Working closely with them, I noticed that these longs really count
>>the
>>hours to bill the clients. To my dismay, I came across 10+ years Oracle
>>DBAs
>>who had no clue about OPS, Partitioning, Snapshots, Stand by etc... They
>>have gained experience over the years only because the client could not
>>find
>>a better alternative.
>>
>> At the same time, in the interviews and at work, I come across lots of
>>new
>>OCP DBAs who can do the job, but need lots support and help from the other
>>DBAs. (It is sort of baby sitting).
>>
>> I was a DBA without OCP for long time and I had no problem in finding
>>jobs
>>without OCP. After I started preparing for OCP, I came to know of so many
>>things that I did not know before. In my humble opinion, any OCP DBA with
>>experience is lot better than a OCP DBA without experience or an
>>experienced
>>DBA without OCP.
>>
>> OCP helped me as a DBA to understand things that I did not know before.
>>It
>>took lots of time, confidence and enthusiasm to be a OCP DBA and change my
>>self in the process.
>>
>> Without OCP, I would have been a Pumpkin DBA, doing clueless things in a
>>random and unilateral way. Let's face it... OCP or No OCP is a matter of
>>choice. But it helps to be OCP than be left-out and looking at SOUR
>>GRAPES!!!
>>
>>Rama
>>OCP DBA with experience!
>>
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Rama Malladi
>> INET: rmalladi_at_inteliant.com
>>
>>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: ListGuru_at_fatcity.com (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: Jeffery Stevenson
>> INET: jeff_at_mpv.com
>>
>>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: ListGuru_at_fatcity.com (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).
>
>_____________________________________________________________________________________
>Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
>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: ListGuru_at_fatcity.com (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).
>
Great Gift Idea! FREE cell phone, internet ready at Lycos Marketplace http://www.inphonic.lycos.com/redirect.asp?referringpage=www.lycosd1 ------------------------------ From: Rahul <rahul_at_ratelindo.co.id> Date: Wed, 6 Dec 2000 10:24:31 +0700 Subject: RE: standby_archive_dest in standby DB Cyril, in recovery mode, the standby DB will not generate any logs of it's own, right ? only when i open the DB (read-write) the LOG_ARCHIVE_DEST will be used to archive the logs.. Why oracle recommends keeping the dirs same ?
> ----------
> From: Cyril Thankappan[SMTP:cyril_thank_at_rediffmail.com]
> Sent: Tuesday, December 05, 2000 2:03 PM
> To: rahul_at_ratelindo.co.id; ORACLE-L_at_fatcity.com
> Subject: Re: standby_archive_dest in standby DB
>
> Hi!
>
> Keep LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST
> different (preferably!)
>
> Regards
>
> ------------- Original Message --------------
> Rahul <rahul_at_ratelindo.co.id> wrote:
> To:Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> From:Rahul <rahul_at_ratelindo.co.id>
> Date:Mon, 04 Dec 2000 21:00:26 -0800
> Subject:standby_archive_dest in standby DB
>
> List, i'm about to create a standby DB in 8.1.5 (AIX),
> i have a doubt about the online redo logs of the standby,
>
> i have defined a remote destination in the primary DB
> log_archive_dest_2 = "service=STDBY OPTIONAL reopen=60"
>
> my questions are..
> 1) the logs from the primary will be copied to the dir specified
> by the param "standby_archive_dest" of the standby machine, correct ?
>
> 2) as the standby DB is also in ARCHIVELOG mode, what should be the
> "LOG_ARCHIVE_DEST" in the standby db ? same as the STANDBY_ARCHIVE_DEST" ?
>
>
> 3) my dir structure is different ( but the datafile name are same) on
> both
> machines,
> will i HAVE to use DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT ?
>
> TIA
>
> Rahul
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> 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: ListGuru_at_fatcity.com (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).
>
> _____________________________________________________
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.com
>
> Participate in crazy auctions at http://auctions.rediff.com/auctions/
>
>
>
------------------------------ From: "Eric D. Pierce" <PierceED_at_csus.edu> Date: Tue, 5 Dec 2000 19:56:54 -0800 Subject: RE: Off Topic -Happy Ramadhan sorry, this one is too good to pass up... http://www.muslim-canada.org/ch15hamid.html#time excerpt: "(f) If and when a Muslim lands on the moon, it will obviously not be possible to face the earthly Ka'bah in the service of prayer; nor to follow the sun's rising, passing the meridian and setting on Earth. What I humbly submit to the Muslim jurists [for those unfamiliar w/ Islam, in Islam, civil law is derived from religious law -sharia-, so "jurists" are experts in religious law first, and civil law second] is to construct a Ka'bah on the moon, at the point which would be face to face with the earthly Ka'bah, during equinox time, during a full moon night when our satellite is just above Mecca. That is, a bit North of the centre of the face of the moon that we see. I think that would lie in the region named 'Ocean of Tranquillity'. I am personally so much the more convinced of this solution, since the Ka'bah is not confined to the building of the ten odd yards high, but also what is above in the atmosphere up to the heaven. In a Hadith of al-Bukhari, the Holy Prophet is reported to have said that the Earthly Ka'bah is the antipode of the mosque of the angels underneath the Throne of God, (and so exactly so that if one were to throw a stone from there, it would fall on the top of the Ka'bah on earth). The great savant Ibn Kathir (Bidayah, 1, 163) reports that there is a particular Ka'bah on each of the seven heavens, each for the use of the inhabitants of that heaven. He adds (Tafsir, on surah 52, verse 4) the name of the Ka'bah on the seventh heaven is al-Bait al-Ma'mur, and that the earthly Ka'bah is at exactly the antipode of this heavenly Ka'bah. Our Ka'bah symbolizes as a window opening on the Divine Throne. If that is so, the permanent residents of the moon may even go there for pilgimage, since coming to earth for that purpose would be too much for them. This solution may help later to determine the point of the Qiblah on other stars and planets also, if man alights and settles there. It may by the way be pointed out that the days and nights on the moon are not of about 12 hours each, but of 14 days each. The timing differs on different celestial bodies. " -end- ------------------------------ From: =?iso-8859-1?q?Leng=20Kaing?= <lkaing_at_yahoo.com> Date: Tue, 5 Dec 2000 20:06:45 -0800 (PST) Subject: Re: IIOP configuration Guys, Found my problem - the configuration of MTS was incorrect. Had to take out the details about port numbers and it worked. Thanks anyhow, Leng. --- Leng Kaing <lkaing_at_yahoo.com> wrote: > Hello everyone,
>
> Sorry, but I'm not that up to date with Java and all
> that. Now our guy working on JDeveloper wants to
 |
 |