RE: Using the /*+ append */ insert hint

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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network

RE: LMT monitoring

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://www.orafaq.net -- Author: Toepke, Kevin M

RE: LMT monitoring

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: LMT monitoring

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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: LMT monitoring

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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: LMT monitoring

: http://www.orafaq.net -- Author: Toepke, Kevin M 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

RE: How to improve queries remotely

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Toepke, Kevin M 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 Reliable is Explain Plan in 9.2

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://www.orafaq.net -- Author: Toepke, Kevin

RE: How Reliable is Explain Plan in 9.2

Title: Message As far as I can tell, the Explain Plan is 100% reliable. It shows how the query would execute if it was run from that session at that momement in time. If you want to see how a query in the SGA actually ran, query the Oracle9i v$sql_plan view. Kevin -Original

RE: Optimizer help, get query to run as good as with RULE hint

: Toepke, Kevin M 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 an E

RE: Re: parallel index creation again:in which case, can we use p

ORACLE-L FAQ: http://www.orafaq.net -- Author: Toepke, Kevin M 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: parallel index creation again:in which case, can we use p

-- Author: Toepke, Kevin M 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

RE: Count(*) last 30 seconds

: 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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services

RE: Oracle 9i new features survey

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Multiple block sizes in 9i

Using transportable tablespaces to move data from the operational database to the ODS or warehouse is one. -Original Message-From: Jos [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 8:14 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes in

RE: slowish query causing problems...

Title: slowish query causing problems... Ouch! I hate to see queries written this way...the query should answer the question you are trying to ask. It appears you are checking for the existance of a record in fwepcode1 that matches the criteria. If I understand the query correctly, you

RE: corrupted database

Title: corrupted database We had a situation where the filesystems were cross mounted. You know /ora1234 mapped to the same physical disks on the EMC array as /ora3253 filesystem! Luckily we weren't in production! -Original Message-From: Koivu, Lisa [mailto:[EMAIL

Happy Holidays

: http://www.orafaq.net -- Author: Toepke, Kevin M 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

RE: Oracle 9.0.1 and 9.2

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

RE: To_Number

Title: To_Number My guess is that you have leading or trailing spaces. try select to_number(LTRIM(RTRIM(unit_cost)),'$999,999,999.99') from elas.qdr -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 2:24 PMTo: Multiple

RE: Oracle is a time machine!!

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Oracle is a time machine!!

-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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Invalid Objects but no errors

: Toepke, Kevin M 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: database link tuning

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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: SQL Brain Teaser Challenge

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: sqlplus /nolog

Title: sqlplus /nolog It doesn't? $ sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 29 10:39:53 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the

RE: SQL Joins vs Sub Queries vs Cursors

(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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: No Nulls? (was: Warehouse design: snowflake vs star schem

Title: Message Use your friendly FBI (function-based indexes) create index my_fbi on my_table ( nvl(end_employment, TO_DATE('01-jan-4000')); Then the following select will use the index. select * from table where NVL(END_EMPLOYMENT,TO_DATE('01-jan-4000')= to_date('01-jan-4000');

RE: RE: Re[2]: No Nulls? (was: Warehouse design: snowflake vs

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://www.orafaq.com -- Author: Toepke, Kevin M

RE: MIcrosoft Blackmail

Title: OT: MIcrosoft Blackmail I view a RD project not as"adding value to thebusiness", buttraining for myself. Everytime I have participated on an RD project I have learned a significant amount and have gained invaluable experience! If you go in expecting to throw away all of your

User / Synonym Question

: Toepke, Kevin M 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: User / Synonym Question

. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: User / Synonym Question

. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED

Invitation: OOUG Meeting: October 24th, 2002. Dual Track Meeting

. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: bind variables

last_name from emp where last_name = var; end; If that's the case, I wont have to change much code. mkb --- Toepke, Kevin M [EMAIL PROTECTED] wrote: Actually its easy. Any variable declared in PL/SQL and referenced in a non-dynamic SQL statement is a bind variable. In the following example

RE: bind variables

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

RE: Same SQL statement, Same Oracle, Different OS == Different E

Title: RE: Same SQL statement, Same Oracle, Different OS ==> Different Expla I the RBO, the order the indexes were created in is important! I was able to show this to management on a project I was on. How? By doing a difinitive proof (follows) Import the table and data into an empty

RE: open cursors problem

, 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: Toepke, Kevin M INET: [EMAIL PROTECTED

RE: Explain Plan and SQL Text Length

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

RE: bind vars change explain plan

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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Rant-Rant

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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services

RE: peopleslop HR question

Joe on previous PS HR implementations (versions through PS 7.1) the answer is no. In fact there was no encrypted data in the system. Kevin -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 18, 2002 12:34 PMTo: Multiple recipients of list

RE: a couple of questions

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.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED

RE: RE: a couple of questions

) to say they have every feature as M$ 2) to support 3rd party vendors porting stuff from M$ Kevin -Original Message- Sent: Wednesday, July 17, 2002 1:35 PM To: Toepke, Kevin M; Multiple recipients of list ORACLE-L Kevin, Looks messy to me, and damned confusing to boot

RE: external authentication

Don't do it unless the application is running locally on the same physical server as the database. It is (or at least was) extremely easy to break into a system that uses external authentication across a network. (...don't ask:) The following example shows how to connect to the PLAY

RE: Oracle 9.2 spfile catch 22

, Kevin M 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, send an E-Mail

Oracle Warehouse Builder

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

RE: runInstaller -- Linux help?

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: 2003 IOUG Meeting

://www.orafaq.com -- Author: Toepke, Kevin M 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

RE: Upgrade from 9.0.1.2 - NOPE!

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

RE: Count rows in textfile

: 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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services

RE: Alternative to Crystal Reports

') 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.com -- Author: Toepke, Kevin M INET: [EMAIL

RE: Sql loader question

: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: set command

Title: RE: set command Here is what I use. It wraps at the 32768th character. SET PAUSE OFFSET TRIMSPOOL ONSET TRIMOUT ONSET TERMOUT OFFSET PAGESIZE 5SET LINESIZE 32767 -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 2:09 PMTo:

RE: Asinine security in Oracle, Part Deux

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: why so much slower

I'll betyou are running...Oracle...8.1.6. Right? If so, the solution is SELECT /*+ NO_MERGE(x) HASH(st) */ * FROM (your 2 table join) x ,small_table st WHERE x.fk = st.pk; -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 05,

DataWarehouse Design Training

this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M

RE: SQL*Loader question

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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: 9iR2 Install Problem

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

RE: So, What is a 'Production DBA'?

as hammers and everything revolves around the code. As an ex-developer, now DBA, I know that sometimes you need a screwdriver (or a Harvey Wall Banger). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services

9iR2 Install Problem

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

Rename Column in 9iR2

. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: 9iR2 Install Problem

-- Author: Toepke, Kevin M 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

RE: Rename Column in 9iR2

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

RE: DB Freeze

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 clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M

RE: Order rows

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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: {9i New Features: Online Reorg or DBMS_REDEFINITION Package}

A quick followup to this... I've done some testing of this package and concur with Joe. Its kewl. Outside of renaming a column, it can be used to quickly partition a non-partitioned table. Its much faster and easier than using exchange partition. The 9iR2 new features whitepaper hints at a

Oracle 9iR2 Relase date

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

Password Checking

://www.orafaq.com -- Author: Toepke, Kevin M 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

RE: 9i Release 2 features/fixes

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

RE: Partitoned Table Insert Performance

would be quite visible. Do you have any thoughts or experiences with this issue. Any performance tests on two similar tables, one partitioned and the other not? Any input would be appreciated. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M

RE: Slow select distinct

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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Partitioning Quandry

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

RE: Partitioning Quandry

or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET

RE: What block size are you using for your new 9i data warehouse?

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

RE: Is sqlplus too slow to unload data?

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

RE: Currval and buffer gets

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Currval and buffer gets

://www.orafaq.com -- Author: Toepke, Kevin M 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

RE: Currval and buffer gets

: 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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services

RE:

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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City

RE: function based index

the query_rewrite_enabled init.ora parameter has to be set properly. -Original Message-From: Big Planet [mailto:[EMAIL PROTECTED]]Sent: Monday, April 22, 2002 4:15 PMTo: Multiple recipients of list ORACLE-LSubject: function based index I have created a function based

RE: Upgrade 8.0.5 to 8.1.7.3

. - The Xtals -Original Message- From: Toepke, Kevin M [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Upgrade 8.0.5 to 8.1.7.3 Jack: First of all, there are some serious problems with 8.1.7.3 that can cause

RE: Design question...

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

RE: SQL statement with hints or without hints (LONG)

Using RBO is unnecessary if you are using Oracle8 v8.0 or above. The CBO outperforms RBO in any situation except queries against the data dictionary (because you cannot analyze the data dictionary). Never say never and Never say always. I have found the above statement to be true

RE: recordset as argument

In Oracle 8.x you can pass in a INDEX BY Table, Varray, etc. In Oracle 9i a procedure can accept a REF CURSOR as an input parameter. Caver -Original Message-From: Shishir [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 04, 2002 8:08 AMTo: Multiple recipients of list

RE: recordset as argument

(or resultset) in REF CURSOR. With Regards Rakesh Banerjee From: Toepke, Kevin M [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: recordset as argument Date: Thu, 04 Apr 2002 05:33:26 -0800 In Oracle 8.x you can pass in a INDEX BY Table

RE: Oracle From a Sybase DBA perspective| What is a Database to S

Here is the URL for the PRO*C code to dump data from a query to a flat file. http://asktom.oracle.com/pls/ask/f?p=4950:8:646297::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:459020243348,%7BSQLDA%7D -Original Message- Sent: Monday, April 01, 2002 11:10 AM To: Toepke, Kevin M; '[EMAIL

RE: Oracle From a Sybase DBA perspective| What is a Database to S

') 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.com -- Author: Toepke, Kevin M INET: [EMAIL

RE: Oracle From a Sybase DBA perspective| What is a Database to S

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Pro-C differences VMS to Unix

One new thing you can do with PRO*C 8i is to use the The PREFETCH Precompiler Option if your application is processing a lot of data in a sequential manner (and you don't already do bulk fetches) Caver -Original Message-From: Stephen Andert [mailto:[EMAIL PROTECTED]]Sent:

RE: bulk collect in 9i

-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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Customize my SQLPlus login

') 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.com -- Author: Toepke, Kevin M INET

RE: Snapshots VS Materiazlized Views

') 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.com -- Author: Toepke, Kevin M INET

RE: local partition index question

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Non-partitioned table to Hash Partitioned table

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

RE: Non-partitioned table to Hash Partitioned table

. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: Non-partitioned table to Hash Partitioned table

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

Non-partitioned table to Hash Partitioned table

. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: cost based optimizer

Title: cost based optimizer John: The Cost of a query is based on Oracle's estimation of the number of datablocks that will have to be read in order to resolve the query. The Index-access Plan's cost is higher because Oracle is estimating that it will have to process more datablocks to

RE: CASE statement

myself. One way to work around this is to use EXECUTE IMMEDIATE in your PL/SQL so that the SQL engine must parse it. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

  1   2   >