 | | | Oracle List | | Have you tried custom install removing all the options and selecting only
the DBMS?
Yechiel Adar
Mehish
----- Original Message -----
From "Adam Donahue " <adonahue@(protected) >
To <oracle-l@Here you go.. Deepa Subodh Nissar
I have put the definition of view for yr information.
If I do insert directly from this query It gives me error and
disconnects the session buddy.
If I m Hi
Did you try to reload the daemon ?
Try this
$ oradbsnmp ....
$ su -
# refresh -s snmpd
Regards
Antonio Belloni
--- Prem Khanna J <premj@(protected) > escreveu
> Hi All
Thanks to Jeffrey Beckstrom 's sharing of a similar experience we appear
to have identified a bug and a workaround. I turned off Dead Connection
Detection and the problem automagically went away. > Hi All
> Does any one have an example they can share on performing a large
> delete in small chunks?
Here 's a quick & dirty script I put together recently for purging old
data from an audit Hi
I agree with Jared. I like using their book as a starting point for
Oracle administration ideas in perl. Its a cross platform solution
with only minor variations per OS.
I support python When you say pass a "table " if you mean a PL/SQL table then yeah no
problem. That functionality exists way back even 7.3.4 maybe even
before.
TYPE table_parm IS TABLE OF VARCHAR2(2000)
Or you could create a logon trigger that
acquired the value and stuffed it into a
context so that the user could use a call
to sys_context( 'your_system_context ' 'sid ').
Probably more efficientHave tried it doesn 't. 20
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From Ken Naim [mailto ken@(protected)] 20
Sent Friday October 15 2004 2 13 PM
David
Here 's the best part. Oracle now has *two ways* of sending patches out to
us. One is the current (old) way where you run oracle installer. The other
(new) way is where you run Opatch. Glad I could help but.....
That may not work either.
What if the blocking session does
update tab_a set col_b 3D 'Hi there ' where col_a 3D1
So when that completes execution you can still
Responding to some of the responses
1. RMAN is a recovery tool. I would expect to use RMAN to recover my database
from a valid backup. Let 's say your data was flat files and backed-up usingBob
I 'm pretty rusty on it but the basics are
WHILE foo
LOOP
UPDATE xxx
SET col1 3D ***
WHERE conditions
EXCEPTION
WHEN OTHERS
THEN
Your error haDoes anybody know why I am getting this error
Start of log messages from Plsql program
+Please ignore my previous message. I have figured out the problem. The
size of one variable in the trigger was too small.
David
Hi
This should satisfy your requirements
select distinct * from hier
connect by prior b 3D a
start with a > 3D 100
HTH
Alan Davey
-----Original Message-----
From oracle-l-bo http //download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/toc.htm[1]
Regards
Stephane Faroult
RoughSea Ltd
http //www.roughsea.com
On Fri 15 Oct 2004 08 04 'Seema SinghThanx for the info ' Mark . This is the SQL .
SELECT /*ordered index (prrv pay_run_result_values_pk)*/
pap.employee_number employee_number
papr.payroll_name payroll_name
pbt.balance_Lex
Thanks for correcting me. Clearly I 'm wrong and replied without thinking
properly. The data dictionary views all_* etc. provide an example showing that
you can have access to a view but not The solution turned out to be to change the global name from
"MCHSTAGE.LOCALDOMAIN " to "MCHSTAGE.WORLD ". When the database was
created the domain defaulted to LOCALDOMAIN. Database links can now Hi
> Can someone please verify...If the FTS spawns a number of slaves based on
> the degree does each sort operation also get that number of slaves is
> that correct?
You may simple veWithout the catalog the default setting for control_file_record_keep_time
is already 7 so you don 't need to do anything!
With the catalog there 's a couple of options. You could go for the simple
Hi All
Does Workflow require a separate license with Oracle Application Server?
I have a contact who 's asked the question as he 's read this comment on
oracle.com
"OW4J will complement - notHi!
> I don 't understand why the select from dual is not showing
> the extra I/O and stats I see on the "insert ... values
> (...nextval...) " when the seq cache is small.
Which version?
In 1Have you tried clearing the cache to see the activity after it 's cleared not the best choice - as it could affect the response time but...
"Smith Ron L. " <rlsmith@(protected) > wrote
So you are sayMichael
an .a file is a library storing the object modules.
I 've no AIX at hand here but something like 'ar xv libclntsh.a
libclntsh.o ' should do the job. It simply extracts the module from tWow... that 's quite possibly the most obnoxious email disclaimer I 've seen.
On Thu 14 Oct 2004 11 58 09 +0530 a.kish@(protected) <a.kish@(protected) > wrote
> Hellow All
>
> I want to load data fromHi there
Well first you need to know how you current system is coping with the
available resources
Memory cpu IO on disks.
Having pretty much always used SUN for the last 7 yrs in one forWhat do the execution plans look like in each case?
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)]On Behalf Of Prem Khanna J
Sent WednesdaIf I calculated that correctly the 3rd exec took 584 942.4 years. Did
anyone complain about performance?
At 06 12 PM 10/13/2004 Larry Elkins wrote
>PARSE #5 c 0 e 3328 p 0 cr 0 cu 0 mis 1 r 0 |
|
|
