RE: Veritas Backup Question

2004-01-15 Thread Smith, Ron L.
') 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: Smith, Ron L. INET: [EMAIL

Export / Import Question

2004-01-09 Thread Smith, Ron L.
=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED

RE: Export / Import Question

2004-01-09 Thread Smith, Ron L.
or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L

Any way to syncronize sequences between database?

2004-01-09 Thread Smith, Ron L.
When doing a partial data refresh, using export/import, is there any way to synchronize Sequences between the two databases? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

How to refresh

2003-12-16 Thread Smith, Ron L.
anything else and without having all the problems with triggers and constraints? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: How to refresh

2003-12-16 Thread Smith, Ron L.
and true way to just refresh the table data without losing anything else and without having all the problems with triggers and constraints? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services

RE: How to refresh

2003-12-16 Thread Smith, Ron L.
in existing schema before running import (and then, enable them after import is done). Also, specify CONSTRAINTS=N and TRIGGERS=N when exporting. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Smith, Ron L. Sent: Tuesday, December 16, 2003 9:55 AM To: Multiple recipients of list

RE: How to refresh

2003-12-16 Thread Smith, Ron L.
IMMEDIATE 'ALTER TABLE ' || lTables(nJ) || ' MODIFY CONSTRAINT ' || lConstraints(nJ) || ' DISABLE'; END LOOP; END; / Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Smith, Ron L. Sent: Tuesday, December 16, 2003 10:25 AM To: Multiple recipients of list ORACLE-L Seems like last

RE: unix question

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

RE: SQL Query

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

Stop using SYS, SYSTEM?

2003-11-12 Thread Smith, Ron L.
: http://www.orafaq.net -- Author: Smith, Ron L. 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: Stop using SYS, SYSTEM?

2003-11-12 Thread Smith, Ron L.
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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services

Valid Oracle Passwords

2003-11-10 Thread Smith, Ron L.
Can anyone tell me the requirements and characters for a valid Oracle password. I have looked through the Oracle 8i documentation CD and I can't seem to find anything. Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL

DBA Support Database

2003-10-30 Thread Smith, Ron L.
and see if anyone has already designed such a database and might be willing to share it. Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Database just stops

2003-10-14 Thread Smith, Ron L.
Title: Message I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason. There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops. When I restart the database it goes through crash

RE: Database just stops

2003-10-14 Thread Smith, Ron L.
velog more and the archiver is not running ? Babu - Original Message - From: Smith, Ron L. To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 14, 2003 3:14 PM Subject: Database just stops

Help with a scripting problem

2003-10-08 Thread Smith, Ron L.
Title: Message I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'. Can anyone tell me how to get around this? echo select 'host c:\program files\resource kit\robocopy;' from dual; Thanks! Ron Smith

RE: Help with a scripting problem

2003-10-08 Thread Smith, Ron L.
;' from dual; select 'exit;' from dual; spool off; exit; Thanks! Ron -Original Message- Sent: Wednesday, October 08, 2003 3:57 PM To: [EMAIL PROTECTED]; Smith, Ron L. Ron, First of all, is echo a SQL*Plis command

RE: Help with a scripting problem

2003-10-08 Thread Smith, Ron L.
\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from dual; Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Smith, Ron L. Sent: Wednesday, October 08, 2003 5:05 PM To: Multiple recipients of list ORACLE-L Sorry, this is what I am trying to run. But again, it barfs on the 'program

RMAN Problem

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

ORA-600

2003-09-16 Thread Smith, Ron L.
Title: Message This is on an old 7.3.4 database. I can't find the same error on Metalink. Anybody have any ideas what might be the cause? ORA-00600: internal error code, arguments: [17114], [1074346728], [], [], [], [], [], [] Ron Smith

Database Cloning

2003-09-15 Thread Smith, Ron L.
to be down, incorrect, or was this just a restriction of older version like 7.3.4? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Database Cloning

2003-09-15 Thread Smith, Ron L.
Please respond to ORACLE-L Smith, Ron L. wrote: Whenever we clone a database on the same server we have always had the understanding that the original database must be down until the new database is renamed by running the control file script

Oracle and Perl

2003-09-09 Thread Smith, Ron L.
Can anyone tell me how to pick up the $ORACLE_SID or $ORACLE_HOME from within a Perl script? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Oracle and Perl

2003-09-09 Thread Smith, Ron L.
: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: Oracle on Win2000

2003-09-03 Thread Smith, Ron L.
Title: Message Be careful using Terminal Server. If you are running batch jobs, the variables like ORACLE_SID and ORACLE_HOME don't always get picked up correctly by the batch job. I have spent hours trying to debug a script run with Terminal Server, then switch to VNC and it works fine.

ROW_ID Hint

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

Export 8.1.7 - Import 7.3.4

2003-08-15 Thread Smith, Ron L.
I need to export the data from an Oracle 8.1.7 database HPUX 64 and import it back into an old 7.3.4 HPUX 32 database. The 7.3.4 import doesn't like the 8.1.7 export file. Any ideas? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET

Semaphore problem

2003-08-14 Thread Smith, Ron L.
Has anyone ever seen an error like: ERROR: rbusy(SEMOP) (13; Permission denied) There is no Oracle error associated with it. Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Poor performance after moving Extempore database from 7.3.4 to 8.1.7

2003-08-14 Thread Smith, Ron L.
Message- Smith, Ron L. Sent: Monday, August 11, 2003 3:14 PM To: Multiple recipients of list ORACLE-L 8.1.7 We recently upgraded an application (Extempore) database from Oracle 7.3.4 to 8.1.7. The clients say the test database, still on Oracle 7.3.4 is much faster than the production

RE: Poor performance after moving Extempore database from 7.3.4 to 8.1.7

2003-08-14 Thread Smith, Ron L.
. The article itself is a good one (thanks, Tim) but reading the book from JL (Jonathan Lewis, not Jeniffer Lopez) wouldn't hurt, either. -- Mladen Gogala Oracle DBA -Original Message- Smith, Ron L. Sent: Monday, August 11, 2003 3:14 PM To: Multiple recipients of list ORACLE-L 8.1.7

RE: ODBC Problem with @ sign

2003-08-14 Thread Smith, Ron L.
Title: Message Is anyone aware of a problem with the 8.1.7 Client ODBC driver handling the '@' sign? Ron Smith

Poor performance after moving Extempore database from 7.3.4 to 8.1.7

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

ODBC Problem with @ sign

2003-08-09 Thread Smith, Ron L.
Title: Message Is anyone aware of a problem with the 8.1.7 Client ODBC driver handling the '@' sign? Ron Smith

Move selected tables

2003-08-04 Thread Smith, Ron L.
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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 selected tables

2003-08-04 Thread Smith, Ron L.
it is a matter of management discipline, and the DBA's ability to do anything about it depends on how much control they have over introduction of new code. Good luck, -Chris -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 12:14 PM To: Multiple

RE: Redo Logs Problem

2003-08-01 Thread Smith, Ron L.
Title: Message This may have already been asked, but is it possible there is a datafile in backup mode even though a backup is not running? -Original Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 10:24 AMTo: Multiple

HELP! Index Debate!

2003-07-31 Thread Smith, Ron L.
ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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 to MSSQL conversion?

2003-07-31 Thread Smith, Ron L.
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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network

RE: HELP! Index Debate!

2003-07-31 Thread Smith, Ron L.
ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: HELP! Index Debate!

2003-07-31 Thread Smith, Ron L.
, having an opinion is an art ! -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 31, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: HELP! Index Debate! Please help resolve this dispute. We have a query that runs over 5

RE: HELP! Index Debate!

2003-07-31 Thread Smith, Ron L.
are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Smith, Ron L. [mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 4:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: HELP! Index Debate

RE: HELP! Index Debate!

2003-07-31 Thread Smith, Ron L.
.WHS_ID and T6.LOT_ID=T2.LOT_ID and T6.WHS_LOC_ID=T3.WHS_LOC_ID and T6.TIME_ID=T5.TIME_ID and T6.QUALITY_ID=T7.QUALITY_ID order by c9 asc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services

Oracle Snapshot Too Old during programatic load

2003-07-28 Thread Smith, Ron L.
: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: Oracle Snapshot Too Old during programatic load

2003-07-28 Thread Smith, Ron L.
: Monday, July 28, 2003 11:19 AM To: Multiple recipients of list ORACLE-L Smith, Ron L. scribbled on the wall in glitter crayon: I asked this last week, but I have a little more info this week. I have a table that gets programmatically loaded each night. The table needs to have an index added

RE: Oracle Snapshot Too Old during programatic load

2003-07-28 Thread Smith, Ron L.
as suggested in Oracle papers but I still get the same error. If I remove the index, the load works fine. Any ideas? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: RE: Oracle Snapshot Too Old during programatic load

2003-07-28 Thread Smith, Ron L.
delete create index. correct? From: Smith, Ron L. [EMAIL PROTECTED] Date: 2003/07/28 Mon PM 01:24:23 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle Snapshot Too Old during programatic load The index is not set up with nologging. I can build the index

Update through a DBLink

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

Please help with ORA-01555 Snapshot too old

2003-07-22 Thread Smith, Ron L.
Title: Message Help! I have a production and a test database, both with 3000mg RBS tablespaces with two datafiles. Both have db_block_buffers set at 1000. The only difference is the production db has 7rollback segments and thetest db has 8. The rollback segments are sized at 50mg each on

RE: Please help with ORA-01555 Snapshot too old

2003-07-22 Thread Smith, Ron L.
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: Smith, Ron L

RMAN SQL Backtrack

2003-07-16 Thread Smith, Ron L.
Title: Message We have been using SQL Backtrack for backup and recovery forabout 6 years now. We are being pressured to start using RMAN because it is free. Makes sense but I am wondering about reliability, complexity, learning curve, etc... Has anyone had experience with both products or

RE: nt script

2003-07-01 Thread Smith, Ron L.
of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City

Oracle 7.3.4 on Win2000

2003-06-23 Thread Smith, Ron L.
Title: Message I need to load SQL Loader 7.3.4 on a Win2000 server. All I have is ORacle 7.3.4 for NT. Does anyone know if it will load and run ok without messing up something? Is there a CD for 7.3.4 on Win2000? Thanks! Ron If you are not the intended recipient of this e-mail message,

Read SQL Server from Oracle

2003-06-19 Thread Smith, Ron L.
by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Retreiving data from SQL Server

2003-06-17 Thread Smith, Ron L.
immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Export Long Dies with no error

2003-05-30 Thread Smith, Ron L.
, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

RE: another chance for 9i CDs - Beware!

2003-04-03 Thread Smith, Ron L.
received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Query through database link gets lost

2003-04-02 Thread Smith, Ron L.
me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Import data only into existing schema

2003-03-12 Thread Smith, Ron L.
is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services

Disable / enable constraints

2003-03-11 Thread Smith, Ron L.
, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: shared tnsnames.ora

2003-02-27 Thread Smith, Ron L.
-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Skill Sets - This may be a dumb question

2003-02-25 Thread Smith, Ron L.
Title: Message We are told pretty often by management that DBA's are 'dime a dozen' and we need to be more than 'just DBA's' to keep our jobs. On the other hand we are hiring contractors that know Peoplesoft Adminand paying them big bucks. Same with Data Warehouse people. They are in

8.1.7 Instance not creating an SGADEF file

2003-02-18 Thread Smith, Ron L.
immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: common listener

2003-02-10 Thread Smith, Ron L.
received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Help with a truncate command in a procedure

2003-02-07 Thread Smith, Ron L.
be the first to say that you need to use dynamic SQL? dbms_sql package in Oracle version 8.1 execute immediate in Oracle version = 8.1 -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] I am not a coder but I received this from one of our developers. I

Help with a truncate command in a procedure

2003-02-06 Thread Smith, Ron L.
Title: Help with a truncate command in a procedure I am not a coder but I received this from one of our developers. I can't find anything about this anywhere. Can someone tell me how to make the truncate work? Thanks! R.Smith In a DB procedure, I wanted to include the following SQL:

SQL*NET timeout with database link

2003-02-05 Thread Smith, Ron L.
use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET

SQLPLUS Timeout

2003-02-04 Thread Smith, Ron L.
of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City

Check for all numeric in a column

2003-01-31 Thread Smith, Ron L.
Title: Message What is the easiest / best way to check for a valid numeric value in a column? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you

RMAN or SQLBacktrack?

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

Strange processes showing up

2003-01-27 Thread Smith, Ron L.
-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Oracle Financials - Help!

2003-01-22 Thread Smith, Ron L.
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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 Verification

2003-01-17 Thread Smith, Ron L.
this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Database Verification

2003-01-17 Thread Smith, Ron L.
me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Unix Max Extent Script

2003-01-16 Thread Smith, Ron L.
Title: Message Here is what we run. It is part of a group of scripts we run every 15 minutes that monitor all the databases. The script will either send a page or an email, depending on how it is called. The command to run the script (cron every 15 minutes): nextext.sh prod zrls1

RE: Orawomen

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

RE: Faking an ORA-600

2002-12-19 Thread Smith, Ron L.
is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Where's that last archive log?

2002-12-18 Thread Smith, Ron L.
, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED

Any way to script or document jobs defined to the NT/MS2000 Task

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

RE: Any way to script or document jobs defined to the NT/MS2000 T

2002-12-05 Thread Smith, Ron L.
Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] Smith, Ron L. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

Oracle 7.3.4 on MS2000

2002-11-20 Thread Smith, Ron L.
: Smith, Ron L. 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

Batch SQLPLUS on Win 2000

2002-11-13 Thread Smith, Ron L.
of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network

Record count within a procedure

2002-10-21 Thread Smith, Ron L.
of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network

RE: RE: RE: Backups

2002-10-03 Thread Smith, Ron L.
).nbsp; You may/FONT BRFONT SIZE=2also send the HELP command for other information (like subscribing)./FONT /P /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: RE: RE: Backups

2002-10-03 Thread Smith, Ron L.
to do it again. Not so simple, can't be done from the SQL*Bactrack menu. Jared Smith, Ron L. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/03/2002 01:26 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject

RE: SQL Backtrack Reports

2002-10-02 Thread Smith, Ron L.
report the backup start and stop times? If so, that's a really tall order. What we do is run SQL Backtrack from a shell script that reports start and stop time and emails success/failure for each instance. --- Smith, Ron L. [EMAIL PROTECTED] wrote: If anyone out there is using SQL Backtrack

RE: Performance monitoring

2002-10-02 Thread Smith, Ron L.
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

SQL Backtrack Reports

2002-10-01 Thread Smith, Ron L.
If anyone out there is using SQL Backtrack to backup Oracle I am looking for a home grown reporting script that will give me start and stop times for all the backups on the log file. Thanks! R. Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET

RE: quckways to find block corruption

2002-09-23 Thread Smith, Ron L.
a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City

Estat Bstat

2002-09-18 Thread Smith, Ron L.
I am trying to run utlbstat and utlestat for the first time. The output is not formatted very well. Does anyone have a cleaner version? R. Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services

FW: Problem upgrading Oracle 8.1.7 on MS2000

2002-09-11 Thread Smith, Ron L.
me what else I should stop? Is there a log file that tells me what it is trying to do? Thanks! R. Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Problem upgrading Oracle 8.1.7 on MS2000

2002-09-10 Thread Smith, Ron L.
me what else I should stop? Is there a log file that tells me what it is trying to do? Thanks! R. Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: RE: Pls respond...: URGENT

2002-09-03 Thread Smith, Ron L.
: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services

Pro*C error after install

2002-08-22 Thread Smith, Ron L.
/8.1.7/precomp/demo/proc *** Error code 1 make: Fatal error: Command failed for target `sample1' R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Install Pro*C

2002-08-21 Thread Smith, Ron L.
Someone forgot to install Pro*C on our 8.1.7 Sun server. I need to install it. Is there anything that needs to be done after I run the installer? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network

RE: It took more than an hour to update 10,000 records

2002-08-13 Thread Smith, Ron L.
') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L

RE: SAN

2002-08-13 Thread Smith, Ron L.
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

What Oracle versions are supported on MS2000?

2002-08-12 Thread Smith, Ron L.
Can anyone tell me what Oracle versions are supported on MS2000? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

ORA-04021: timeout occurred while waiting to lock object

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

RE: ORA-04021: timeout occurred while waiting to lock object

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

  1   2   3   >