Re: End of Roche contract

). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL

Off-topic postings

and entertainment is entertainment.) Thanks, everyone, and happy holidays to all. = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ

Re: rebuilding indexes - sure to cause a ruckus

in a number of emails (warning somewhat on the longish side ;): __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat

RE: View definition oddities

to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul

Verifying success of dbms_repcat.execute_ddl

master database (I am running a batch job that disables all FKs, then runs an import; the first attempt produced failures because the row insertions caused by the import arrived at the other master DB _before_ the FK disablement). Any help appreciated. TIA. = Paul Baumgartel Transcentive, Inc

RE: Copying stats between/amongst schemas

Steve, I've done this: first export the source schema's stats from the dictionary into a user table, then import from that user table into the dictionary for the target schema. (Use CREATE_STAT_TABLE to create the user table.) Paul Baumgartel --- Orr, Steve [EMAIL PROTECTED] wrote: I see

RE: Copying stats between/amongst schemas

in under the target schema owner user? I wanted to do this under a DBA account which doesn't own anything. alter session set current_schema=Doh / -Original Message- Paul Baumgartel Sent: Tuesday, December 02, 2003 5:34 PM To: Multiple recipients of list ORACLE-L Steve, I've

RE: Any articles/books that take relational theory and make it

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

Re: FW: SAN configuration for Banner

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

RE: SQL Query

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

Re: Logical StandBy question

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

RE: Re: Logical StandBy question

AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: shareplex: datatype unsupported

') 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). = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do

Re: How do you genrate primary keys?

subscribing). === message truncated === = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http

Function calls, queries, and trace files

)? TIA = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul

Re: database terminated

] (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). = Paul Baumgartel Transcentive, Inc

Re: PCTFREE and PCTUSED

PCTUSED, didn't you? = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

tim= values in Windows 2k / Oracle 9.2.0.4 trace files

values on Linux, so that would be, what, tenths of nanoseconds???). And I guess the Windows epoch is not the same as the Unix epoch (perish the thought). Has anyone figured out how to convert these to wall clock time values? TIA = Paul Baumgartel Transcentive, Inc. www.transcentive.com

RE: 10046 level 8 trace - help required with 'direct path write'

you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: dba interview questions

://ads.arabia.com/?SHT=text_email_english Access MILLIONS of JOBS NOW! __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul

RE: oracle internet directory

subscribing). = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul

Re: 10046 trace data question--addendum

__ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: 10046 trace data question

. **5 __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services

Unaccounted-for elapsed time

a couple of function calls...does the elapsed time here include the waits that the function calls might cause? I have 24 seconds of elapsed that aren't accounted for. TIA, = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo

Re: VPN to database?

, and integrity. Anyone have experience using this? We are considering using Entrust SSL authentication as we already use Entrust to authenticate users of our app. Would Advanced Security replace a VPN, or coexist with it? = Paul Baumgartel Transcentive, Inc. www.transcentive.com

RE: VPN to database?

/firewall/VPN/Oracle Net) might make such access possible. TIA, = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com

RE: VPN to database?

Never mind, I see that it is. Thanks. --- Paul Baumgartel [EMAIL PROTECTED] wrote: Jared, Is that the book from sans.org? Thanks, Paul --- Jared Still [EMAIL PROTECTED] wrote: Yes, I will ditto the recommendation for Pete Finnigan's book. Jared On Fri, 2003-10-24 at 10

VPN to database?

of configuration (network/firewall/VPN/Oracle Net) might make such access possible. TIA, = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see

RE: VPN to database?

Entrust to authenticate users of our app. Would Advanced Security replace a VPN, or coexist with it? = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com

RE: Cary's book[Scanned]

Sure, I can take it. ;-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: you REALLY want an answer to that? --- Paul Baumgartel [EMAIL PROTECTED] wrote: --- Bob Metelsky [EMAIL PROTECTED] wrote: [snip] Its funny, I attended the recent NYOUG (Rachael where were you???g

RE: Cary's book[Scanned]

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

RE: OFA myths was Re: BAARF

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

Re: Describe privilege on procedures packages

information (like subscribing). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City

Re: (long and boring) SQL AREA and LIBARARY CACHE size?

!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Off Topic: PC Firewall Recommendation

but it is not the greatest. Thanks much, Ken Janusz, CPIM __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET

Re: Reality check for filesystem/disk layout

Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat

Re: 10g: SQL Plus

://www.orafaq.net -- Author: Paul Baumgartel 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: how can I see which database I am logged into without

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

alert log for physical standby?

I've created a physical standby database that seems to be performing properly, but there's no alert log in user_dump_dest, nor anywhere else on the machine. Is there no alert log until/unless the standby undergoes a role transition? TIA = Paul Baumgartel Transcentive, Inc

Re: Tough Oracle DBA experience

. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Multiple parses with bind variables

--- -- -- -- -- -- Parse 1890 0.21 0.17 0 0 0 Execute945 0.04 0.08 0 0 0 Fetch 945 38.48 43.24 0 620428 0 = Paul Baumgartel Transcentive, Inc

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

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

Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

Wow--that one sent me scrambling to Google. Nice riposte! --- Stephane Faroult [EMAIL PROTECTED] wrote: Paul Baumgartel wrote: A couple of corrections are in order here. First, some Christians might object to your characterizing the Holy Trinity, et. al. as mythology. I don't

Multiple parses with bind variables

0.21 0.17 0 0 0 Execute945 0.04 0.08 0 0 0 Fetch 945 38.48 43.24 0 620428 0 = Paul Baumgartel Transcentive, Inc. www.transcentive.com

Re: Partitioning

site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: oracle logical standby

the 9.2.3 doc. I really appreciate for your help. Joan Paul Baumgartel wrote: We were going to use logical standby but quickly abandoned the idea after testing. 1. The APPLY process on the standby crashed regularly (every 10 minutes or so). Oracle claimed it was a fixed bug

RE: Oracle to MSSQL conversion?

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

Re: oracle logical standby

= Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul

RE: Oracle to MSSQL conversion?

- Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Oracle to MSSQL conversion?

=== __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: 9i-OCP Question

IT Extension 8487 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network

RE: logon trigger to start tracing

as user X: trace file created logon as user Y: no trace file created logon as user Y, say alter sesssion set current_schema = X ; no trace file created No error messages in alert log -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED] In an attempt to catch

Re: logon trigger to start tracing

That's it! Thanks...sometimes I forget that a trigger is a stored object, too. Regards, --- Wolfgang Breitling [EMAIL PROTECTED] wrote: The logon user needs to have granted alter session privileges directly to her, not just through a role. = Paul Baumgartel Transcentive, Inc

RE: logon trigger to start tracing

://www.orafaq.net -- Author: Paul Baumgartel 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

logon trigger to start tracing

privileges ORA-06512: at SYS.DBMS_SESSION, line 126 ORA-06512: at line 2 When SQL statements are executed in the session, no further trace information is added to the file. Anyone know what's going on here? TIA = Paul Baumgartel Transcentive, Inc. www.transcentive.com

Re: Oracle has out-smarted me again.

is? Paul Baumgartel treegarden To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @yahoo.com

Re: Oracle has out-smarted me again.

. = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED

Re: Oracle has out-smarted me again.

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

High availability and upgrades

be interested in hearing of any experiences from those who have the same or similar requirements. Paul Baumgartel __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Re: High availability and upgrades

experiences from those who have the same or similar requirements. Paul Baumgartel __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul

RE: High availability and upgrades

, the two nodes continue to run against two mirrored copies, correct? Thanks! Paul Baumgartel --- Matthew Zito [EMAIL PROTECTED] wrote: [snip] What about a storage-level solution? Either at the software (i.e. Veritas) or hardware (i.e. your big honkin' storage array) level, have a third mirror

Re: Logical standby?

Even some of the MetaLink papers are buggy--I was advised to rely on the 9.2.0.2.0 docs. --- Stephane Faroult [EMAIL PROTECTED] wrote: Paul Baumgartel wrote: OK, I'm going to aim a little lower: is _anyone_ using Logical Standby? Any tips, gotchas, implementation accounts to share

Logical standby?

OK, I'm going to aim a little lower: is _anyone_ using Logical Standby? Any tips, gotchas, implementation accounts to share? TIA = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95

RE: RMAN Recovery Question: Restore with loss of control files an

). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: Logical standby

here? ;-) --- Paul Baumgartel [EMAIL PROTECTED] wrote: I have successfully (on the third attempt) gotten a logical standby database up, running, and applying changes from the primary. However, I quickly ran into a problem, and I'm wondering if anyone else has seen it. On the primary, I

Re: WHY IT DOES NOT WORK == rman target / as sysdba THANKS

). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: printing out of Pl/SQL

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

Re: Oracle 9.2 RAC on Win2K?

information (like subscribing). = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Re: Passing array as input to procedure from sqlplus-HELP

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

Re: World premier performance of the BAARF party logo

information (like subscribing). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City

RE: Oracle Names

the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET

Memory strangeness on Win2k

the instance, but any other ideas would be appreciated. I really prefer running Oracle on Unix. TIA, Paul Baumgartel __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORACLE-L

DBA ignorance (was Win2k memory weirdness)

://www.orafaq.net -- Author: Paul Baumgartel 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

OEM jobs on Win2K

Hi all. I've just entered the world of Oracle on Windows. My first question regards the mechanism used to run jobs that are created using OEM.How does OEM execute RMAN, or export, for example? Thanks Paul Baumgartel __ Do you Yahoo

Re: High current mode buffer gets on insert

I thought I'd repost to see if I could get a response. Anyone? --- Paul Baumgartel [EMAIL PROTECTED] wrote: I'm looking at a client's tkprof output, showing among other things that the insertion of about 135,000 rows taking 450 seconds of CPU, and with current mode buffer gets numbering

High current mode buffer gets on insert

. Am I correct in concluding that the high CPU, and especially the current mode block gets numbering over 6 times the number of rows inserted, are due to index updates? Thanks! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED

FalconStor and Oracle performance

who's worked with FalconStor or similar products and can suggest other things to investigate. TIA, Paul Baumgartel __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ

RE: Where is result set maintained?

form does Oracle maintain the result set, and where? TIA Paul Baumgartel __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Where is result set maintained?

When one executes a query, the result set is identified. Fetching the rows in the result set can be done over a period of time. In what form does Oracle maintain the result set, and where? TIA Paul Baumgartel __ Do you Yahoo!? Yahoo! Mail Plus

Re: Replication..

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

Re: Common PL/SQL package to truncate tables

' __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: Oracle Advanced Replication

://www.orafaq.com -- Author: Paul Baumgartel 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

Re: Slow Inserts

and s.sid = sid order by se.time_waited / Run this before and after executing the insert statement, and compute the delta for each wait event seen. HTH Paul Baumgartel --- [EMAIL PROTECTED] wrote: Oracle 8.1.7.0.0 on Win2k (4 CPU, 4GB RAM) A 3rd Party app. is experiencing very slow performance

Re: Invalid Objects but no errors

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

Re: blast from the past

the large reel-to-reel tapes in my hand. As I recall, the project never got off the ground, to my chagrin. Imagine allowing a single developer to choose a language that way now! Paul Baumgartel --- [EMAIL PROTECTED] wrote: Things seem a little slow on the list ( like I need more email

RE: SQL*Plus COPY error solved (sort of)

: Paul Baumgartel 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 this mailing list, send

Re: Joseph Testa has sent you a 10% discount]

may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel

SQL*Plus COPY error

! __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

SQL*Plus COPY error solved (sort of)

This COPY script failure occurred when running in SQL*Plus on Windows NT. In SQL*Plus on (Unix) database server, runs just fine, so immediate problem solved. Shouldn't it work from PC, though? --- Paul Baumgartel [EMAIL PROTECTED] wrote: I'm trying to use (for the first time in 15 years

PDBA toolkit (from Perl for Oracle DBAs) question

variables such as ORACLE_HOME. But nowhere do I see how to use a SQL*Net connect string: I have PDBA installed on my PC, and I want to connect to databases on Unix servers; the service name resolution is provided by Oracle Names. What am I missing? Thanks, Paul Baumgartel

Re: Any way to see the currently running SQL in one session.

you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..

__ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: datafile sizing question

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

Satisfied customer

to the name! Paul Baumgartel __ Yahoo! - We Remember 9-11: A tribute to the more than 3,000 lives lost http://dir.remember.yahoo.com/tribute -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL

RE: Replication question

when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc

Re: Question about database and service name

[EMAIL PROTECTED] 809-565-3121 __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat

Re: waits vs. logons

logged on. __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Replication question

in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo

Library cache lock and library cache latch

session calls it constantly; the wait event references the library cache lock. I've seen waits on the library cache latch in similar situations (at least I think I have; my memory may be failing me!). TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED

ROWNUM strangeness?

WHERE ROWNUM 1000, the query returns 336 rows! I don't know the size of the entire result set (I'm running a count right now), but if the result set consists of at least 336 rows, shouldn't WHERE ROWNUM 50 return 49 rows? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL

  1   2   3   >