RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

2004-01-30 Thread Mercadante, Thomas F
') 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, Thomas F

RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

2004-01-30 Thread Mercadante, Thomas F
once you boot the machine. Thanks. -Original Message- Mercadante, Thomas F Sent: Friday, January 30, 2004 10:44 AM To: Multiple recipients of list ORACLE-L star Dharminder, Changes the service to AutoStart when the machine reboots. As Thomas said, the NT service has to be running for you

RE: !!Please Read - Oracle-L is moving!!

2004-01-28 Thread Mercadante, Thomas F
I agree. The *least* we can do is to subscribe to the service. Jared had all the other work getting the service started. Good job Jared. We love you, we really really do. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 28, 2004

RE: Getting sysdate across a DB link

2004-01-26 Thread Mercadante, Thomas F
Title: Getting sysdate across a DB link Ashish, Why do you think that the dates would be different on the two machines - is one across the international date line? Shouldn't the dates be the same? How about getting the time from both servers - they *might be* different by a few seconds.

RE: Getting sysdate across a DB link

2004-01-26 Thread Mercadante, Thomas F
Mladen, there you go again! LOL. now go back and trade your Wang in for a new one. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, January 26, 2004 2:04 PM To: Multiple recipients of list ORACLE-L On 01/26/2004 01:34:24 PM, Mercadante, Thomas F wrote

RE: internal date value

2004-01-23 Thread Mercadante, Thomas F
). 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: internal date value

2004-01-23 Thread Mercadante, Thomas F
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 Network

RE: internal date value

2004-01-23 Thread Mercadante, Thomas F
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 Network

RE: Metalink on the blink

2004-01-22 Thread Mercadante, Thomas F
Title: Metalink on the blink but their education site is off the air (at least it was an hour ago) Tom Mercadante Oracle Certified Professional -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED]Sent: Thursday, January 22, 2004 10:09 AMTo: Multiple recipients of

RE: Spool to Excel File

2004-01-20 Thread Mercadante, Thomas F
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 Network

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mercadante, Thomas F
, 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 PROTECTED

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mercadante, Thomas F
(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 web hosting services

RE: tnsnames.ora not working ?

2004-01-20 Thread Mercadante, Thomas F
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 hosting services

RE: Spool to Excel File

2004-01-20 Thread Mercadante, Thomas F
"SYLK allows cell references, etc, if needed, which you won't get with CSV. " Ahh. but you can with my method! If you use tab separated columns, you can also generate formula's that look like text, but work just fine in the spreadsheet! Tom Mercadante Oracle Certified Professional

RE: Opinion on Changing Names

2004-01-16 Thread Mercadante, Thomas F
and change some letters. Is there any way or a better one to accomplish that ? Scenario 8.1.7.4 from HP-UX (Prod) to RH AS 1.2 8.1.7.4 (lab). TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F

RE: Connection Problem

2004-01-16 Thread Mercadante, Thomas F
') 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, Thomas F INET

RE: Connection Problem

2004-01-16 Thread Mercadante, Thomas F
instances? Would it not be better to set it to the same name as the instance name for each? The same goes for port too.. I thought that all three on the same port would be OK? Cheers Mark -Original Message- Mercadante, Thomas F Sent: 16 January 2004 13:30 To: Multiple recipients of list ORACLE

RE: table reorganizations

2004-01-09 Thread Mercadante, Thomas F
- From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 6:34 AM Subject: RE: table reorganizations Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say

RE: DBA position

2004-01-08 Thread Mercadante, Thomas F
Title: RE: DBA position I like the "relocation" info. It says 'None' and then 'click here'. When you do that, it says: None - Lifetouch offers no assistance. I guess this is in case you don't understand the meaning of the word "None". Tom Mercadante Oracle Certified Professional

RE: simple question

2004-01-08 Thread Mercadante, Thomas F
Greg, Try this: create or replace procedure truncate_tables(in_owner in varchar2) is BEGIN FOR r IN (SELECT table_name FROM dba_tables WHERE owner=in_owner) LOOP EXECUTE IMMEDIATE 'truncate table' || in_owner || '.' || r.table_name; END LOOP;END;/ You will need to grant select on

RE: simple question

2004-01-08 Thread Mercadante, Thomas F
Remove the r number(10); and it should be fine. Tom Mercadante Oracle Certified Professional -Original Message-From: oranew2004 [mailto:[EMAIL PROTECTED]Sent: Thursday, January 08, 2004 3:24 PMTo: Multiple recipients of list ORACLE-LSubject: Re: simple question

RE: Verisign and MetaLink

2004-01-07 Thread Mercadante, Thomas F
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 Network

RE: table reorganizations

2004-01-07 Thread Mercadante, Thomas F
Title: Message Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say in a year, then place it in a Locally Managed tablespace with extent sizes to hold enough data for one year (say 1M). You should never have to

RE: Difference on ArchiveLog

2004-01-07 Thread Mercadante, Thomas F
Mauricio, Think about it. Your redo logs are now larger, and they have to be cleared out by the archiver less often. So archivelog files are produced less often. So you have less physical archive log files being produced. The other data that *used to be* in archivelog files are now in

RE: Upgrade

2004-01-06 Thread Mercadante, Thomas F
-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: Oracle OID and Production Databases Sharing the same

2003-12-31 Thread Mercadante, Thomas F
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 we

RE: Can't connect MTS from remote.

2003-12-31 Thread Mercadante, Thomas F
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

Oracle OID and Production Databases Sharing the same Oracle Home

2003-12-30 Thread Mercadante, Thomas F
. Anybody got an opinion? 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

RE: Database Instance

2003-12-24 Thread Mercadante, Thomas F
I would be very careful about doing this if you have purchased application packages. Sooner or later, you will want to upgrade one of the packages, and it will require a different release of Oracle - and you will be stuck. Tom Mercadante Oracle Certified Professional -Original

RE: Export/Import issue.

2003-12-24 Thread Mercadante, Thomas F
(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: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE

2003-12-23 Thread Mercadante, Thomas F
(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-5051

RE: ora-942 message in alert log

2003-12-23 Thread Mercadante, Thomas F
Sorry. I read your email twice and still have not seen a question. Are you wondering if this is normal? :) Tom Mercadante Oracle Certified Professional -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 23, 2003 10:39 AMTo: Multiple

RE: seq

2003-12-23 Thread Mercadante, Thomas F
://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 REMOVE yourself

RE: RMAN - the time has come

2003-12-22 Thread Mercadante, Thomas F
Title: RMAN - the time has come Raj, It really is a quick learn. The best way is to get some scripts (great examples in the rdbms/demo directory) and try them on a test database. Once you get something running, the rest is simple. If you need some samples, let me know. It's really basic

RE: sys as sysdba with password through ODBC

2003-12-19 Thread Mercadante, Thomas F
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.fatcity.com

RE: sys as sysdba with password through ODBC

2003-12-19 Thread Mercadante, Thomas F
To: [EMAIL PROTECTED]; [EMAIL PROTECTED] I have done that it works through SQLPLUS but through my page i can connect to the dsn but now i get Warning: odbc_exec(): SQL error: [Oracle][ODBC][Ora]ORA-03114: not connected to ORACLE , SQL state S1000 in SQLExecDirect From: Mercadante, Thomas F

RE: RMAN Retention Policy

2003-12-18 Thread Mercadante, Thomas F
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: OEM permissions

2003-12-18 Thread Mercadante, Thomas F
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 Diego

RE: How to refresh

2003-12-16 Thread Mercadante, Thomas F
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: connection pooling from an application server to oracle

2003-12-15 Thread Mercadante, Thomas F
://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 REMOVE yourself from

RE: RE: connection pooling from an application server to oracle

2003-12-15 Thread Mercadante, Thomas F
session may actually be several distinct database sessions. --- [EMAIL PROTECTED] wrote: doesnt this force you to commit after every single DML statement? From: Mercadante, Thomas F [EMAIL PROTECTED] Date: 2003/12/15 Mon AM 08:36:09 EST To: '[EMAIL PROTECTED]' [EMAIL PROTECTED

RE: connection pooling from an application server to oracle

2003-12-15 Thread Mercadante, Thomas F
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: Who are certified Oracle Masters?

2003-12-12 Thread Mercadante, Thomas F
-- 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 mailing

RE: Fedora (pink hat)

2003-12-12 Thread Mercadante, Thomas F
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.fatcity.com

RE: 10g stuff on otn

2003-12-11 Thread Mercadante, Thomas F
"so are they really new versions or just minor upgrades to the 9i version?" let's see. Otn is a marketing tool. From a marketing point of view, what's better - changing the name to make it look like it's brand-spanking new, or making what is obvious obvious - that they are simply

RE: Little competition

2003-12-11 Thread Mercadante, Thomas F
') 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, Thomas F INET

RE: 3rd Party Oracle Licenses

2003-12-11 Thread Mercadante, Thomas F
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: Creating the Java System

2003-12-10 Thread Mercadante, Thomas F
create database controlfile reuse datafile.logfile... command before initjvm and everything will work. On 12/09/2003 03:44:26 PM, Mercadante, Thomas F wrote: All, I am attempting to install the Java system in a 9.2 database on Sun Solaris. This is a db that I migrated up to 9.2 from 8.1.7

RE: char is going away?

2003-12-10 Thread Mercadante, Thomas F
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 web

Creating the Java System

2003-12-09 Thread Mercadante, Thomas F
://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 REMOVE yourself from

RE: Creating the Java System

2003-12-09 Thread Mercadante, Thomas F
and then executing create database controlfile reuse datafile.logfile... command before initjvm and everything will work. On 12/09/2003 03:44:26 PM, Mercadante, Thomas F wrote: All, I am attempting to install the Java system in a 9.2 database on Sun Solaris. This is a db that I migrated up to 9.2 from

RE: Exclusive Password file, multiple databases

2003-12-08 Thread Mercadante, Thomas F
Title: Exclusive Password file, multiple databases April, I just went thru this. Look in the sqlnet.ora file. If : Tom Mercadante Oracle Certified Professional -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 1:35 PMTo: Multiple

RE: Exclusive Password file, multiple databases

2003-12-08 Thread Mercadante, Thomas F
Title: Exclusive Password file, multiple databases April, I just went thru this. Look in the sqlnet.ora file. If :SQLNET.AUTHENTICATION_SERVICES= (NTS)is set, comment it out. It was the cause of the problems on my machine. Good Luck! Tom Mercadante Oracle Certified Professional

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

2003-12-08 Thread Mercadante, Thomas F
somebody has free time on his hands. Jared, what's your bosses email addy? Tom Mercadante Oracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 3:59 PMTo: Multiple recipients of list ORACLE-LSubject:

RE: running both shared server and dedicated mode on the same ins

2003-12-02 Thread Mercadante, Thomas F
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: Happy Thanksgiving

2003-11-26 Thread Mercadante, Thomas F
') 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, Thomas

WebSphere and Oracle

2003-11-25 Thread Mercadante, Thomas F
://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 REMOVE

RE: Move datafiles, but can't delete them

2003-11-25 Thread Mercadante, Thomas F
). -- 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: Move datafiles, but can't delete them

2003-11-25 Thread Mercadante, Thomas F
-- 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: WebSphere and Oracle

2003-11-25 Thread Mercadante, Thomas F
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: Configuring multi-threaded server

2003-11-18 Thread Mercadante, Thomas F
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 hosting services

RE: 'internal' role and 9i

2003-11-18 Thread Mercadante, Thomas F
://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 REMOVE yourself from

RE: 'internal' role and 9i

2003-11-18 Thread Mercadante, Thomas F
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 web

RE: 'internal' role and 9i

2003-11-18 Thread Mercadante, Thomas F
and 9iYong didn't do it, he merely posted a reply. "Mercadante, Thomas F" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/18/2003 06:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L

RE: 'internal' role and 9i

2003-11-18 Thread Mercadante, Thomas F
. But basically you're saying that it shouldn't have been done like this and now it needs to be changed. Not the answer I was hoping for, but at least now I know!! Thanks for your help all. -Original Message- Mercadante, Thomas F Sent: 18 November 2003 14:54 To: Multiple recipients of list

RE: how to recycle sbtio

2003-11-18 Thread Mercadante, Thomas F
AK, Yes. You can simply rename it or delete it. I rename itmonthly. And then delete it the next month. It truely is a worthless file. Tom Mercadante Oracle Certified Professional -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Tuesday, November 18, 2003 12:04

RE: Re[2]: var source_data varchar2(12)

2003-11-17 Thread Mercadante, Thomas F
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: Configuring multi-threaded server

2003-11-17 Thread Mercadante, Thomas F
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 web

RE: Migration utility to convert 32 bit DB to 64 bit?

2003-11-14 Thread Mercadante, Thomas F
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: Clean temporary tablespace

2003-11-14 Thread Mercadante, Thomas F
(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: Create Rule

2003-11-14 Thread Mercadante, Thomas F
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 hosting services

RE: data modelling question - job vs. job history table

2003-11-13 Thread Mercadante, Thomas F
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: Stop using SYS, SYSTEM?

2003-11-12 Thread Mercadante, Thomas F
') 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, Thomas F INET

RE: Why does script have more than one slash(/) inside?

2003-11-07 Thread Mercadante, Thomas F
when I learn something, I go : was that all? and they go, yes, yes, that was all... Well, let me show you what I mean.. What does it mean when a .sql script has more than one slashes(/) inside it? code -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas

RE: Uncle Larry, wake up!!!

2003-11-07 Thread Mercadante, Thomas F
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: Uncle Larry, wake up!!!

2003-11-07 Thread Mercadante, Thomas F
). -- 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: Metalink: Pwd Problems?

2003-11-06 Thread Mercadante, Thomas F
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 web hosting

RE: Point-In-Time recovery question, Non-RMAN solution

2003-11-06 Thread Mercadante, Thomas F
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 hosting services

RE: How do you genrate primary keys?

2003-11-05 Thread Mercadante, Thomas F
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 Network

RE: How do you genrate primary keys?

2003-11-05 Thread Mercadante, Thomas F
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: How do you genrate primary keys?

2003-11-05 Thread Mercadante, Thomas F
). -- 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: database terminated

2003-11-04 Thread Mercadante, Thomas F
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 Diego

RE: Sequences in OPS/RAC

2003-11-03 Thread Mercadante, Thomas F
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: Moving projects from development/test to production

2003-10-31 Thread Mercadante, Thomas F
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: Oracle failsafe and RMAN

2003-10-30 Thread Mercadante, Thomas F
-- 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 mailing

RE: proc to pl/sql

2003-10-30 Thread Mercadante, Thomas F
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

RE: RE: Date-based query Q

2003-10-29 Thread Mercadante, Thomas F
How about this? SELECT col_date, SUM(COUNT) FROM ( SELECT ukdate, COUNT(*) COUNT FROM tomtest GROUP BY ukdate UNION SELECT ADD_MONTHS(TO_DATE('12012002','mmdd'),ROWNUM) dba_month,0 FROM DBA_OBJECTS WHERE ROWNUM 13) GROUP BY ukdate Tom Mercadante Oracle Certified

RE: Clone db 9.2 on AIX 5L

2003-10-28 Thread Mercadante, Thomas F
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.fatcity.com

RE: Oracle pricing ain't going down

2003-10-27 Thread Mercadante, Thomas F
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: Coalescing tablespace

2003-10-27 Thread Mercadante, Thomas F
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: Query Tuning Help

2003-10-27 Thread Mercadante, Thomas F
Title: Query Tuning Help David, The calculation "( SYSDATE - 35)" is not causing the problem. The To_Date(a2.file_dts, 'mmddyyhh24miss') is. You said you created a function based index. I think you also need to set: Query_ReWrite_Integrity = TRUSTEDQuery_ReWrite_Enabled = TRUE for

RE: dba interview questions

2003-10-24 Thread Mercadante, Thomas F
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: how to specify tablespace in Designer

2003-10-24 Thread Mercadante, Thomas F
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: full recovery

2003-10-24 Thread Mercadante, Thomas F
AK, First, your normal backup should backup your database in the following order: Database, archivelogs and then control file. I actually do this in three separate Rman steps. This is so that the most recent control file is backups up after all of the data. This allows your to perform an

RE: how to specify tablespace in Designer

2003-10-23 Thread Mercadante, Thomas F
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 hosting services

RE: Can I concatenate several rows without a procedure?

2003-10-22 Thread Mercadante, Thomas F
-- 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 mailing

RE: Can I concatenate several rows without a procedure?

2003-10-22 Thread Mercadante, Thomas F
yeah, but it's a convoluted requirement. if they really wanted to retrieve all rows in one column, why didn't they use a Clob instead??? :) Tom Mercadante Oracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, October

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

2003-10-21 Thread Mercadante, Thomas F
-- 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 mailing

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

2003-10-21 Thread Mercadante, Thomas F
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: Cache a table

2003-10-21 Thread Mercadante, Thomas F
, 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 PROTECTED

  1   2   3   4   5   6   7   8   9   10   >