Re: FW: Lots of Help needed

2004-01-27 Thread Mladen Gogala
Oracle people, I am hoping that some of you can help me and/or provide details etc. for my situation I find myself in. So if you bear with me I will describe the situation. I currently support an Oracle 9i (just moved from 7.3.4), windows, tuxedo, client server application for a utilities company

FW: Lots of Help needed

2004-01-26 Thread Biddell, Ian
Hi there fellow Oracle people, I am hoping that some of you can help me and/or provide details etc. for my situation I find myself in. So if you bear with me I will describe the situation. I currently support an Oracle 9i (just moved from 7.3.4), windows, tuxedo, client server application

RE: Help - 9ias broke - hostname was changed

2004-01-23 Thread Paula_Stankus
Title: Message Help System Admin. got a wild hair and changed the hostname on us for a 9ias v2 server. Now none of the processes work and getting all kinds of unhandled java exceptions regarding hostname oracle.ias.repository.schema.SchemaException:Unable to connect to Directory I

RE: Help - 9ias broke - hostname was changed

2004-01-23 Thread Gene Sais
Have the SysAdmin change the hostname back. Haven't used 9iAS but in the past, the hostname was embedded in the install config files. You can put in a DNS alias for your old hostname for a work around. [EMAIL PROTECTED] 01/23/04 11:44AM Help System Admin. got a wild hair and changed

Re: Help - 9ias broke - hostname was changed

2004-01-23 Thread Mladen Gogala
that utility? On 01/23/2004 11:44:26 AM, [EMAIL PROTECTED] wrote: Help System Admin. got a wild hair and changed the hostname on us for a 9ias v2 server. Now none of the processes work and getting all kinds of unhandled java exceptions regarding hostname

RE: Help - 9ias broke - hostname was changed

2004-01-23 Thread Jared . Still
. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 08:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Help - 9ias broke - hostname was changed Help System Admin. got a wild hair and changed the hostname

RE: Help - 9ias broke - hostname was changed

2004-01-23 Thread Paula_Stankus
Yes, but how do I fix it? Do I need to reinstall? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Help - 9ias broke - hostname

RE: Help - 9ias broke - hostname was changed

2004-01-23 Thread Paula_Stankus
I think he lucked out and didn't do this on a highly visible system. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Help - 9ias

RE: Help - 9ias broke - hostname was changed

2004-01-23 Thread DENNIS WILLIAMS
. This one's days are limited to about 10. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 08:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Help - 9ias

RE: help

2004-01-21 Thread Jared . Still
LOL!! Ok, Ashish, the problem is you sent 'help' to the list address. Send HELP to [EMAIL PROTECTED] and all will be well. Ok, now back to work everyone. Jared Odland, Brad [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 07:59 AM Please respond to ORACLE-L

help

2004-01-20 Thread Bill Gentry
help Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Gentry INET: [EMAIL

Re: help

2004-01-20 Thread Mladen Gogala
Abandon hope, all ye who enter here (Dante Alighieri) On 01/20/2004 10:24:27 AM, Bill Gentry wrote: help Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005

RE: another OCP question -- help me guys

2004-01-09 Thread Thater, William
PROTECTED] (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).

RE: Trigger Question - Thanks for all the help

2004-01-09 Thread Nuala Cullen
, send an E-Mail message :-to: [EMAIL PROTECTED] (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

RE: Re[2]: another OCP question -- help me guys

2004-01-08 Thread Jamadagni, Rajendra
') 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).

Re: another OCP question -- help me guys

2004-01-08 Thread Richard Foote
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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

Re: another OCP question -- help me guys

2004-01-08 Thread Mogens Nørgaard
list, send an E-Mail message to: [EMAIL PROTECTED] (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

Re: another OCP question -- help me guys

2004-01-08 Thread Rachel Carmichael
send the HELP command for other information (like subscribing).

RE: another OCP question -- help me guys

2004-01-08 Thread Pete Sharman
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.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City

another OCP question -- help me guys

2004-01-07 Thread Prem Khanna J
Hi list , sorry to pester you with questions regarding boson OCP questions . i have scheduled for #1Z0-031 exam and so desperately need help from this list . please bear with me for while . look at the 2 questions below

Re: another OCP question -- help me guys

2004-01-07 Thread Richard Foote
regarding boson OCP questions . i have scheduled for #1Z0-031 exam and so desperately need help from this list . please bear with me for while . look at the 2 questions below . - QUESTION #1 what happens when you issue

Re: another OCP question -- help me guys

2004-01-07 Thread Jonathan Gennick
regarding PKJ boson OCP questions . i have scheduled for #1Z0-031 exam PKJ and so desperately need help from this list . PKJ please bear with me for while . look at the 2 questions below . PKJ - PKJ QUESTION #1 PKJ what happens when

Re: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
:24 AM, Prem Khanna J ([EMAIL PROTECTED]) wrote: PKJ Hi list , sorry to pester you with questions regarding PKJ boson OCP questions . i have scheduled for #1Z0-031 exam PKJ and so desperately need help from this list . PKJ please bear with me for while . look at the 2 questions below

Re[2]: another OCP question -- help me guys

2004-01-07 Thread Jonathan Gennick
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
') 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Ryan
-Mail message to: [EMAIL PROTECTED] (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

Re[3]: another OCP question -- help me guys

2004-01-07 Thread Prem Khanna J
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Stefick Ronald S Contr ESC/HRIDA
Title: RE: Re[2]: another OCP question -- help me guys Uh No one can be at Rachel's level. She's the DBA Goddess -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 07, 2004 8:55 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re[2

Re[3]: another OCP question -- help me guys

2004-01-07 Thread Prem Khanna J
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).

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
from). You may also send the HELP command for other information (like subscribing).

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Thater, William
from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Ryan
PROTECTED] (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

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Mladen Gogala
it or not, a college degree in art history really does help in two ways. First, people exposed to sufficient quantity of art tend to be nobler and more spiritual, according to the popular beliefs, then cynical mathematicians and computer geeks like me. Being noble and spiritual means that they don't

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
') 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Thater, William
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).

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
programming and database work? Believe it or not, a college degree in art history really does help in two ways. First, people exposed to sufficient quantity of art tend to be nobler and more spiritual, according to the popular beliefs, then cynical mathematicians and computer geeks like me

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Loughmiller, Greg
Title: RE: Re[2]: another OCP question -- help me guys brutal, absolutely brutal... Rachel, can ya out-source your sacrificial lamb for our use as well:-) -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 07, 2004 11:54 AM To: Multiple

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Goulet, Dick
') 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.net -- Author: Goulet, Dick INET: [EMAIL

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Poras, Henry R.
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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
PROTECTED] (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

Re: another OCP question -- help me guys

2004-01-07 Thread bulbultyagi
Hi list , sorry to pester you with questions regarding boson OCP questions . i have scheduled for #1Z0-031 exam and so desperately need help from this list . please bear with me for while . look at the 2 questions below . Don't apologize Prem, who else are you gonna call, ghostbusters

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Niall Litchfield
, 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).

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
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). __ Do you Yahoo!? Yahoo

RE: another OCP question -- help me guys

2004-01-07 Thread Naveen, Nahata (IE10)
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: another OCP question -- help me guys Hi list , sorry to pester you with questions regarding boson OCP

rep-1219 need help

2004-01-04 Thread Rohan Karanjawala
to rebuild it again to get the required report output can somebody please help me out of this thanks regds, Rohan From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: starting/stopping trace in session Date: Fri, 02 Jan 2004 20

Re: help with estimate row count from asktom

2003-12-31 Thread Yong Huang
to true (on session level). But I doubt it'll help in current case anyway. Tanel __ Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003 http://search.yahoo.com/top2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong

help with estimate row count from asktom

2003-12-30 Thread ryan_oracle
: 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).

Re: help with estimate row count from asktom

2003-12-30 Thread Wolfgang Breitling
to: [EMAIL PROTECTED] (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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA

Re: Re: help with estimate row count from asktom

2003-12-30 Thread ryan_oracle
recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: help with estimate row count from asktom v$sql_plan_statistics (and consequently v$sql_plan_statistics_all) only have data to show if statistics_level is set to ALL. You can set that at the session level. Has anyone done measurements

RE: Re: help with estimate row count from asktom

2003-12-30 Thread Jamadagni, Rajendra
want to be removed from). You may also send the HELP command for other information (like subscribing).

RE: Re: help with estimate row count from asktom

2003-12-30 Thread Bobak, Mark
. It's built-in to Intermedia. -Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tue 12/30/2003 1:19 PM To: Multiple recipients of list ORACLE-L Cc: Subject:Re: Re: help with estimate row count from asktom im concerned about hitting the v

Re: Re: help with estimate row count from asktom

2003-12-30 Thread ryan_oracle
anyone have a better way to do this? im going to post what you said wolfgang on asktom and see what he has to say. From: Wolfgang Breitling [EMAIL PROTECTED] Date: 2003/12/30 Tue PM 12:09:33 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: help with estimate row

RE: Re: help with estimate row count from asktom

2003-12-30 Thread ryan_oracle
: 2003/12/30 Tue PM 01:29:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re: help with estimate row count from asktom Don't be afraid to access v$ views, just beware of the bug that throws a ora-600 when selecting 'filter_predicates' and 'access_predicates' under

Re: Re: help with estimate row count from asktom

2003-12-30 Thread Tanel Poder
Hi! Statistics level ALL means TYPICAL + row source execution stats + timed_os_statistics. If you want to switch to ALL for performance reasons, you can switch only row source stats on with parameter setting _rowsource_execution_statistics to true (on session level). But I doubt it'll help

please help with materialized view question

2003-12-26 Thread ryan_oracle
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Re: please help with materialized view question

2003-12-26 Thread ryan_oracle
). You may also send the HELP command for other information (like subscribing).

Re: please help with materialized view question

2003-12-26 Thread Thomas Day
Subject: please help with materialized view question

Re: Re: please help with materialized view question

2003-12-26 Thread ryan_oracle
I figured it out. I need some help with query re-write. Im not sure its possible. My materialized view joins 3 tables on the primary key/foreign key. I have a query that would join that materialized view to a third transactional table, but that join is not on any primary key or foreign key. I

Re: please help with materialized view question

2003-12-26 Thread Jared . Still
ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: please help with materialized view question I figured it out. I have another problem. I create my materialized view. I now want to write a query that joins it to a transactional table. I want to use query rewrite. Problem is the join

Re: Re: please help with materialized view question

2003-12-26 Thread ryan_oracle
, then the materialized view needs to be reloaded. This could take a little while. From: [EMAIL PROTECTED] Date: 2003/12/26 Fri PM 02:09:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: please help with materialized view question Warning: I have not actually used query

Re: Re: please help with materialized view question

2003-12-26 Thread Jonathan Lewis
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 26, 2003 6:59 PM I figured it out. I need some help with query re-write. Im not sure its possible. My materialized view joins 3 tables on the primary key/foreign key. I have a query

List please help

2003-12-24 Thread bulbultyagi
). You may also send the HELP command for other information (like subscribing).

Ignore: List please help

2003-12-24 Thread bulbultyagi
send the HELP command for other information (like subscribing).

Re: List please help

2003-12-24 Thread Jared Still
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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Help on tkprof output

2003-12-02 Thread jaysingh1
') 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).

Re: Help on tkprof output

2003-12-02 Thread zhu chao
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.net -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Help on tkprof output

2003-12-02 Thread Biddell, Ian
') 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.net -- Author: Biddell, Ian INET: [EMAIL

Re: Help on tkprof output

2003-12-02 Thread Wolfgang Breitling
: 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).

RE: Help on tkprof output

2003-12-02 Thread Sami
PROTECTED] (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

RE: Help on tkprof output

2003-12-02 Thread Mark Richard
: Sent by: Subject: RE: Help on tkprof output [EMAIL PROTECTED

bad SQL day...help please

2003-11-27 Thread Saira Somani-Mendelin
PROTECTED] (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).

Re: bad SQL day...help please

2003-11-27 Thread Stephane Faroult
') 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). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ

Re: bad SQL day...help please

2003-11-27 Thread Wolfgang Breitling
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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L

AW: Looking for help - sql*loader and truncate

2003-11-14 Thread Stefan Jahnke
: Looking for help - sql*loader and truncate In that case you could create a procedure owned by the data owner that does the truncate, grant execute on the procedure to the data loader, and use SQL*Plus to call the truncate procedure before the SQL*load starts. -Original Message- Stefan

Help needed -- Replication and DBMS_JOB

2003-11-14 Thread jaysingh1
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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

RE: Help needed -- Replication and DBMS_JOB

2003-11-14 Thread Stephane Faroult
list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Re: RE: Help needed -- Replication and DBMS_JOB

2003-11-14 Thread jaysingh1
yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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

AW: Looking for help.

2003-11-13 Thread Stefan Jahnke
PROTECTED] Gesendet: Mittwoch, 12. November 2003 18:24 An: Multiple recipients of list ORACLE-L Betreff: Re: Looking for help. There are two options to replace all data in the table: REPLACE and TRUNCATE which are equivalent to truncate and delete sql statements. If you have staging tables without RI

AW: Looking for help.

2003-11-13 Thread Stefan Jahnke
err, should be Win2k, even though it feels like Win0.5k sometimes ;). Stefan -Ursprüngliche Nachricht- Von: Nelson, Allan [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. November 2003 14:49 An: Multiple recipients of list ORACLE-L Betreff: RE: Looking for help. Windows 3000

AW: Looking for help.

2003-11-13 Thread Stefan Jahnke
. Stefan -Ursprüngliche Nachricht- Von: Rachel Carmichael [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. November 2003 18:45 An: Multiple recipients of list ORACLE-L Betreff: Re: Looking for help. yeah but... if you attempt (as I do) to isolate the schema owner from the users which have

More help with TKPROF

2003-11-13 Thread Barbara Baker
waited on sql*net message to client. Is this coincidence, or can I make some correlation here? Thanks so much for your patience and your help. Database is 8.1.7.4 on Solaris 8. Barb SELECT PAPER, PAGE, PAGENAME, PAGENO, COLUMNS, COLWIDTH, COLSPACE, HEIGHT FROM PAGE call count cpu

Re: More help with TKPROF

2003-11-13 Thread Mladen Gogala
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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

RE: More help with TKPROF

2003-11-13 Thread Cary Millsap
. Is this coincidence, or can I make some correlation here? Thanks so much for your patience and your help. Database is 8.1.7.4 on Solaris 8. Barb SELECT PAPER, PAGE, PAGENAME, PAGENO, COLUMNS, COLWIDTH, COLSPACE, HEIGHT FROM PAGE call count cpuelapsed disk query

Re: More help with TKPROF

2003-11-13 Thread Jared . Still
PROTECTED] 11/13/2003 07:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:More help with TKPROF List: My apologies. Seems like I'm taking up more than my share of bandwith. I'm doing major battle with a vendor

RE: Looking for help - sql*loader and truncate

2003-11-13 Thread Jacques Kilchoer
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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

Fwd: Looking for help.

2003-11-12 Thread Jonathan Gennick
and the web. I am running out of sources. I hope you can help me with the following questions. We are using Oracle 9i sqlldr, direct path to load data from external files into staging tables. After data is loaded, we invoked stored procedures to transform data and move them to the target tables

AW: Looking for help.

2003-11-12 Thread Stefan Jahnke
Gennick [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. November 2003 14:34 An: Multiple recipients of list ORACLE-L Betreff: Fwd: Looking for help. I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears

RE: Looking for help.

2003-11-12 Thread Nelson, Allan
eMail occured so far. The platform is Oracle 9.2.0.3 on Win3k. Regards, Stefan -Ursprüngliche Nachricht- Von: Jonathan Gennick [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. November 2003 14:34 An: Multiple recipients of list ORACLE-L Betreff: Fwd: Looking for help. I don't usually

Re: Fwd: Looking for help.

2003-11-12 Thread Jonathan Gennick
] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files

Re: Looking for help.

2003-11-12 Thread Mladen Gogala
-Ursprüngliche Nachricht- Von: Jonathan Gennick [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. November 2003 14:34 An: Multiple recipients of list ORACLE-L Betreff: Fwd: Looking for help. I don't usually forward my reader email to the list, but the question below strikes me as rather

Re: Fwd: Looking for help.

2003-11-12 Thread Daniel Fink
hope you can help me with the following questions. We are using Oracle 9i sqlldr, direct path to load data from external files into staging tables. After data is loaded, we invoked stored procedures to transform data and move them to the target tables. The steps are: 1. delete all entries from

Re: Fwd: Looking for help.

2003-11-12 Thread Denny Koovakattu
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Re: Fwd: Looking for help.

2003-11-12 Thread Ron Rogers
, 2003, 1:07:41 AM, JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr

Re: Fwd: Looking for help.

2003-11-12 Thread Daniel Fink
: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables. After data is loaded, we invoked stored procedures to JG transform data

Re: Looking for help.

2003-11-12 Thread Yechiel Adar
: Fwd: Looking for help. I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone

Re: Looking for help.

2003-11-12 Thread Rachel Carmichael
: Jonathan Gennick [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. November 2003 14:34 An: Multiple recipients of list ORACLE-L Betreff: Fwd: Looking for help. I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL

Re: Fwd: Looking for help.

2003-11-12 Thread Ron Rogers
PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from

Re: Fwd: Looking for help.

2003-11-12 Thread Yong Huang
Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables

Help Interpreting TKProf

2003-11-12 Thread Barbara Baker
GOAL: ANALYZED (RANGE SCAN) OF 'I_CLO1' (NON-UNIQUE) 82 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'CLASS' 164 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'I_CLA1' (UNIQUE) Thanks for any help. Barb __ Do you Yahoo!? Protect your

Re: Fwd: Looking for help.

2003-11-12 Thread Daniel Fink
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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

  1   2   3   4   5   6   7   8   9   10   >