RE: Re: Snapshot too old during stress test... how to avoid

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

RE: Sum of Previous Record

-L FAQ: http://www.orafaq.net -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: IN or Exists --- performance issue

://www.orafaq.net -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: Best Practise for exception handling in PL/SQL

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

RE: Which is beter a cursor or a for loop?

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

RE: How to create two db-links within one schema when global_name

identified by pwd_hr using 'DB1'; create public database link DB1 (???) connect to shipping identified by pwd_shipping using 'DB1'; This is 8.1.7 on Solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lord, David - CSG INET: [EMAIL PROTECTED

RE: How to create two db-links within one schema when global_name

: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: PL/SQL help

2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: methodology to keep only certain programs to connect to

Joe You can use the sys_context function to get the auditing session id - select * from v$session where audsid = sys_context('USERENV','SESSIONID'); David Lord -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: 10 September 2002 16:58To: Multiple

ldap compatibility

. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: select count(*) = 0, select /*+ full(a) */ count(*) = 5227 ?

. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: patch url needed please.

is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat

RE: Is port 1575 the standard for any Oracle product?

Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Urgent : UTL file problem

I sent this on June 21st. Is this a record ;-) -Original Message- From: Lord, David - CSG [mailto:[EMAIL PROTECTED]] Sent: 13 August 2002 22:24 To: Multiple recipients of list ORACLE-L Subject: RE: Urgent : UTL file problem Rings a bell. Is the directory/file writable

RE: RE: Dba tools on NT

ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Shutdown Abort Damages Database!

of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David

RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS

Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS Paula I don't know Crystal reports so I'm not sure what you are trying to achieve, but... 1) If you're using 8i and can fix the number of bind variables (or don't need to use them at all) then native dynamic sql (NDS) is

RE: Urgent : UTL file problem

l ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To

RE: OT: plot by elitists confirmed...

GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Oracle Heterogenous Services

Yes its true, I've got it working to a sqlserver d/b.The performance I can't vouch for. IIRC you have to install ODBC drivers (not so easy on solaris, Merant do one, but its not free),do some mucking about with the listener and then create a database link to the ODBC d/b. Regards David

RE: shutdown abort / startup restrict / shutdown vs. shutdown imm

, 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.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED

RE: shutdown abort / startup restrict / shutdown vs. shutdown imm

Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate Couldn't agree with you more. I recently had a database fail to restart after a shutdown abort because the redo log got corrupted somewhere along the line. Ended up doing a full restore and roll forward. Admittedly,

RE: Oracle Text index question, somewhat urgent

. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Wrong Results Bug in Oracle 8.1.7.1

. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Oracle 32 Bit running on Solaris 64 Bit

. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Urgent: Prodution database recovery

Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Order rows

-- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

RE: DBMS_SHARED_POOL.KEEP

Um, why can't you do this... create or replace procedure pin_packages_defined assql_sentence varchar2(200);cursor_name INTEGER;rows_processed INTEGER;CURSOR tab_cur IS SELECT owner,object_name FROM arsiv.pin_aday_objeler;tab_row tab_cur%ROWTYPE;BEGINFOR tab_row IN tab_cur LOOP

RE: Customize my SQLPlus login

is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED

RE: Concatenating formated number and date doesn't work

. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Names server

. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET

RE: sql question

Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Create Database ... really dumb question

. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists