RE: Opinions sought on possible TOAD replacement

Many thanks to everyone who responded! Looks like the outcome will be PL/SQL Developer licenses for our developers, while I get to keep my Toad Xpert / DBA module. Thanks again for the useful insights! Paul Vincent DBA University of Central England

ORA-14403 error detected during bulk updates

Hi there, We are running Oracle 9.0.2.3 on Sun Solaris 8. We have two fact tables - fct1 and fct2 and two PL SQL stored procedures - P1 and P2 fct1 - range partitioned on fct1_field1 and hash partitioned on fct1_field2 fct2 - range partitioned on fct2_field1 and

RE: Problem in dropping Materialized View

Hi, Did you rename the materialized view? If so you are probably hitting bug 1335477. Can you see the view name in user_mviews? I think you have to try and re-create the materialized view and then drop it. Really suggest you contact Oracle, unless someone on the list has the definitive fix.

RE: OT California

or should it be 'gropernator'... ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 7:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: OT California Check your Latin...that's Gubernator... |How, in the world,

RE: Where can I download 10g ?

Well, one may not have to die waiting for the download to complete this time... (to twist the reference) At an Oracele 'do' this week we were informed that 10g can be accommodated 'in toto' on 1 CD, unlike the 3 that were required for 9i. Due, we are told, to old redundant code being flushed out

RE: Problem in dropping Materialized View

Hitchman Thanks a ton, Yes it is a bug. With Warm Regards _ Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. # : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- Hitchman, Peter Sent: Friday, October 17, 2003 3:04 PM To: Multiple

RE: Where can I download 10g ?

Damn, I must have got the long version. My 9i came on 4 CDs !! -Original Message- Sent: 17 October 2003 10:59 To: Multiple recipients of list ORACLE-L Well, one may not have to die waiting for the download to complete this time... (to twist the reference) At an Oracele 'do' this week

Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

Hi Hemant, One word perfectly describes the Metalink article you highlighted: Crap ;) A nice example of how Oracle Corp is the greatest myth generator of them all !! It's all rather sad and embarressing isn't. Thanks for the headsup. Anyone in a position to get the note removed ? Cheers

RE: anyone have opinions on the future of the 'grid'?

Ah. now I understand. It involves Quantum Physics. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 16, 2003 6:04 PM To: Multiple recipients of list ORACLE-L For database type stuff, one must wonder how the data itself can be handled by CPU

RE: What is difference between SYSDATE and SYSDATE@! ??

Uh. I think that SYSDATE works, while [EMAIL PROTECTED] does not. Tom Mercadante Oracle Certified Professional -Original Message-From: Waleed Haggagy [mailto:[EMAIL PROTECTED]Sent: Thursday, October 16, 2003 12:20 PMTo: Multiple recipients of list ORACLE-LSubject: What

test

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: re Rebuilding Indexes in Oracle Apps -- Quoting an Apps

Doesn't reuse leaf rows?! The myth is perpetuated. Try running these scripts. In a nutshell, a table is created with about 20k rows, with an incrementing id. There is a non-unique index created on the id column. An analyze is done on the table then index_stats is populated with 'analyze

RE: anyone have opinions on the future of the 'grid'?

Had to chime in here. Carly Fiorina put this in simple terms. Grid implementations for most organizations is a 5-9 year plan and must be started and well thought out BEFORE you do the work. Larry is assuming that you just change over and all is well. Larry forgot to mention the capital

RE: anyone have opinions on the future of the 'grid'?

But that would require Oracle software to be installed on all the grids, don't you think? I'm really curious how they are going to pull this off. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 16, 2003 6:30 PM To: Multiple recipients of list

Re: Older IT Workers becoming a hot commodity

Experience? Are you certified in that? DENNIS WILLIAMS

RE: Passed Net8 OCP Exam

Now you can get the 9i OCP with just the 1 New Features exam! Congratulations... it's a satisfying feeling, isn't it? -Original Message- DENNIS WILLIAMS Sent: Thursday, October 16, 2003 2:24 PM To: Multiple recipients of list ORACLE-L I just passed the Net8 Administration OCP exam.

Re: test

Test failed. Jared-1555: list too old. Check the program on TV. Go Yanks! On 10/17/2003 02:40:38 PM, Jeffrey Beckstrom wrote: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: CLOB data

Thanks Mladen for your wonderful explanation. Nancy From: Mladen Gogala [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: CLOB data Date: Thu, 16 Oct 2003 20:24:25 -0800 But the main point is valid. The phenomenon observed by

anyone use oracle collaboration suite?

I saw a presentation on this. How difficult is this thing to install, configure, and administer? How good is it in practice? Its pretty cheap as far as Oracle products go. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED]

RE: 8.1.7 to 8.1.7.4 database migration - step 10 hangs

Thanks for all the help. I was under a bit of time pressure and it was a small database, so a just created a new database on the 8.1.7.4 (AIX 5.2) system and imported my tables. Something was seriously wrong with the upgrade script, because the java migration step ran all night and still had not

RE: CBO with Foreign Key

Wolfgang, Thanks for the response. The problem I am seeing is slightly different. (I'll try to post some more detailed data, when I have the time). It's time to take a deep breath and be a bit clearer in my description. The issue arises when the PK of the parent is made up of more than 1 field.

Re: RE: Passed Net8 OCP Exam

best 9i new features doc i have seen is written by howard rogers. do a google search for howard Rogers lydian third. there will be a link on the site for 'books'. very well written. lots of good stuff on that site. From: Gary W. Parker [EMAIL PROTECTED] Date: 2003/10/17 Fri PM 02:42:07 EDT

Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

My experience in contacting Oracle regarding modifying of notes on MetaLink has not been very satisfying. I did take the opportunity to voice my dissatisfaction by using the poll at the top of the article to indicate that I would not recommend this article to others. Jared Richard Foote

RE: anyone have opinions on the future of the 'grid'?

Bingo! That's how we will make Larry the richest man in the World... - Kirti --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: But that would require Oracle software to be installed on all the grids, don't you think? I'm really curious how they are going to pull this off. Tom Mercadante

RE: Older IT Workers becoming a hot commodity

No, but old I can handle. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 17, 2003 1:41 PM To: Multiple recipients of list ORACLE-L Experience? Are you certified in that? DENNIS WILLIAMS

RE: anyone have opinions on the future of the 'grid'?

Actually Dennis is quite correct. Part of the architectural framework is that you treat disk like a service. All disk storage is sharable across the enterprise grid you configure. If you have multiple grids in place, you would have multiple disk architecture frameworks in place. Alternately,

Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

The article states that leaf blocks are not reused, which is indeed incorrect, and has been for a very long time. Hemant K Chitale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 11:42 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL

Redo Log (Largest size used)

Hi, Platform : HP-UX 11.11 (64bit) PA-RISC Oracle : 8.1.7.4 EE (64bit) On a system I am looking at, during peak loads the redo logs are switching almost every minute. The logs are currently sized at 1G. I am recommending the redo logs be resized to a much larger value. (The

Re: insert and commit 1000 records at a time

I still dont get it... I dont know what I have done to have me confused more than I first asked the question... --- [EMAIL PROTECTED] wrote: My bad. The SQL is not quite right: 'append' is a hint: alter table resource nologging; dont know what nologging does. insert /*+ append */ into

RE: anyone have opinions on the future of the 'grid'?

Think really, really, really fast network. Check out http://www.aip.org/pt/vol-55/iss-2/p42.html Henry -Original Message- Mercadante, Thomas F Sent: Friday, October 17, 2003 2:41 PM To: Multiple recipients of list ORACLE-L But that would require Oracle software to be installed on all

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

If they don't have time to fix bugs, how do you expect them to spend timeto correct documentation and technical notes? Now many people pay to buy documentation nowadays ... Raj Rajendra dot Jamadagni at

Re: Redo Log (Largest size used)

I have redo log sized to 800MB in a one of our databases. I am considering to double its size, as the application generates too much redo, due to bad application code. Even for one column change, the rest of the row gets updated with the same values. I have heard of no issues with large redo

Re: insert and commit 1000 records at a time

Nologging suspends redo log entries generation FOR DIRECT OPERATIONS ONLY! Direct operations do not use SQL, they use Lisp (just kidding). Direct insert preformats blocks and appends blocks as a whole after the highwater mark, without using SQL in the process. On 10/17/2003 02:43:29 PM, MaryAnn

RE: insert and commit 1000 records at a time

MaryAnn, First of all, Wow! Is your reply to this group ever rude. Several people have offered you very clear and very good suggestions. And really, you SHOULD be reading the Oracle manuals. Otherwise, why did you take a job working with Oracle technology? I don't think the problem is with

Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

I wonder if it is not necessary to rebuild indexes is also a myth. It IS in some cases necessary 1. Indexes on monotonically increasing values [eg Conrurrent_Request_ID based on a Sequence or even on date columns which signify when the record is created] if the table is also purged by the same

Re: anyone use oracle collaboration suite?

hi i have done the installation of collaboration suite as part of some assessment.this was done about 6-7 months back. the issues - no support from oracle.no proper documentation.infact support is totally unaware what the product is all about. - installtion of three tiers ..complete software in

Re: Redo Log (Largest size used)

Have you looked at MTTR to see if it meets the needs of the recovery scenarios at your site? Murali. |-+ | | Kirtikumar Deshpande | | | kirtikumar_deshpande| | | @yahoo.com | | |

RE: CBO with Foreign Key

Ah, but that cardinality underestimation has nothing to do with the join or the foreign key relationship, but solely with the other fallacy of the cbo - the predicate independence assumption. In your example, the predicates a and b are completely dependent; once you choose one, the other is

Re: Effect on Oracle of changing server time from EST to GMT

Another issue might be related to doing time-based recovery. Oracle has a couple of notes on metalink related to changing server time and database impact. Note:1013279.6 - HOW DOES DAYLIGHT SAVINGS TIME AFFECT THE DATABASE? Note:77370.1 - What are the effects of changing the system clock on an

Re: Redo Log (Largest size used)

Yes we did.. It's a non-issue. We just print Yellow Pages ;) Applicaton Recovery time is not very critical. - Kirti --- Murali_Pavuloori/[EMAIL PROTECTED] wrote: Have you looked at MTTR to see if it meets the needs of the recovery scenarios at your site? Murali.

Re: insert and commit 1000 records at a time

MaryAnn, To get back to the original question, use a MOD function on rownum to get your commit point. Check the docs to make sure, but try If mod(rownum, 1000) = 0 then commit; end if; Daniel Fink MaryAnn Atkinson wrote: I still dont get it... I dont know what I have done to have me

RE: Table Size

SQL @actual eid_roles BYTES_USED -- 30711808 SQL select sum(bytes) from dba_segments where segment_name = 'EID_ROLES' SQL / SUM(BYTES) -- 34996224 The script reports the blocks (as determined by the rowid substring) that have live rows in them and multiplies it by the

Re: insert and commit 1000 records at a time

1. Define a variable to count inserted rows. insert_count number := 0; 2. Increment it after inserting the row insert_count:=insert_count + 1; 3. Check if insert_count = 1000 then commit and reset counter to zero insert_count :=0; 4. At the end when no rows found, and insert_count

Re: Effect on Oracle of changing server time from EST to GMT

Another thought for 9i...how would a time change impact flashback query? Daniel Fink david davis wrote: Another issue might be related to doing time-based recovery. Oracle has a couple of notes on metalink related to changing server time and database impact. Note:1013279.6 - HOW DOES

CBO, RBO and will v5 ever really go away?

Friends -- I just got back from a week of benchmarking and one of the issues that came out of it was, due to some rather, um, interesting, coding techniques, running schema level statistics both wrecked performance *and* produced Oracle Bug 2954921. So we had to remove the statistics before

passwords case sensitive

Is it possible to force a password case sensitive? Command? Thanks! TGIF bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--

RE: insert and commit 1000 records at a time

Assuming that the resource_id column is the PK (or at least unique) of the RQMT table something like this should work (albeit slowly). Its missing some definitions, but this should give you an idea on how you _might_ proceed Kevin DECLARE RowCount NUMBER:= 0; MAX

Re: insert and commit 1000 records at a time

At 04:44 PM 10/17/2003, you wrote: Got it, thanks to both of you, I really appreciate it. maa MaryAnn, To get back to the original question, use a MOD function on rownum to get your commit point. Check the docs to make sure, but try If mod(rownum, 1000) = 0 then commit; end if; Daniel Fink

For Melanie Caffrey

For Melanie Caffrey, Woww... Was your interference RUDE or what? Several people have offered you very clear and very good suggestions. First of all, mel, I didnt reply to several people, I replied to one. Was that one you? And really, you SHOULD be reading the Oracle manuals. Second of

Re: test

Yes, the list was down for a few hours. The server software went down, the admin has out cold with cold medicine and didn't hear the pager. You could say we were hit with a virus - the rhino virus. Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 12:04 PM

Re: passwords case sensitive

see $ORACLE_HOME/rdbms/admin/utlpwdmg.sql Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 01:54 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:passwords case sensitive Is it possible

Re: CBO, RBO and will v5 ever really go away?

Bambi, Oracle 5.1.22 was an exceptionally stable version of oracle, with very few parameters (names were TABLES,INDEXES and alike) and, as such will forever be committed to our memory. Furthermore, RBO is used in the data dictionary, just like the datatype LONG which has also, allegedly, been

RE: For Melanie Caffrey

MaryAnn, I, of course, do not have a problem with you asking a question, absolutely not. It was just your inference that we have you read it in the National Enquirer, if I'm quoting your email correctly, seemed pretty harsh. I thought you worked with Oracle stuff. If you do not, then I

RE: For Melanie Caffrey

Now, now, now MM There has got to be more to this story than mere SQLloader... -Original Message- Sent: Friday, October 17, 2003 5:04 PM To: Multiple recipients of list ORACLE-L For Melanie Caffrey, Woww... Was your interference RUDE or what? Several people have offered you

RE: CBO, RBO and will v5 ever really go away?

And also SQL*Loader will be rename to ODL (Oracle Data Loader) Stephane -Original Message- Mladen Gogala Sent: 17 octobre, 2003 17:19 To: Multiple recipients of list ORACLE-L Bambi, Oracle 5.1.22 was an exceptionally stable version of oracle, with very few parameters (names were

RE: sometimes pressure seems to get the best of us.

I am the one who needs to apologize, dont hold it agaist me though, its just sometimes pressure seems to get the best of us. Sorry, maa --- Melanie Caffrey [EMAIL PROTECTED] wrote: MaryAnn, I, of course, do not have a problem with you asking a question, absolutely not. It was just

RE: CBO with Foreign Key

I would agree if the FK was independently on columns a and b, but it isn't. It is on (a,b). Since we are joining on the FK fields, which are also the PK of the parent, we have: NDVp = rows(parent) and NDVc = NDV(a,b) != NDV(a) * NDV(b) and NDVc = NDVp so max(NDVp,NDVc) = NDVp = rows(parent) and

RE: passwords case sensitive

@C:\oracle\ora92\rdbms\admin\utlpwdmg.sql Im not seeing anything in that script that refers to enforcing ProperCase ??? ?? bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 5:14 PM To: Multiple recipients of list

Re: Where can I download 10g ?

On 10/17/2003 06:15:28 AM, Robertson Lee - lerobe wrote: Damn, I must have got the long version. My 9i came on 4 CDs !! Are you sure it's oracle 9i? If says Stairway to heaven on the cover, it might not be oracle 9i. Mladen Gogala Oracle DBA Note: This message is for the named person's use only.

RE: Problem in dropping Materialized View

Title: Message Re-create the materialized view and then try to drop it. Because you tried to rename it to the view name, I would say try it both as the view name and as the original name. I know it sounds silly but we had this problem once and creating it , will create whatever internal

Re: CBO, RBO and will v5 ever really go away?

Ah, another one who can claim experience. According to one of the previous post it's a genuine gold mine these days. Being born in the Jurassic (1961) has its advantages, but I have yet to find them. On 10/17/2003 05:29:31 PM, Stephane Paquette wrote: And also SQL*Loader will be rename to ODL

RE: passwords case sensitive

AFAIK, because there isn't any ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

Re: test

Cheer up, Jared and always look on the bright side of life. It's still much better then List-1555: Jared too old. Blessed are the cheesemakers! On 10/17/2003 05:09:25 PM, [EMAIL PROTECTED] wrote: Yes, the list was down for a few hours. The server software went down, the admin has out cold with

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

Title: Message Well, in a small step in our defense, it DOES state at the top of the note: * This article is being delivered in Draft form and may contain errors. Please use the MetaLink "Feedback" button to advise Oracle

FW: For Melanie Caffrey

MaryAnn, I, of course, do not have a problem with you asking a question, absolutely not. It was just your inference that we have you read it in the National Enquirer, if I'm quoting your email correctly, seemed pretty harsh. You didn't respond to one person, you responded to the entire list.

RE: Financials and APPS password

April: Wanted to chime in on this one but didnt have time. The APPS password is generally secure within the DBA group, HOWEVER, it can be seen by almost everyone that has access to UNIX or Concurrent Manager. Why? Because it can be seen from the command line. Unfortunately, this

Re: Effect on Oracle of changing server time from EST to GMT

Good point, Dan. If using SCN to flashback then it's a non-issue. Avoid using date/time stamp to flashback during that 1 hour period. Or find out the SCN from SYS.SMON_SCN_TIME table closest to the past time, and use it to flashback. - Kirti --- Daniel Fink [EMAIL PROTECTED] wrote:

RE: passwords case sensitive

Sorry, can't make it work in the case of 'ProperCase', at least not easily. I wasn't thinking it through when I replied. You could use it to enforce all lowercase, or init caps. Jared Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 02:29 PM Please respond to

RE: sometimes pressure seems to get the best of us.

Ah, the self-healing mailing list. Gotta love it. :) MaryAnn Atkinson [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 02:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: sometimes pressure

RE: CBO, RBO and will v5 ever really go away?

At least we knew why they called it afiedt.buf. -Original Message- Sent: Friday, October 17, 2003 5:00 PM To: Multiple recipients of list ORACLE-L Ah, another one who can claim experience. According to one of the previous post it's a genuine gold mine these days. Being born in the

RE: sometimes pressure seems to get the best of us.

No problem. I understand. Listen. Two similar messages I wrote went through. They seem to be taking about an hour to post. And sometimes, they're scrambled and out of order. A second post will be coming through, and it looks like the original post you just responded to. Please just ignore

Re: What is difference between SYSDATE and SYSDATE@! ??

Actually, [EMAIL PROTECTED] is a synonym for @#$%! Sysdate or f***ng sysdate. As such, [EMAIL PROTECTED] has its function and it fulfills it perfectly. On 2003.10.17 14:41, Mercadante, Thomas F wrote: Uh. I think that SYSDATE works, while [EMAIL PROTECTED] does not. Tom Mercadante Oracle

RE: What is difference between SYSDATE and SYSDATE@! ??

Actually it works also when there is space between sysdate and @!. SQL select sysdate @! from dual; [EMAIL PROTECTED] - 17-OCT-03 -Original Message- Sent: Friday, October 17, 2003 8:14 PM To: Multiple recipients of list ORACLE-L Actually, [EMAIL PROTECTED] is a

Re[2]: What is difference between SYSDATE and SYSDATE@! ??

Fascinating. I've tried: SYSDATE@ no [EMAIL PROTECTED] no SYSDATE@@ no SYSDATE! no and [EMAIL PROTECTED] yes But why? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one

Re: What is difference between SYSDATE and SYSDATE@! ??

Jonathan SYSDATE can be local and remote -- how to distinguish them?. Same is related to some other functions as well, e.g. USER. Try to do SELECT SYSDATE FROM [EMAIL PROTECTED]; and trace remote session. Oracle engine is smart enough. Mladen, there is no synonym for @#$%!, be more serious :) --

Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, October 18, 2003 4:42 AM Hi Hermant, I wonder if it is not necessary to rebuild indexes is also a myth. It might be but I've yet to hear it. It's certainly not something I've ever claimed,

Re: What is difference between SYSDATE and SYSDATE@! ??

Mladen, there is no synonym for @#$%!, be more serious :) I promise! Scout's honor! -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: What is difference between SYSDATE and SYSDATE@! ??

Mladen Gogala wrote: Mladen, there is no synonym for @#$%!, be more serious :) I promise! Scout's honor! I believe :) -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: