RE: help with dynamic pl/sql

ERROR at line 1: ORA-06550: line 3, column 50: PLS-00103: Encountered the symbol "END" when expecting one of the following: . ( * @ % & = - + ; < / > at in mod not rem return returning <> or != or ~= >= <= <> and or like between into using is null is not || is

RE: oracle10g

See!  I was right!  A marketing spin!   I was thinking last night that 10G stands for how much it will cost to get certified.   Tom Mercadante Oracle Certified Professional -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 4:20

RE: Here comes Oracle10G

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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Physical Design Question

Title: Physical Design Question David,   You don't say but, I am assuming that all your databases are at the same Oracle Release level.  If this is the case, I would create one Oracle home for now - you can always create a new Oracle Home when you start considering migrating each individual

RE: how to schedule a job every alternate sundays in unix cron

RACLE-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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services--

RE: RAC or Oracle Fail Safe

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

RE: Antw: RE: Insert > 8000 Byte into LONG column

ED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http:/

RE: * Sr. Oracle DBA with 8i and 9i experience needed..

an Diego, California-- Mailing list and web hosting services ----- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, in

RE: Insert > 8000 Byte into LONG column

e 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: Mercadante, Thomas F INET: [E

RE: RE: should you seperate indexes from tables in seperate dataf

ould it be better to recovery without indexes first so the users will have some access to data, then build the indexes while the instance is online? > > From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> > Date: 2003/07/15 Tue AM 11:39:32 EDT > To: Multiple recipie

RE: should you seperate indexes from tables in seperate datafiles

of my indexes are NOT > comprised of all columns in the table) so I separate them for extent > size purposes as well. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services--

RE: should you seperate indexes from tables in seperate datafiles

faq.net -- Author: Mercadante, Thomas F 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: dbf and cdx files

AK,   do you think it would be easier to ask the person who sent you the file how it is formatted rather than asking us to guess?  tough for us to figure out what they are.   Tom Mercadante Oracle Certified Professional -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent:

RE: full usefulness of CURRENT OF ???

Title: RE: full usefulness of CURRENT OF ??? this is better than using rowid in the update clause   Tom Mercadante Oracle Certified Professional -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Friday, July 11, 2003 3:09 PMTo: Multiple recipients

RE: OEM tools

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Dieg

RE: ROWNUM is driving me nuts - queries suggested produced no res

[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACL

RE: import from 8i to 9i /IMP-00003:ORA-02298

Surendra,   Go back to the 8i database and run a query to see if parent records exist for all child records.  It sounds like your source database is bad.   Tom Mercadante Oracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent:

RE: unique constraint violation problem

sage 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: Mercadante, Thomas F INET: [EMAIL

RE: SQL*Loader problem - constraint violation

e 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.f

RE: error reading file

yeah, I see that error.  really sucks.   -Original Message-From: Shishir Kumar Mishra [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 02, 2003 6:16 AMTo: Multiple recipients of list ORACLE-LSubject: error reading file

RE: Re: 9i OCP Details

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

RE: SELECT Output Default Ordering ?

#x27;) 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: Mercadante, Tho

RE: Re: oracle docs do say # of extents effect performance

.fatcity.com > San Diego, California -- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

RE: how to handle client installs w/o admin privs

e 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Oracle releases by the different platforms...

Title: RE: Oracle releases by the different platforms... This story makes it sound like SCO is an attorney's office that specializes in scoring rainmaker lawsuits based on purchasing old rights to software.  Doesn't sound like a software company to me.  I'd be updating my resume if I was a S

RE: recreating a create database file

- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list

RE: 8i OCP Question

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

RE: Oracle Names

et -- Author: Mercadante, Thomas F 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 mai

RE: db file sequential read [WAS:wait event puzzler]

-- 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-Mail message to: [EMAIL PROTECTED] (note EXACT spelling

RE: Rule Based Optimizer

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

RE: Rule Based Optimizer

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

RE: How to pass string with a ' to PL/SQL

Lizz,   Remove the 'execute' from your PL/SQL block.  it is not needed - in fact - it is causing the error.   "Execute" is only needed within sqlplus when not using a PL/SQL block.  You are using an anonymous PL/SQL block to call your procedure.   Good Luck! Tom Mercadante Oracle Certified

RE: How to pass string with a ' to PL/SQL

Laura,   try it this way:      :b :='and sub_account_no=' || || '864240103' || ; remember - 4 quotes gets you one. Tom Mercadante Oracle Certified Professional -Original Message-From: laura pena [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 10, 2003 1:25 PMTo: Multipl

RE: dbms_stats via dbms_job - syntax question

ssage to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Pleas

RE: Cascading Triggers

Carol,   I see two possible issues here:   1).  Is the COL-2 value changing either from/to a null value?  if so, then the WHEN clause is incorrect and the Table B trigger will not fire at all.  In other words, if COL-2's before or after value is a NULL, then the trigger will not fire.  You s

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L F

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

--- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may a

RE: RE: Schedule Analyze using DBMS_STATS ???

nd web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORA

RE: cannot allocate new log

Milton Park Abingdon Oxfordshire OX14 4SH Phone: +44 (0) 1235 838151 Fax:+44 (0) 1235 838160 Direct Line: +44 (0) 1235 838147 ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTE

RE: Oradesigner9i ERD Diagrams

Tom, I've done this in the past by setting up a PostScript printer in windows, and sending the output to a file, then using the file to generate PDF's from GhostScript. HTH Jared "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/30/200

RE: Oradesigner9i ERD Diagrams

PROTECTED] -Original Message- Mercadante, Thomas F Sent: Friday, May 30, 2003 2:05 PM To: Multiple recipients of list ORACLE-L All, Does anybody know how to, instead of printing ERD diagrams to a printer, to send the output to an electronic file, preferrably something like a PDF or HTML format?

Oradesigner9i ERD Diagrams

dante, Thomas F 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: 10i

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

RE: Oracle Financials and IBM/AIX Platforms

anks Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

Oracle Financials and IBM/AIX Platforms

e how many users etc), but I'm just looking for a thnumbs up/down on the hardware for now. thanks Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services

RE: utl_smtp error

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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 ht

RE: Syntax for foreign key

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

RE: SQL Problem - Merging Result sets

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

RE: sort ip addresses

f '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 --

RE: sort ip addresses

  TO_NUMBER(SUBSTR(col1,INSTR(col1,'.',2)+1,INSTR(col1,'.',3)))     Tom Mercadante Oracle Certified Professional -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 25, 2003 2:44 PMTo: '[EMAIL PROTECTED]'Cc:

RE: sort ip addresses

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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-505

RE: Database Modeling- Normalization - Dinosaurs or What?

Title: RE: Database Modeling- Normalization - Dinosaurs or What? Of course, a star schema is better for a warehouse.  But I think your point and mine are the same.  A flat schema is good for nothing.   Tom Mercadante Oracle Certified Professional -Original Message-From: Stephane P

RE: Database Modeling- Normalization - Dinosaurs or What?

Title: RE: Database Modeling- Normalization - Dinosaurs or What? Paula,   Keep fighting for normalization.  Something almost all developers fail to recognize is the long-term use of the database - they only think in the "here and now" - they need to develop the application right now.  What th

RE: AW: Remove killed session from v$session

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

RE: Reorganizing tables

: 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City

RE: lsnrctl -utility, passing password in a command file

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F 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: How to run sql*plus and its command in Windows as b

file name will help us keep things straight. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, March 20, 2003 10:05 AM To: Mercadante; Thomas F; Multiple recipients of list ORACLE-L Thom, If your going to go to all that trouble, why not simply creat

RE: How to run sql*plus and its command in Windows as batch job

pelling 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 --

Veritas Software

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

RE: Autoallocate (was Re: LMT monitoring)

sage to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the

RE: insert stmt disk reads

How about foreign key constraints? - going to the parent table to see if the value exists.   Tom Mercadante Oracle Certified Professional -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, March 17, 2003 12:22 PMTo: Multiple recipients of list ORACLE-LSubject:

RE: Organizational Challenge - Data Management Team

d the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fa

RE: File Restoration/Recovery

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: Mercadante, Thomas F

RE: Corrected SQL Question...

or other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing lis

RE: A SQL Question

-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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Tablespaces - datafiles

0800 Tom, Do you have that doc ref handy? Using this SQL: create temporary tablespace temp3 tempfile '/u01/oradata/dv03/temp3.dbf' size 500m extent management local uniform size 1m / On both 8.1.7.0 and 9.2.0.1 on RH 7.2 I found that the file was immediately created full size. Pla

RE: temp table

.net -- Author: Mercadante, Thomas F 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 mailin

RE: UTL_FILE

Title: UTL_FILE Eric   Utl_file only write to the database server.  You can use Dbms_Output and spool the results to the local machine.  Or 'select' the data to be spooled out.   Hope this helps!   Tom Mercadante Oracle Certified Professional -Original Message-From: Harrington, Er

RE: Tablespaces - datafiles

00m extent management local uniform size 1m / On both 8.1.7.0 and 9.2.0.1 on RH 7.2 I found that the file was immediately created full size. Platform dependencies maybe? Jared "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/11/2003 06:19 AM

RE: Disable / enable constraints

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

RE: Running multiple instances on a [large] server

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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http:

RE: Tablespaces - datafiles

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

RE: ``SQL*Net message to client`` Wait event with no SQL*Net

Tim Gorman 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 a

RE: "SQL*Net message to client" Wait event with no SQL*Net connec

UB 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services

RE: Cannot delete datafile from O/S -- Help !!

command for other information (like subscribing). (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Mercadante, Thomas F (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, Californi

RE: show errors doesn't show anything ???

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

RE: Listener/Database shutdown sequence

/auto-shutdown procedures run by root. >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Listener/Database shutdown sequence >Date: Mon, 03 Mar 2003 09:04:11

RE: Listener/Database shutdown sequence

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

RE: Invalid column in table - how to access it?

') 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: Mercad

RE: Purely for your amusement

ling 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 --

RE: alertlog naming

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

RE: MTS config

ling 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,

(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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 8

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

l message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please s

RE: {SPAM?} RE: Teradata baned from IOUG???

) 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: Mercadante, Thom

RE: Plain Old Database

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: Mercadante, Thomas

RE: Send Mail in Unix - solved!

tbsp.lst` This is from an HP-UX system hth mohammed --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > All, > > I'm trying to send an email attachment (Oracle > Tablespace Report) from a Sun > Unix box to myself when the batch job runs. > > A

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

achieve a lot. thanks, steve "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/12/2003 02:23 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:

RE: Send Mail in Unix

ut what I > really want to do is to send the file (it's an Excel Spreadsheet). > > thanks in advance. > > Tom Mercadante > Oracle Certified Professional > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mercadante, Thomas F

RE: Send Mail in Unix

, but what I > really want to do is to send the file (it's an Excel > Spreadsheet). > > thanks in advance. > > Tom Mercadante > Oracle Certified Professional > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author:

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

(ie consumes little cpu) then you can achieve a lot. thanks, steve "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/12/2003 02:23 PM Please respond to ORACLE-L                 To:        Multip

Send Mail in Unix

ance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

RE: View HELP Please!

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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcit

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

----------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send t

RE: Rman and database shutdowns UPDATE

DY, 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: Mercadante, Thomas F INET: [EMAIL PRO

RE: Schema specific grants

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

RE: Breaking down values in a large table

John,   Have you looked at using the FILE and FILESIZE params that are provided via the Export utility?   According to the docs, you can provide multiple FILE names, and specify a FILESIZE.  Once Export has created a file that is FILESIZE in size, it creates the next export file you designat

RE: find out the backup time in RMAN

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

RE: RMAN: I don't trust it

Michael,   I use it.  I trust it.  Oracle support is there when needed.   When you say "While I can get RMAN to work for most simple, basic and predictable recovery scenarios, true recovery situations are never so neat and clean."   Just what do you mean?  Loss of individual tablespaces? 

RE: Retrieving Sets of Record via VB

ecting the range of records to return. Storing the result set > in a temporary/rollup table might also work. I obviously would need > to clear this table out every night. > > Any other ideas? > > thanks > > Tom Mercadante > Oracle Certified Professional > > -

<    1   2   3   4   5   6   7   8   9   10   >