RE: WHERE 1 = 1 (any info on this)

city.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 the m

RE: anyone have opinions on the future of the 'grid'?

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.fat

RE: anyone have opinions on the future of the 'grid'?

fficial 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: anyone have opinions on the future of the 'grid'?

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

RE: What is difference between "SYSDATE" and "SYSDATE@!" ??

Uh. I think that SYSDATE works, while [EMAIL PROTECTED] does not.   Tom Mercadante Oracle Certified Professional -Original Message-From: Waleed Haggagy [mailto:[EMAIL PROTECTED]Sent: Thursday, October 16, 2003 12:20 PMTo: Multiple recipients of list ORACLE-LSubject: What

RE: anyone have opinions on the future of the 'grid'?

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 hostin

RE: 8.1.7 to 8.1.7.4 database migration - step 10 hangs

ou 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://www.fatcity.

RE: Passed Net8 OCP Exam

(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: Re: anyone have opinions on the future of the 'grid'?

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

RE: Table Size

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 P

RE: 8.1.7 Support Extension?

y 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, Californ

RE: ORA-02270: no matching unique or primary key for this column-

Lizz,   Are you sure that the PK was created on the CDR_TABLE?  It looks like it might fail because you first created a unique index on the table, then a PK and used the USING INDEX clause.  I would think that the PK would not be created because you cannot have two unique indexes on the same

RE: Data Modelling Tools for a DBAs Job

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

DbVerify Output

Title: RE: Concurrent Manager All,   We are in the middle of testing Tivoli Storage Manager and Rman here on a Sun Box.  After a restore, we ran DbVerify and got the following results:   DBVERIFY - Verification starting : FILE = /dba/u5000/osor/index_a/osos_indx301.dbf Block Checking: DBA =

RE: Using ' in Update statement

ww.orafaq.net -- Author: 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 your

RE: Temp Tablespace

ntaining: 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: vikas kawatra INET: [EMAIL PROTECTED] Fat City Network Se

RE: how to keep statistics up to date for CBO

CT 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: ht

Temp Tablespace

Title: RE: SAME and separating disk and index tablespaces All,   Is there a way to clear a TEMP tablespace defined as Temporary?  We had a couple of long-running jobs  that have totally clogged up the TEMP tablespace (54 Gig worth) and it doesn't seem to be releasing the space.  I know a db

RE: EMC Snapshot Technology

Gene,   What happens when you need to perform a recovery from the Flashcopy backup?  Is Flashcopy done while the database is open or closed? If the database is open, then I assume that you would need to perform an incomplete recovery? Just curious.  I am in the middle of setting up new IBM/

RE: how to keep statistics up to date for CBO

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-- Mailing list and

RE: interesting article...

Title: RE: RE: Cary's Book - new topic it is interesting.  but who knows if this person's opinions are correct.  should we start "shorting" Oracle stock?   -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 08, 2003 11:29 AMTo: Multiple re

RE: 11i Licencing Hel(l)p

Title: Message Kevin,   We just went thru a similar review.  Something that the sales rep said made sense:   If you buy the product and do not do any customizations of the 11i database which supports the product, then there is no additional charge.    If, however, you customize the produc

RE: how to send mail from windows command prompt?

rl, why not just use 'use Mail::Sendmail'? Jared "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  10/03/2003 06:50 AM  Please respond to ORACLE-L                 To:        Multipl

RE: how to send mail from windows command prompt?

r 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: LOB Storage

in a separate tablespace from the > table data. If I use an LMT tablespace, what should I use for the uniform > allocation size? Should I use 12,000 K or something larger to store one PDF > per segment? Am I all wrong here? > > thanks in advance > > Tom Mercadante > Oracle Cert

RE: OFA myths was Re: BAARF

CLE-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 R

LOB Storage

should I use for the uniform allocation size? Should I use 12,000 K or something larger to store one PDF per segment? Am I all wrong here? thanks in advance Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Tho

RE: Problems creading a Index

Teresita,   You cannot create a unique index on the combination of columns that you listed because there are more than one of those type of records.   You can see the problem if you do the following:   select  distinct COMPANY, INVC_PREFIX, INVC_NUMBER, ITEM, count(*) from OEINVCLINE group

RE: RE: interesting sql question

Title: RE: RE: interesting sql question yeah!  I think it *is* homework  :)   Tom      -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 2003 12:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: interesting sql question

RE: interesting sql question

lling 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.n

RE: DBA needed in Austin, TX

Title: Message ..note to selfdon't visit Austin during the months of May thru August.   -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 1:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: DBA needed in Austin,

RE: equivalent for isdate, isnumeric

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 me

RE: DBA needed in Austin, TX

Title: Message ummm.. if it's 100% humidity, doesn't that mean it's raining ..   or misting ..  or something?   I can't imagine it being 100degrees and raining.   -Original Message-From: Loughmiller, Greg [mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 11:25 AMTo:

RE: Hiding passwords

llozoffice - 401-232-1200  x200cell    - 401-935-2802 "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/23/2003 04:24 PM Please respond to ORACLE-L                To:        Multiple rec

RE: Oracle8i, Failsafe and patchset 12

Tim,   Just curious - is Patchset 12 for Windows 2000, or for Oracle?  Sorry if it's a dumb question, but I am lost in the context.   thanks!   Tom Mercadante Oracle Certified Professional -Original Message-From: Tim Onions [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23,

RE: OFA and Shared Storage

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://www

RE: Re[2]: Cary's book -- Out of stock !

lling 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.

RE: Isnumeric question

Title: Message Mladen,   While I respect you and your ability with using Perl, if this capability with regular expressions now exists directly within PL/SQL, then why would I want to use Perl to do this?    Oracle Magazine had a pretty good article describing the newly-renamed Oracle Expre

RE: Hiding passwords

Paul,   It's simple really.  Do not allow them to log-on to the Win2k server - don't give them an account;  keep the passwords secret; and keep the machine in a locked room.   Tom Mercadante Oracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAI

RE: COGNOS BI tools against an Oracle DB

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://www.fatcity.com San

RE: [Q] need help on SQLplus select "distinct" !!

7;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: Merc

RE: OFA and Shared Storage

e OFA file structure to maintain the consistency across the many systems and databases... greg -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Monday, September 22, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: OFA and Shared St

RE: OFA and Shared Storage

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

RE: PL/SQL Question:Eliminate duplicate rows

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 PROTECTE

RE: PL/SQL Question:Eliminate duplicate rows

ike 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 list and web h

RE: PL/SQL Question:Eliminate duplicate rows

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, Thoma

RE: Package Body created with compilation errors-

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.orafa

RE: DBMS_STATS and CBO

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:

RE: RMAN in NOCATALOG mode?

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,

RE: DBMS_STATS and CBO

x27;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: Merca

RE: 'Test' Note on Metalink...

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 PROTECTED] Fat City

RE: Checking RMAN backup results

age 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 inf

RE: 'query rewrite' system privg

x27;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 -- Autho

RE: SQLPLUS with cronjob is giving problem

x27;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 -- Autho

RE: 9.2.0.4 anyone

- 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).

RE: Question about unix

ike 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-- Maili

RE: 9.2.0.4 anyone

y 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-- Mailing

RE: ORA-01403 error, help!!!

n (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: Offshore threat

o 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-- Mailing list a

RE: Oracle Standby Database Backups.

ipients of list ORACLE-L Tom I was wondering about the last log file on your primary database that still hasn't been sent to your standby database until a switch log occurs... (thinking about sustained mode too) Have you taken that into account?? JL --- "Mercadante, Thomas F"

RE: Oracle Standby Database Backups.

o primary and you will be ok.   We are using it to backup out 7 TB OLTP database.   HTH.   Arup - Original Message ----- From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 03, 2003 2:29 PM Sub

RE: Re: "Application DBA"

XACT 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://www.orafaq.ne

RE: sqlload

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://ww

Oracle Standby Database Backups.

All, We are in the beginning stages of designing a database with Oracle Standby capability.  The initial size of the database will be 600-800 Gig.  The proposed database will be run on a IBM P690 with a mirrored fail-over machine.  Two separate machines with separate disk.  We are considerin

RE: Oracle on Win2000

Bala,   I create shortcuts to the Oracle/dbs directory and bdump & Udump directories so that I can get there easily from my desktop.   I use telnet to log onto the machine to bring the database up and down.  I have NT admins for installing the software, so I don't need to use PCAnywhere fo

RE: sqlload

bing). -- 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: [Q] SQLPLUS help on "distinct"

e 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-- Mailing list a

RE: How to keep "root" out?

Walt,   Something that has not been suggested - migrate your database to 9.2.  Connect as internal goes away.   Other than that, I think the best suggestion you got was a conversation, and granting access to the v$ tables thru a specific account for that person. And then put a long trigger i

RE: How to log into a 9.2.0 database that has a hung archiver

Shannon,   The problem is not the database.   The problem is your process.  In other words, you are causing the situation.  Stop turning archiving off.  Leave it on.  Just copy/compress the existing archives.  Maybe write another script to copy/compress all of them except the most recent one

RE: sanity check time...

nd 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 I

RE: [UBE?] Re: Nature of Oracle-l has changed

wait - is this OT??   We once had a principal named Peter in grade school. I think he reached that position through the Peter Principle. Jared "Henry Poras" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  08/27/2003 06:39 AM  Please respond to ORACLE-L

RE: Windows 2000 Server and processor recommendations

Shannon.   How much is a Dual Xeon 3.06GHz w/1M cache and 4GB Ram?   Seems to me that if you can afford the higher priced but slower cpu model, that the additional Ram can not be that much more.  Basically, if you can afford $8800, can you afford an additional $x to add 2 GB of Ram to the 3.

RE: Hey Jared

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

RE: Online Document for Windows XP Home edition Severity 3

Title: Message Sinardy,   I've installed the Oracle docs simply by copying all the directories from the CD to my hard drive - no need to perform an installation.   Hope this helps.   Tom Mercadante Oracle Certified Professional -Original Message-From: Gudmundur Bjarni Josepsson

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

t shutting down cleanly/cons Hey Tom, You can send me $111 3 times and I'll be happy!  ;o)   -Scott Stefick -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 1:40 PMTo: Multiple rec

RE: Forms 3 and 9i

E 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 the HELP command for other

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

Title: Message how about if I send you $1,111,111.11   3 times.   -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cle

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

Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up ...wait...for...it...   -Original Message-From: Josh Collier [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:50 PMTo: Multiple recipients of list ORACLE-

RE: system tablespace at 50 pct_increase in 9i?

Title: Re: system tablespace at 50 pct_increase in 9i? Another point of discussion - just what do you expect to gain by altering the SYSTEM tablespace's storage params?  It is not a high volume tablespace - the O's part of I/O to this particular tablespace is very low.  Altering storage param

RE: Take an Oracle 8.1 export file back to an Oracle 7.1 database

Title: Take an Oracle 8.1 export file back to an Oracle 7.1 database. David,   From the machine where the 7.x database exists, run export and export the data from the 8.x database.  You will need to setup your tnsnames.ora file on the 7.x machine to get to the other box.   Export the data yo

RE: Implementing different document types with different attribut

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 ORACLE-L FAQ: h

RE: Question on views

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 http:

RE: test message <==== Test OK !

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

RE: OCP Question

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 PRO

RE: Consolidating Servers

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://www.orafaq.n

RE: last column in a table is added with a DEFAULT

Title: RE: last column in a table is added with a DEFAULT David,   The best way to see if this works is to create a test table.  populate it with some data.  Add a column with a default value.   and observer what happens.   best way to learn.   Tom Mercadante Oracle Certified Professional

RE: last column in a table is added with a DEFAULT

Title: RE: last column in a table is added with a DEFAULT David,   Nope.  Your programmer is wrong.   Tom Mercadante Oracle Certified Professional -Original Message-From: Ehresmann, David [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 3:09 PMTo: Multiple recipients of

RE: RMAN Backup piece being placed in wrong directory

Title: Message Ronald,   It looks like just the archivelog was not going into the correct directory, right?  But then you did *not* include a format clause for the archivelog.   Looking at the docs, it looks like you should change the following:   backup database format'D:\backup\oracle\Hot

RE: Change based recovery

Lisa,   Shut down your production database and FTP the control files over also.  This will make your control files waaayyy ahead of your data files, thus forcing a recovery.   Right now, your database does not need recovery - everything is in synch.  Your control files don't know anything a

Oracle 7 to 9i OCP upgrade

All, Anybody get the mailing at home offering the $50 Beta Oracle 7 OCP to 9i OCP upgrade exam? It's being offered at Oracle Open World (I think). Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Tho

RE: Move selected tables

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 ORACLE-L

RE: Move selected tables

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://www.fatcity.com

RE: Job to run first Wednesday

es. > > Guess I better RTFM the next_day function. > > > > > > > "Mercadante, Thomas F" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/22/2003 12:34 PM > Please respond to ORACLE-L > > > To: Multiple recipient

RE: Job to run first Wednesday

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

RE: TOAD vs BMC's XRAY

L 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-Mail message to: [EMAIL PROTECT

RE: RMAN used?

Mike,   One other external source to look into is the udump directory.  See if an sbtio.log file exists.  Sometimes, Rman will write logs into this file.  If the file doesn't exist, then it is another hint that rman has not been used.   I would say that if you can't find any Rman save sets

RE: Fast!

rom). 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.

RE: 10G

ORACLE-L <[EMAIL PROTECTED]> cc: Subject:10G I just realized what the upgraded name for 9ias will be... -- 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: Empty String is interpreted as NULL

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: Physical Design Question

isolated for you mere mortals! REAL MEN STRESS NT boxes!! -Original Message- Sent: Friday, July 18, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Tom, yours is an isolated incident, bwahhahahaha, unix still rulz joe Mercadante, Thomas F wrote: >We do it all the t

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