RE: create view using DBMS.SQL

2003-01-02 Thread Koivu, Lisa
Title: RE: create view using DBMS.SQL Is the create view privilege granted to the procedure owner? -Original Message- From: Donate Clothes [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Subject: create view using

RE: create view using DBMS.SQL

2003-01-02 Thread Koivu, Lisa
! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003 11:46 AMTo: Multiple recipients of list ORACLE-LSubject: RE: create view using DBMS.SQL Is the create view privilege granted to the procedure owner?

RE: ORA-1410 Silliness

2003-01-02 Thread Koivu, Lisa
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! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED

RE: functions/procedures and commits

2003-01-02 Thread Koivu, Lisa
Title: Message The behavior of this may have changed... but I have seen autocommit not work as advertised. Just my opinion but I think explicit commits are good practice, if nothing else just for ease of reading code. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259

RE: Automatic backup on Oracle 9i -- For Jared

2003-01-02 Thread Koivu, Lisa
Title: RE: Automatic backup on Oracle 9i -- For Jared Well if you want an answer from the experts on this list (or anyone, really - I fall into the 'shmo' category) it's best to ask a question in the clearest way possible... otherwise your emails may go directly to the delete folder. Ur

RE: ORA-1410 Silliness

2003-01-02 Thread Koivu, Lisa
The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Koivu, Lisa wrote: Vladimir, Thanks for your reply. I have tested the cursor. It does not include any bind variables. There are no broken rowids, as all objects passed analyze

RE: create view using DBMS.SQL

2003-01-02 Thread Koivu, Lisa
in DBMS_SQL within procedure. Do I need additional privilege. Please give me some hints. TIA Trung. SQL create or replace view mytest 2 as 3 select * from tbl_file_definitions; View created. SQL select count(*) from mytest; COUNT(*) -- 641 SQL From: Koivu, Lisa [EMAIL

RE: dbms_sql from stored procedure

2003-01-02 Thread Koivu, Lisa
Title: RE: dbms_sql from stored procedure Sarath, Go locally managed tablespace and forget about extent management. It's just not worth it. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original

ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
Title: ORA-1410 Silliness Hello all, 8.1.7, Windows 2000 SP2 Here's the error: * ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at ELVIS.CLEANUP_VEGAS_PK, line 1970 ORA-01410: invalid ROWID ORA-06512: at line 1 Has anyone seen this error before? I run into this error

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
? -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 6:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness Hello all, 8.1.7, Windows 2000 SP2 Here's the error: * ERROR at line 1: ORA

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
Title: RE: ORA-1410 Silliness Yea, yea, well... my environment here leaves a lot to be desired :) Heck my database isn't even being BACKED UP aside from the backups I scream for. Don't even ask. As an aside that I forgot to mention: I am not using FOR UPDATE OF in any of my procedures

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
Sounds like another Elvis sighting!! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 7:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness Hello all, 8.1.7, Windows 2000

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
Lisa, What is your cursor doing? Perhapsrow-migration is occuring thus causing the rowid to become invalid? Tom Mercadante Oracle Certified Professional -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 8:44 AMTo

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
PROTECTED]]Sent: Tuesday, December 31, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness How about posting the table structure and the lines around 1970 in the Elvis package. -Original Message-From: Koivu, Lisa [mailto:[EMAIL

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 10:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
?? Have you tried (or do you already) commit after each insert from the RAW table ?? I know that you would not think this could help , but buffers and such might get cleared on the commit . just a thought anyway. -Original Message-From: Koivu, Lisa [mailto:[EMAIL

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: ORA-1410 Silliness Do you perform an exchange partition in the code? An exchange partition does change row ids. One attachment (47k) Koivu, Lisa Lisa.Koivu@efair To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
in this note have been eliminated as a possible source of this error ? HTH Srini Chavali Oracle DBA Cummins Inc Koivu, Lisa [EMAIL PROTECTED]@fatcity.com on 12/31/2002 12:48:42 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

RE: ORA-1410 Silliness

2002-12-31 Thread Koivu, Lisa
Silliness dumb question -- did you extract the insert statement and run it in sqlplus? Does it run there or does it go boom as well? --- Koivu, Lisa [EMAIL PROTECTED] wrote: You asked for it. Here goes. It is partitioned on julian_run_date. Please don't hammer me about the design. I wasn't

RE: ORA-04031

2002-12-20 Thread Koivu, Lisa
Title: RE: ORA-04031 Hi David, I ran into this too. Try the following: 1. flush shared pool, re-execute 2. bounce database. IN addition if you search on this on Metalink you will find lots of info. HTH Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut

RE: RMAN, recatalog backup set

2002-12-20 Thread Koivu, Lisa
Yup - if you look at your 'backup to trace' file it says that all recovery manager information will be lost. -Original Message-From: Stephen Lee [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 9:39 AMTo: Multiple recipients of list ORACLE-LSubject: RE: RMAN,

corrupted database

2002-12-20 Thread Koivu, Lisa
Title: corrupted database Yes. Twice. First time - bad controller. It wrote CRAP in random spots throughout the database. We had to recover after the hardware was replaced. Second time - no idea. Oracle Support said they'd need mounds of info from the o/s and even then they may not be

RE: Logitech Give Away

2002-12-20 Thread Koivu, Lisa
Title: OT: Logitech Give Away LOL glad I'm not a Canadian "Canadian winners are required under Canadian law to correctly answer a time-limited mathematical question in order to receive the prize. " -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent:

RE: Happy Holidays!!

2002-12-20 Thread Koivu, Lisa
Title: RE: Happy Holidays!! Not until it comes back to Orlando. But when it does, I'll be there. I found the best way to deal with being in a nearly-all-male work situation is to become one of the guys. Of course I am very much a tomboy so this came naturally to me. This may not be the

Giving back Perl

2002-12-19 Thread Koivu, Lisa
Title: Giving back Perl Hello everyone - I've been trying to write more Perl lately and after showing my Perl mentor some of the stuff I had written over the last couple of weeks the first thing he said was why don't you give back to the community. So I figure if I offer up my latest

RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

2002-12-19 Thread Koivu, Lisa
Title: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB ASS Management? I'm snickering, I know it's juvenile humor, but... LOL! Let me tell you, my ASS is not on the Free List. And thrashing? I'll leave that one alone! Sorry everyone. Couldn't resist. Is it Friday yet...

RE: Informix backups

2002-12-18 Thread Koivu, Lisa
Title: RE: Informix backups by all means Gene, test it... and watch out for that boogeyman named Rman. Lisa Koivu Oracle Database Something. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Gene Sais [mailto:[EMAIL

RE: Methods to get DDL

2002-12-18 Thread Koivu, Lisa
Title: RE: Methods to get DDL Bob, TOAD (freeware version) will do it for you also. However, as far as scheduling something to run regularly, exp rows=n is the easiest. Lisa Koivu Oracle Datablackeye Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA

RE: Locally Partitioned Index

2002-12-16 Thread Koivu, Lisa
Title: RE: Locally Partitioned Index Like this? CREATE INDEX vegas_mart_date_of_sale_idx ON vegas_mart (date_of_sale, julian_run_date) local tablespace lrg_index_a / base table partitions reside in 3 different tablespaces. Lisa Koivu Oracle Databonehead Administrator Fairfield

RE: Parallel degree on tables and indexes

2002-12-16 Thread Koivu, Lisa
Title: RE: Parallel degree on tables and indexes Govind, a statement like 'use parallel = 4 for tables over 100,000 rows' is like saying drive to Iowa, go that way. The parallel degree should at least take into account the resources on your box. It can be larger than the number of CPU's

RE: SQL question avoiding 2 views and not in

2002-12-13 Thread Koivu, Lisa
Title: RE: SQL question avoiding 2 views and not in Hi Stephane, This may be more effort but have you considered having a security table to join to in the one view, instead of two views? Multiple views can really hose the optimizer, as I am sure you know. However adding a table then

RE: SQL question avoiding 2 views and not in

2002-12-13 Thread Koivu, Lisa
Title: RE: SQL question avoiding 2 views and not in Has anyone used context and fine-grained security? I seem to remember the performance hit was not minimal when using this functionality. -Original Message- From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] Sent: Friday, December 13,

RE: trapping errors from assignment of SQL*Plus Input Variables

2002-12-10 Thread Koivu, Lisa
Title: RE: trapping errors from assignment of SQL*Plus Input Variables Bill, is this an anonymous block you are talking about? Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From:

RE: trapping errors from assignment of SQL*Plus Input Variables

2002-12-10 Thread Koivu, Lisa
PM To: 'Koivu, Lisa'; '[EMAIL PROTECTED]' Subject: RE: trapping errors from assignment of SQL*Plus Input Variables yes - would it matter? -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 1:05 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED

arc destination odd behavior

2002-12-10 Thread Koivu, Lisa
Title: arc destination odd behavior Hi all - 8.1.7.2, Windows 2000 sp 2 I'm working on my backupexec implementation. For some odd reason the backup job that copies the arclogs to tape and deletes them off the disk (what BE calls an 'archive' job) wants to delete the directory too.

RE: arc destination odd behavior

2002-12-10 Thread Koivu, Lisa
... :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 3:15 PM To: Multiple recipients of list ORACLE-L Subject: arc destination odd behavior

RE: STATSPACK

2002-12-09 Thread Koivu, Lisa
Title: RE: STATSPACK Well did you look for the table that holds the data? Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Monday, December

RE: STATSPACK

2002-12-09 Thread Koivu, Lisa
Title: RE: STATSPACK Wow that does sound way cool Thanks for sending this Barbara. -Original Message- From: Barbara Baker [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: STATSPACK Seema: Head to Tim

RE: Parsing Column val

2002-12-09 Thread Koivu, Lisa
Title: RE: Parsing Column val Looks to me like you have to do this in pl/sql unless you can say something about the uniqueness of col1 and col2. Is there a primary key on the table? Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL,

RE: expert advice for separation of production from report databa

2002-12-09 Thread Koivu, Lisa
Title: RE: expert advice for separation of production from report databa You didn't say if you are looking at a separate box for your reporting db. Push for separate hardware, or else you won't be solving your problem. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259

RE: Parsing Column val

2002-12-09 Thread Koivu, Lisa
: OraCop [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 4:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: Parsing Column val Yes there is primary key on the table. --- Koivu, Lisa [EMAIL PROTECTED] wrote: Looks to me like you have to do this in pl/sql unless you can say

RE: sql tuning help

2002-12-06 Thread Koivu, Lisa
Title: RE: sql tuning help That is very wise advice. Don't touch production on Fridays has been a rule in previous shops I worked at. Happy Friday all! pow Lisa Koivu Oracle Database Supermom to 4 Boys. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063

RE: To_Number

2002-12-05 Thread Koivu, Lisa
Title: RE: To_Number Laura are you sure you aren't trying this with the quotes? See below SQL select * from testnum; COL1 --- $24,990.09 SQL select to_number('col1','$999,999,999.99') from testnum; select to_number('col1','$999,999,999.99') from testnum * ERROR at line 1:

RE: To_Number

2002-12-05 Thread Koivu, Lisa
.   I did this on an 8.0.5 and got the invalid number error running the exact query that succeeded on yours.  I had to do a replace on both the commas and the dollar sign. -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 1:55 PM To: Multiple

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Koivu, Lisa
Title: RE: Problem doing RMAN backup of Clone? Hi Doug, I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 5259 Coconut Creek

RE: how do I calculate the Oracle's usage

2002-11-25 Thread Koivu, Lisa
Title: RE: how do I calculate the Oracle's usage Hi Gene, Wouldn't top at least be a place to start? You could take snapshots of what's happening on top several times throughout the day and at least make a quick guesstimate from there. You could also look at sar - I forget which switch

BackupExec Oracle

2002-11-25 Thread Koivu, Lisa
Title: BackupExec Oracle Hello Everyone! I found out on Friday that my backup strategy has been NULL AND VOID out in Las Vegas. (Read: Nothing has been written to tape lately. Thanks, Guys) I was also notified that effective immediately Veritas BackupExec is the software we are using.

OT: Erwin - Does this thing work?

2002-05-06 Thread Koivu, Lisa
, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: ERD generation tool - Active SCM

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

RE: IN() question

2002-05-05 Thread Koivu, Lisa
: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: sysdate - 90 mins query

2002-05-04 Thread Koivu, Lisa
') 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: Koivu, Lisa

IN() question

2002-05-03 Thread Koivu, Lisa
Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: IN() question

2002-05-03 Thread Koivu, Lisa
Database Monkey Mama Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: IN() question

2002-05-03 Thread Koivu, Lisa
: http://www.orafaq.com -- Author: Koivu, Lisa 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: ERD generation tool - Active SCM

2002-05-02 Thread Koivu, Lisa
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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: pl/sql is INTERPRETED?

2002-05-02 Thread Koivu, Lisa
prefer Perl. Getting a handle on all of the libraries and API's is another story, but Java as a language is pretty simple. Jared On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: You have a point Chris, but pl/sql is nowhere near as complex as an OO language like java or C

RE: ERD generation tool - Active SCM

2002-05-02 Thread Koivu, Lisa
: 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services

RE: Does any one know how to call LDAP from UNIX script ?

2002-05-02 Thread Koivu, Lisa
') 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: Koivu, Lisa

RE: Database Normalization-Outdated?

2002-05-01 Thread Koivu, Lisa
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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Wierdness during script in SQLPlus

2002-05-01 Thread Koivu, Lisa
: Koivu, Lisa 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

RE: ERD generation tool - Active Comparisons

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

RE: ERD generation tool

2002-05-01 Thread Koivu, Lisa
') 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: Koivu, Lisa INET: [EMAIL

RE: pl/sql is INTERPRETED?

2002-04-30 Thread Koivu, Lisa
better is platform independence. You can run Java on your client, the apps server or database without a problem. PL/SQL on the other hand must be run in the database. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 4

RE: pl/sql is INTERPRETED?

2002-04-30 Thread Koivu, Lisa
Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 4/29/2002 2:52 PM Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow poke, Java)? I see

RE: CPU Pegged at 100%

2002-04-29 Thread Koivu, Lisa
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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network

RE: Oracle Financials Sys Admin. Needed in South Carolina

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

RE: Oracle Financials Sys Admin. Needed in South Carolina

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

PATCH?

2002-04-29 Thread Koivu, Lisa
How to give birth? Please advise. Thx. --Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

pl/sql is INTERPRETED?

2002-04-29 Thread Koivu, Lisa
: Koivu, Lisa 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

OT: How come I don't get postings

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

RE: index status misleading?

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

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

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

RE: How come I don't get postings

2002-04-26 Thread Koivu, Lisa
-- Author: Koivu, Lisa 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

OT: Job posting in Boca - possible relo

2002-04-24 Thread Koivu, Lisa
-- Author: Koivu, Lisa 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: Design question: EFFECTIVE_?_DATE in a RATE table...

2002-04-23 Thread Koivu, Lisa
') 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: Koivu, Lisa INET: [EMAIL

RE: data cleansing question

2002-04-22 Thread Koivu, Lisa
-Ursprüngliche Nachricht- Von: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 21. April 2002 12:48 An: Multiple recipients of list ORACLE-L Betreff: RE: data cleansing question Hi Yechiel, I'm aware of the NULLIF clause. However my strategy has been to bring the entire

OT: Windows Patches and Oracle

2002-04-22 Thread Koivu, Lisa
6) Security Update, February 13, 2002 (MSXML 3.0) Lisa Koivu Oracle Database Batgirl. Fairfield Resorts, Inc. Ft. Lauderdale, FL, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services

RE: data cleansing question

2002-04-21 Thread Koivu, Lisa
://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

ioug-a question

2002-04-21 Thread Koivu, Lisa
if that's what I'd have to do. Please include a reply to me directly, I don't know how much longer I'll be subscribed. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. Ft. Lauderdale, FL, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu

RE: EMC Storage Array Issue

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

RE: Training for Oracle 8i

2002-04-18 Thread Koivu, Lisa
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: Koivu

RE: Ang: Re:Import excelfile into Oracle table

2002-04-18 Thread Koivu, Lisa
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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: RAC

2002-04-18 Thread Koivu, Lisa
, 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat

RE: Reorganize table

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

OT: db2/udb and new skillz

2002-04-17 Thread Koivu, Lisa
down, feel free to reply to me directly. Peace, Oracle and Happiness, Lisa Koivu Oracle Database MONKEY MAMA Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services

RE: Locally managed tablespaces/What a DBA can do ?

2002-04-17 Thread Koivu, Lisa
AM To:Multiple recipients of list ORACLE-L Subject: RE: Locally managed tablespaces/What a DBA can do ? What about your locally managed temporary tablespace? --- Koivu, Lisa [EMAIL PROTECTED] wrote: What? I was just able to do it. 8.1.7, W2K (INV-SYSTEM

RE: Design question...

2002-04-17 Thread Koivu, Lisa
-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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: MySQL vs. Oracle database

2002-04-17 Thread Koivu, Lisa
: Koivu, Lisa 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

RE: Upgrade 8.0.5 to 8.1.7.3 (fwd)

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

RE: datafile sizing ?

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

RE: data cleansing question

2002-04-17 Thread Koivu, Lisa
nothing to me or to anyone else, as far as I can tell. Thoughts? Thanks everyone Lisa Koivu Oracle Database Hormone Dispenser. Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED

RE: Package/Procedure

2002-04-16 Thread Koivu, Lisa
]] Sent: Tuesday, April 16, 2002 3:25 PM To: Multiple recipients of list ORACLE-L Subject: Package/Procedure Is there a naming convention for procedures and/or packages? Thank you, Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET

OT: Cobol Zone Dec.

2002-04-15 Thread Koivu, Lisa
000366C 023057H 731 004286360 000259A 011834D Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: SQL statement with hints or without hints

2002-04-12 Thread Koivu, Lisa
. 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! File: ESPN_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu

RE: UTL_FILE limitation

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

RE: Archival Freeze

2002-04-12 Thread Koivu, Lisa
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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Selecting a variable similar to a column

2002-04-10 Thread Koivu, Lisa
://www.orafaq.com -- Author: Koivu, Lisa 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: Export taking to long

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

RE: Oracle 9i SE vs EE and options

2002-04-09 Thread Koivu, Lisa
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: Koivu

rman views one other rman question - long, sorry

2002-04-09 Thread Koivu, Lisa
of the backup piece that contains the archive logs? Thanks in advance for any pointers, websites, etc. Lisa Koivu Oracle Database Dog Catcher Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City

<    1   2   3   4   5   6   >