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
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 has
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.
Rega
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
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 .
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 recipi
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
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
Rich
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 reso
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
--
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
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 in
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 investme
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 ORAC
Experience? Are you certified in that?
DENNIS WILLIAMS
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. This
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 http://www
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 b
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]
Fa
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
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.
F
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
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
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 Merc
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
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, yo
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-
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 large
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
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 th
If they don't have time to fix bugs, how do you expect them to spend
time to correct documentation and technical notes? Now many people pay to
buy documentation nowadays ...
Raj
Rajendra dot Jamadagni at nospam
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 log
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 Atk
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 the
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 sam
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 two
Have you looked at MTTR to see if it meets the needs of the recovery
scenarios at your site?
Murali.
|-+>
| | Kirtikumar Deshpande |
| | |
| | Sent by: |
| | [EM
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
det
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
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.
>
>
> |-+-
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
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 db
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 >
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 DA
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 runn
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-- Ma
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
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,
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
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
P
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: password
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 d
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
apolog
Now, now, now
M&M 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 yo
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 "TABLES
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 j
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
j
@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
O
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
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
s
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 (Orac
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 !
---
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 col
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
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.
April:
Wanted to chime in on this one but didn’t 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
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:
> An
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 O
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:
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 Jurass
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 i
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 Cer
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 synon
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
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 :)
--
- 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
c
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
Sa
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: http
Stephen,
The "revealing" of the APPS password on the command line in SQL
was fixed by
patch 1196850 for 11.5 and back-ported to 11.0 and 10.7
See Note 201567.1 on MetaLink
Hemant
At 10:43 AM 17-10-03 -0800, you wrote:
April:
Wanted to chime
in on this one but didn t have time. The APPS p
79 matches
Mail list logo