Kathy,
This is probably not documented, but you can have multiple lines of
UTL_FILE_DIR _anywhere_ as _long_as_ you bunch them all up without any gaps
/ lines inbetween them (in which case the last set overrides the previous
ones). I have the following in a 7.3.4 Db, all at the end (and I bet tha
They are indeed 8i
Looked briefly at 8.0 and decided to wait for RMAN 8i. 9i is not yet
installed on my UNIX playground although I'll have a linux PC running 9i
soon.
I am waiting for your book to finish and it'll be the next one I'll buy, so
it better contain heaps of example scripts :-)
Thx
Similar here,
Start practising your mousing skills :-)
Jack
Mladen Gogala
Gogala,
SQL Server is childs play. General Database Admin is pretty easy and most
literate people can pick up skills quite fast.
Watch out for this cos it can attract many cowboys doing tasks that you may
not want them to.
Lots of GUI driven functionality.
And definitely no competition to Ora
Rachel,
This snippet is reading data from a previously opened
handle to a table. The 'print' statement prints a quote,
the contents of the array ref $ary delimited with ",", and
closes with quote and a newline.
Maybe not readable if you've never programmed in Perl,
but pretty simple stuff with
As with any language, it's assumed that the developer
will attempt to learn the language. :)
This is pretty simply stuff, and very readable to folks
with smattering of Perl knowledge.
Jared
On Wednesday 14 August 2002 20:38, Grabowy, Chris wrote:
> How many developers can maintain that "crypt
Rownum is not necessarily useless for this
kind of query. In versions of Oracle (8i+) where
an inline view can include an order by, it can
be rather useful.
Top 5 salaries:
select ename, sal
from (
select ename, sal
from scott.emp
order by sal desc
) a
where rownum < 6
Jared
On Wedn
Us, ordinary DBAs, may become obsolete , but goddesses, no, never.
Anyone who says that is a heathen. BTW, I got an assignment that I'm very
much looking forward to. I have to learn how to manageSQL Server. Long story:
our company acquired a smaller one, many IS people from the smaller compan
hi milind
iam not sure but does <= will work coz with rownum i thought
only < worked.hence we could use "< 11"
i not sure can u let me know ...
thanx and rgds,
Ams
-Original Message-
Sent: Wednesday, August 14, 2002 7:13 PM
To: Multiple recipients of list ORACLE-L
Hi Santosh,
Title: RE: RE: Dba tools on NT
Stay on the good side Jared. Your code snippet looks great to me, and looking at it finally showed me a clear example of how that q{} thingy works. I write a lot of Oracle utility type stuff that has to run on both Windows and UNIX. Perl does the job every time.
try this
select distinct(a.default_type_id), a.new_val
from amend_default_value a, amend_default_value b
where a.effective_from <= sysdate and
a.effective_to>= sysdate and
a.group_id = '942' and
a.default_type_id = b.default_type_id and
a.updated_da
but wont the following work , try it out...
select rownum, empno, ename
from emp
where rownum < 11
order by ename
plz do revert back...
rgds,
Ams..
-Original Message-
Sent: Wednesday, August 14, 2002 7:34 PM
To: Multiple recipients of list ORACLE-L
Unfortunately,
This reminded me of a Metalink note I once found.
Dennis - you might want to look at Note:145624.1 (RMAN: Resolving an RMAN Hung Job)
for some more hints & information.
Tim - the note mentions the debug command line parameter but doesn't show the
"trace=1" phrase so its good to learn tha
The problem is probably in the "RESETLOGS" part. Do you have many large log files?
If you do, your instance is trying to initialize them all. Take a look at the system
monitor and observe the CPU consumption. If it is large, you have a problem. If it
isn't,
use sar -b 5 50 or something alike and
Barb,
Hee hee! Oldest PL/SQL mistake in the book -- to handle an exception
improperly without passing it on...
It sounds like the duhveloper coded the exception block as follows:
exception
when others then
dbms_output.put_line('A serious error has occurred');
end;
How many developers can maintain that "cryptic" Perl code?
Come over to the light...don't be afraid.
Chris
PS. 20 alpha characters...and about 25 special characters in that bit of
code.hm, not going to say anything about that.
-Original Message-
To: [EMAIL PROTECTED]
Cc: Grab
because it is.
its not a problem with oracle, its a problem with the way the query is
written.
make the date mask /MM/DD HH24:MI:SS instead.
last i checked in math101, a number(or character string) 8 digits long,
that starts with a 31 is larger than an 8 digit number starting with 01.
jo
because it is.
its not a problem with oracle, its a problem with the way the query is
written.
make the date mask /MM/DD HH24:MI:SS instead.
last i checked in math101, a number(or character string) 8 digits long,
that starts with a 31 is larger than an 8 digit number starting with 01.
jo
Call RMAN from command-line as follows:
rman nocatalog log= debug trace=
Both the "logfilename" and "tracefilename" should have copious amounts of
output, which can provide a clue.
When you allocate the channel, make sure to add the phrase "trace=1" to the
end of the ALLOCATE command. This
I'm with you EXCEPT that how many people are still stuck on 8i, my
current asssignment is going to peoplesoft with EPM on 817, i've been
working with 9i since it came out, i've got to go back and regroup and
besides its not like the 8i variety wont work.
joe
Freeman, Robert wrote:
>Pretty g
I guess you are not using Oracle Human Resources Applications. For most of
the patches that we've applied, there are new bugs. It's a never-ending
applying patches-after-patches ... We've lost count of the number of TARs
opened. The worst part is after applying a patch to solve a bug, the new
pr
I'm with you EXCEPT that how many people are still stuck on 8i, my
current asssignment is going to peoplesoft with EPM on 817, i've been
working with 9i since it came out, i've got to go back and regroup and
besides its not like the 8i variety wont work.
joe
Freeman, Robert wrote:
>Pretty g
Hannah, which version of database are you playing with as that depends
on who can run it and/or what permissions they need to run it.
joe
[EMAIL PROTECTED] wrote:
> Hi,
>
>
>
> I would like to grant the ability to a user to run logminer. I
> tried granting execute on both dbms_logmnr
-- Pat Howe <[EMAIL PROTECTED]>
> I am trying to work thru the one of the scripts that I inherited and I was
> wondering if someone could shed some light on why the author used a UNIX
> PIPE to uncompress a file.
Few reasons:
(1) Many file systems blow up w/ files > 2GB, they are a
mess i
Thanks Chaos for your invaluable information.
Chuan
-Original Message-
Sent: Thursday, 8 August 2002 7:34 PM
To: Multiple recipients of list ORACLE-L
Chuan Zhang£¬
hi, go to $ORACLE_HOME/rdbms/admin, ls sp*, you will find the sqls that needed
by statspack. and vi spdoc.txt, y
Hannah, which version of database are you playing with as that depends
on who can run it and/or what permissions they need to run it.
joe
[EMAIL PROTECTED] wrote:
> Hi,
>
>
>
> I would like to grant the ability to a user to run logminer. I
> tried granting execute on both dbms_logmnr
readable. uh huh. sure
how does this create a csv file?
--- [EMAIL PROTECTED] wrote:
> How many of those "non-cryptic" languages can dump a table
> to a CSV file in 2 lines of (readable ) code?
>
>while ( my $ary = $sth->fetchrow_arrayref ) {
> print q{"} . join(q{","},@{$ary}) . qq
I know why i did it in the past, 32 bit os, 2G limitation of single file.
i could run an export, compress on the fly and have a uncompressed file
that is > 2G.
hence you need to work it backwards, since if its > 2G, the uncompress
will choke(or truncate).
amazingly, that is NOT a stupid idea.
I won't comment on the Perl side of things but will give some alternatives (& reasons).
Does the DBA team or system admins already know any Windows scripting tools - if so I
would consider using them?
What are you trying to script - this will affect which tool is appropriate?
Are you going to be
one possibility comes to mind:
there is not enough room in the original directory for the uncompressed
file and the compressed one (both exist while the uncompress is
running)
--- Pat Howe <[EMAIL PROTECTED]> wrote:
> I am trying to work thru the one of the scripts that I inherited and
> I was
>
oh Cary/Dan/Jared
thank you it's been a rough day and this made me laugh out loud
--- Cary Millsap <[EMAIL PROTECTED]> wrote:
> From another session, it's:
>
> exec dbms_system.set_imaginary_param_in_session(
> $SID,
> $SERIAL,
> 'sql_execution_speed',
> 'warp_10'
>
obviously one of the new 9iR2 parameters designed to make the DBA
obsolete :)
--- [EMAIL PROTECTED] wrote:
> Oh, in that case:
>
> ALTER SYSTEM SET SQL_EXECUTION_SPEED=WARP_10;
>
> ;)
>
> Jared
>
>
>
>
>
> "Khedr, Waleed" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 08/14/2002 08:58
she is. And she does. And she's the one in charge of the RDA project --
the Remote Diagnostic Agent
And from experience, yeah, some people at Oracle Support are less than
wonderful. And some (like Anita) are amazing.
As with everything, you win some, you lose some. Depends on who you
talk to.
Hi Guys
I was just wondering if anybody could help me and send me some contacts
or head hunter's in GTA.
I'm currently Working in Montreal and am looking to move to Toronto.
I'm a DBA with 3 years experience and am in desperate need of a new
challenge.
Any help would be greatly appreciated.
Tha
Title: RE: Simple question on logging..
Hi
All,
Is it true that I cannot create a materialized view by accessing a
remote table? Here is the syntax for creating the materialized view but it does
not work.
REM
Create materialized view mast_time_mvCREATE MATERIALIZED VIEW
mast_time_mv P
I am trying to work thru the one of the scripts that I inherited and I was
wondering if someone could shed some light on why the author used a UNIX
PIPE to uncompress a file.
Code :
mknod /tmp/testdb_data_01.dbf_pipe p
uncompress < /tmp/testdb_data_01.dbf_pipe >
/u06/oracle/oradata/testdb/tbs/da
Looks OK to me, seems about right
Although when you start using Macros and such the readability drops a
little as it can take a bit of jumping around to understand it.
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical Co
Title: RE: RE: Dba tools on NT
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> How many of those "non-cryptic" languages can dump a table
> to a CSV file in 2 lines of (readable ) code?
>
> while ( my $ary = $sth->fetchrow_arrayref ) {
> print
Sounds like it. Give yourself a beer as a prize. ;)
Jared
"Lord, David - CSG" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/14/2002 01:23 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: U
SQL loader(direct load),direct inserts,
and create table as select...will not generate redo/undo by using NOLOGGING.
Your Transaction is logged while deleting rows, can't be blocked.
correct me if I am wrong.
Sunil Nookala
Database Analyst
Dell Corp
Austin, TX
-Original Message-
Sen
Title: RE: Simple question on logging..
> -Original Message-
> From: Peter R [mailto:[EMAIL PROTECTED]]
>
> How can I turn off logging for a table in Oracle7.3 database.
Recoverable/unrecoverable is not a "persistent" attribute in 7.3.4 The "unrecoverable" option only applies to th
Robert - Thanks a million. I'll get started on that tomorrow. Yep, I figured
I'd made some type of novice error which is why I posted the commands I'm
using.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 14, 2002 4:33 PM
To: Multiple re
database 8.1.7.3
Has anyone run into and knows a work around
for utl file limitations.
Specifically, we have many directories we
need to write to over 512 bytes but the problem is if we need to run a session
trace , we can only have 256 bytes and the directory that the trace file goes to
How many of those "non-cryptic" languages can dump a table
to a CSV file in 2 lines of (readable ) code?
while ( my $ary = $sth->fetchrow_arrayref ) {
print q{"} . join(q{","},@{$ary}) . qq{"\n};
}
Come over to the dark side Chris. ;)
Jared
"Grabowy, Chris" <[EMAIL PROTECTED
As long the exception handler is catching the error then the code is assumed
to run successfully and no errors should be detected anywhere.
If you are still interested in handling this error outside the code, then
you can raise an exception from inside the exception handler:
begin
null;
except
"I've called Oracle for a TAR once in the past 18 months."
Ah, my friend, but you're not using Portal 9.0.2, are you? I've opened more TARs in
the last few months than the rest of my Oracle career. Bleeding edge, I guess, so
maybe its our own fault. But third-party support for this would hav
Can I use the nologging option on simple inert and deletes to eliminate
rollback problems and redo generation?
Ron S.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
OK, I admit up front I'm not a pl/sql programmer. And I really did try to
look this up. Honest.
Took me a VERY long time to figure this out, but here it is...
I have a command procedure running a sql*plus script that then runs a stored
procedure. (This is VMS, but I think it would work the
> Q: Does anyone know of any reliable 3rd party support for
> Oracle?
Yes. Dial www.miracleas.dk.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11
Honolulu
- 2003 Hotsos Symposium on OracleR Sys
ALTER TABLE yourtable NOLOGGING
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 14, 2002 4:33 PM
>
>
> Hi Gurus,
>
> How can I turn off logging for a table in Oracle7.3 database. Iam planning
> to reorg thru ctas and want
There is a bug in 8.1.6 that is fixed in 8.1.7:
1164440 The RMAN command "release channel" reports RMAN-20020 if there are
"set until" and "alter database open reset logs" commands in the same "run"
block.
While this isn't exactly like your problem, it might be related. So, I'd
remove the last
>From another session, it's:
exec dbms_system.set_imaginary_param_in_session(
$SID,
$SERIAL,
'sql_execution_speed',
'warp_10'
)
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas,
See http://www.hotsos.com/dnloads/1/10046a for more information about
turning trace on and off, with details that vary by Oracle version and
so on...
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11
H
Or
ALTER SESSION SET TIME_TO_UPDATE_1_RECORDS = <1hour
-Original Message-
Sent: Wednesday, August 14, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L
Oh, in that case:
ALTER SYSTEM SET SQL_EXECUTION_SPEED=WARP_10;
;)
Jared
"Khedr, Waleed" <[EMAIL PROTECTED]>
Sent by: [
Hi Gurus,
How can I turn off logging for a table in Oracle7.3 database. Iam planning
to reorg thru ctas and want to use append hint for loading data.
SQL> alter table tt unrecoverable;
alter table tt unrecoverable
*
ERROR at line 1:
ORA-01735: invalid ALTER TABLE option
SQL>
Well, that's not really fair. There are a number of good people
that work for Oracle Support. True, there are also some that
are subpar, but how often is it necessary to open a TAR anymore?
MetaLink has vastly improved over the past couple of years.
I've called Oracle for a TAR once in the pas
Oh, in that case:
ALTER SYSTEM SET SQL_EXECUTION_SPEED=WARP_10;
;)
Jared
"Khedr, Waleed" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/14/2002 08:58 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:
Somewhere along the way I began to think it was INSERT, not UPDATE.
No wonder everyone else is talking about indexes.
Oh well, free advice is sometimes worth less than you paid for it. :)
Re the tracing:
If your job is run via sqlplus, you can turn tracing on with this
at the top of the sc
She was a Senior Program Manager (don't know if that's Support or not) two
months ago, when I was whining about RDA problems. Anita's a great asset to
Oracle. I hope she's still there for Oracle's sake (and ours, too!). :)
Rich Jesse System/Database Administrator
[EMA
What is the duration of the data in the table? Is it session or transaction?
If it's session, you need an intervening commit.
> -Original Message-
> From: Sam Bootsma [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 14, 2002 3:01 PM
> To: Multiple recipients of list ORACLE-L
> Subjec
I am trying to perform an RMAN disaster recovery task. While I use an RMAN
catalog to make backups, I am trying to recover using just the control file
information.
Oracle 8.1.6, Compaq/HP Tru64
I start RMAN with
rman target sys/password nocatalog
then,
startup mount
run {
set until ti
How about select_catalog_role ??
Otherwise you need at-least
* select any table
* alter any procedure
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn
Title: RE: c_USER#
So do you guys think , locally managed tablespace
can get rid of this contention , at present it's dictionary managed tablespace
.
-bp
- Original Message -
From:
Jacques Kilchoer
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Sent: Tuesday, Augu
If you've got OEM around, look at refresh_groups.
Reply Separator
Author: =?iso-8859-1?q?Nalla=20Ravi?= <[EMAIL PROTECTED]>
Date: 8/14/2002 11:13 AM
Hi All,
Can you please kindly clarify the following doubts on
snapshots:
we have got around 50 sna
Glenn:
Why not create a role, grant the permissions you need to the role and grant
to role to the user?
Isn't this the traditional way to do what you want here?
Andy
-Original Message-
Sent: Wednesday, August 14, 2002 3:28 PM
To: Multiple recipients of list ORACLE-L
I want to create
To know Python is to love Python and eschew Perl... obfuscation is
possible albeit more difficult. ;-)
-Original Message-
Sent: Wednesday, August 14, 2002 1:27 PM
To: Multiple recipients of list ORACLE-L
Importance: High
Well, there is the obfuscated Perl contest, but that's intention
Ok, ok!!! I give up. Perl is the greatest language in the world!!! We
should all learn to speak it!!!
Happy??
-Original Message-
Sent: Wednesday, August 14, 2002 2:15 PM
To: [EMAIL PROTECTED]
Cc: Grabowy, Chris
Well, there is the obfuscated Perl contest, but that's intentional. :)
Well, there is the obfuscated Perl contest, but that's intentional. :)
If you make use of 'use English;', the two character system
variables can be replaced with readable names, though it
involves a lot more typing.
I don't see how it's any less readable than C. I really don't
know how to compa
I want to create a user and grant it access to all other users' objects, INCLUDING
packages and procedures. I don't want to give the user DBA privs. Is this possible?
Basically, (for OracleApps shops), I want to give the id APPS user power w/out giving
the id the apps password. The userid wi
I just pre-ordered your book, says it wil be ready Nov. Is the realistic date? :)
Gene
>>> [EMAIL PROTECTED] 08/14/02 12:13PM >>>
Pretty good scripts.
Just looking at them, they appear to be more of the 8i variety.
There are some improvements in 9i and 9iR2 that could be considered,
such as the
Yup, that's the way it works. :(
Jared
"Naveen Nahata" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/14/2002 05:48 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Oracle Arm Twisting?
Hi All
> ...is there a way to have these scripts in a
> user's home directory and still call them thru web/HTML forms?
Have you considered the security implications of this?
Jared
"Alroy Mascranghe" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/14/2002 12:13 AM
Please respond to ORACLE-L
Hi All,
Can you please kindly clarify the following doubts on
snapshots:
we have got around 50 snapshots to be created on same
database from 1 schemas 2 another readonly
majority of these snapshots access same base tables
1) can I refresh them parallely? At a time Howmany
can I refresh para
Spot on!
Using DISTINCT and indexes will also cause implicit sorting.
-Original Message-
Sent: Wednesday, August 14, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L
(snipped a lot from Dan's reply..)
>
> As you can see, the rownum is not altered with the sort
> order. In
Dear list,
I'm running into a strange problem on one of my dev databases.
First, the particulars:
Dell Dual Pentium III
1 Gig Ram
Oracle 8.1.6
The database in question is used for testing and development on
a customized 3rd party app.
This past week I've seen the app max out the number of p
Platform: Dell 8200 / XP Prof.
I previously had 9.1 installed on my stand alone
PC.
I de-installed 9.1 and removed all associated
files.
I installed 9.2. Everything went fine until I got near
the end when I ran into an error.
The feedback I got is:
Oracle net config. asst.
Hello,
One of our clients has AIX UNIX v4.3.3 OR v5L and Oracle 9.1. They have
problems with temporary tables as shown in the two scenarios below.
Scenario 1: In one procedure, we insert into a temporary table. In a
different procedure we select from the same temporary table. We use the
sam
Selecting from a sequence DOES generate logs. The statement will be a UPDATE to the
SYS.$SEQ.
I have an issue right now where we have a runaway process that polls the sequences
(and doesn't use them), and it is generating SO much archiving that its a real
issue. (still workging on it)
Try creating this index first and see if it helps:
create index dbimp1.new_index on dbimpl.npa_nxx(nxx_id ,npa_id ,lata_id)
parallel 2 nologging;
-Original Message-
Sent: Wednesday, August 14, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L
I am not testing your guys' skills I a
Tim,
From our recent wrangling with Oracle Support. First off there is the
Support Sales folks who are absolutely idiots. Change as little with these
folks as you absolutely have to. And double check any quotes they send you,
most will not add up the first few times around. Also these fol
Why would you want to do that - convert two dates into a char and then
compare them ? This is not a problem but it is how char comparisions work.
They are compared char by char to see which one is greater on the ASCII
chart.
See this : SQL > select '1' from dual where '3' > '10';
'
-
1
Babu
Why do you need the to_char?
But wouldn't it work anyway with
to_char(a.updated_date,'dd/mm/ hh24:mi:ss') =
( select to_char(max(updated_date),'dd/mm/ hh24:mi:ss'))
which will also use the 24 hour clock instead of
to_char(a.updated_date,'dd/mm/ hh:mi:ss') =
( selec
reference to context ... reference to context ...
Thanks Peter
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any c
Title: RE: what is wrong with this idea ...
If you are using 8i+ consider using materl. views. They are wonderful and make maintenance of denormalized objects much less of a chore. I am oh so happy with them. There are some limitations but still.
-Original Message-
From: Gurelei
Anybody know if Anita Bardeen is still working for Oracle
Support?
--Walt
Weaver
Bozeman, Montana
-Original Message-From: Rodd Holman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 14, 2002
10:54 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Oracle Arm Twis
I am not testing your guys' skills I am honestly asking for help as I don't
have much experience about database. I have a lots on my plate at work to
take care of that's why I don't have much time to check email or to
response.
Here are some stupid questions I need to ask...how do I turn trace o
In the second case you are also selecting from sequence which might have
generated the logs. Use logminer and get the details of what was logged.
Naveen
-Original Message-
Sent: Wednesday, August 14, 2002 10:14 PM
To: Multiple recipients of list ORACLE-L
Rick,
These are the transacti
I had always understood that a query which joins a remote table
to a local table would pull the entire remote table over and then
do the join locally.
However, the example in the Oracle9i Database Performance
Tuning Guide and Reference (9.2), Chapter 2 Optimizer Operations
"How the CBO evaluates
(snipped a lot from Dan's reply..)
>
> As you can see, the rownum is not altered with the sort
> order. In order to
> retrieve the first 10 records by name, you need to have the
> output sorted
> prior to assignment of rownum.
... to point out that 'group by' will allow you to achieve s
Some background info on support pricing...
For the RDBMS and related database products, support pricing is based a
percentage of license pricing. Generally, "perpetual" licensing means just
that (i.e. forever), while 2-year lease pricing typically comes at 35% of
perpetual licenses and 4-year le
Resending
>Date: Wed, 14 Aug 2002 23:42:35 +0800
>To: [EMAIL PROTECTED]
>From: Hemant K Chitale <[EMAIL PROTECTED]>
>Subject: Query with a Remote Table over a DB-Link
>
>
>I had always understood that a query which joins a remote table
>to a local table would pull the entire remote table over and
Mike/Tim
My suggestion was based on 10.7 and database version 7.3.4 on HP-UX 10.20.
Yes, I am also pinning a lot of objects of Oracle Financials to avoid shared
pool congestion. Increasing shared pool was not an option at that time due
lack of available memory, flushing shared pool was the on
Hi All,
I am using the to_char function in the following query. But it treats the date
'31/12/2001' as greater than '01/01/2002'.
Is there any solution to fix this problem?
select distinct(a.default_type_id), a.new_val
from amend_default_value a, amend_default_value b
where a.effectiv
I hope you won't mind Charlie that reply and copy your email.
I have been explaining similar things every day this week to different
developer here ... it finally got me. Sorry, Santosh, it is not your fault,
nor anyone else's. But I still stand by my opinion.
Raj
___
I shall suggest to visit HP / Oracle web site for detailed info. In recent
past I have seen an online seminar on OPEN VIEW whereby they informed about
integration of HP Openview with Oracle Enterprise Manager thus making it
more practical to check/monitor databases and operating system.
Regard
Yes, Oracle support sucks, and is staffed with morons. However one thing you get with Oracle support that you cannot get with third party support is bug fixes and product upgrades. If you want this without a support contract, you need to buy new licenses each time you upgrade.
Rodd
On W
Whoops!
> * No matter how you use ROWID, it is USELESS.
Really?
Even for deleting duplicate rows?
(well, lets overlook fact they shouldn't have been there anyway...)
peter
edinburgh
*
This e-mail message, and any fil
Yes, you'll have to pay all along or repurchase for support unless
Oracle does something about this.
John P Weatherman
Database Administrator
Replacements Ltd.
-Original Message-
Sent: Wednesday, August 14, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L
Maintenance cost is
What you said is right, Oracle can dictate terms on me, because I have
already implemented the system and spent a great deal in customizing it.
But the point is that I have to live with the mistakes that someone else made
in the past by overestimating the user base. e.g. For some modules we have
I'd prefer to build a normalized ODS structure and then build
any denormalized structures on top of it. Thus, I'd keep the
Parent to Child relationship and put each status in it's own
row, with a temporal time stamp. If you need some denormalized
view of that (because of performance) then I'd bui
1 - 100 of 202 matches
Mail list logo
