RE: DBMS_JOB : Can submit but does not execute=working now

2003-02-20 Thread CHAN Chor Ling Catherine (CSC)
: Wednesday, February 19, 2003 8:25 PM To: [EMAIL PROTECTED]; CHAN Chor Ling Catherine (CSC) Subject:RE: DBMS_JOB : Can submit but does not execute Make sure job_queue_processes 0. Also check job_queue_interval. Jay Hostetter

How do you calcuate the temp space needed for view?

2003-02-20 Thread CHAN Chor Ling Catherine (CSC)
://www.orafaq.net -- Author: CHAN Chor Ling Catherine (CSC) 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: How do you calcuate the temp space needed for view?

2003-02-20 Thread CHAN Chor Ling Catherine (CSC)
advice ? Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City

RE: DBMS_JOB : Can submit but does not execute

2003-02-18 Thread CHAN Chor Ling Catherine (CSC)
, 3 ' PROCEDURE_NAME;',to_date('1802200308:00:00','ddmmhh24:mi:ss'),'SYSDATE+1'); 4* END; SQL / It did not execute. Any advice ? TIA Regds, Catherine -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Wednesday

DBMS_JOB : Can submit but does not execute

2003-02-18 Thread CHAN Chor Ling Catherine (CSC)
0 Regds, Catherine -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Daily job to populate table in another database

2002-12-10 Thread CHAN Chor Ling Catherine (CSC)
more efficient to use DBMS_JOB ? Can DBMS_JOB call the procedure at the same time daily ? Any sample? Please advise. Thanks. Regds, new bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services

RE: plsql cartridge

2002-12-10 Thread CHAN Chor Ling Catherine (CSC)
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

OT: Website that contains materials about performance tuning of S

2002-10-22 Thread CHAN Chor Ling Catherine (CSC)
Hi, Does anyone know of any web site that contains materials about performance tuning of SQL (oracle or any other database) ? TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network

How to create user with cannot login sqlplus but can use odbc to

2002-10-22 Thread CHAN Chor Ling Catherine (CSC)
Hi, I need to create a new user in 8.1.6 who cannot login via sqlplus but can use odbc to connect to this oracle account. Does anyone has the script to create such user ? TIA. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine

How to get the count of all tables using dbms_sql

2002-10-17 Thread CHAN Chor Ling Catherine (CSC)
THEN dbms_sql.close_cursor(cid); END; Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: How to get the count of all tables using dbms_sql

2002-10-17 Thread CHAN Chor Ling Catherine (CSC)
; / Regds, New Bee -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Thursday, October 17, 2002 4:12 PM To: '[EMAIL PROTECTED]' Subject:How to get the count of all tables using dbms_sql

Scramble or Delete data in Oracle HRMS 11i

2002-10-14 Thread CHAN Chor Ling Catherine (CSC)
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Is it possible to copy one db to another if the SID is different

2002-10-09 Thread CHAN Chor Ling Catherine (CSC)
: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Is it possible to copy one db to another if the SID is differ

2002-10-09 Thread CHAN Chor Ling Catherine (CSC)
-Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 3:13 PM To: Multiple recipients of list ORACLE-L Subject: Is it possible

RE: Is it possible to copy one db to another if the SID is differ

2002-10-09 Thread CHAN Chor Ling Catherine (CSC)
://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Is it possible to copy one db to another if the SID is differ

2002-10-09 Thread CHAN Chor Ling Catherine (CSC)
-- Author: CHAN Chor Ling Catherine (CSC) 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: Oracle Arm Twisting?

2002-08-15 Thread CHAN Chor Ling Catherine (CSC)
** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] Sent: Wednesday

RE: Oracle Arm Twisting?

2002-08-15 Thread CHAN Chor Ling Catherine (CSC)
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Oracle Arm Twisting?

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

RE: Which table to check whether my SQL_TRACE is on for the user

2002-08-09 Thread CHAN Chor Ling Catherine (CSC)
(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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City

RE: Table Naming Conventions

2002-07-30 Thread CHAN Chor Ling Catherine (CSC)
(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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network

OT : Apache version

2002-07-09 Thread CHAN Chor Ling Catherine (CSC)
Hi Guru, Does anyone know how to find the apache vision in Unix ? Is pkginfo -i |grep -i apache the correct command to find the apache version ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC

RE: Oracle Applications Development Database Refresh

2002-07-09 Thread CHAN Chor Ling Catherine (CSC)
-- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: OT : Apache version

2002-07-09 Thread CHAN Chor Ling Catherine (CSC)
-- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

How to calculate table size in 8i

2002-07-09 Thread CHAN Chor Ling Catherine (CSC)
Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

RE: Oracle Applications Development Database Refresh

2002-07-08 Thread CHAN Chor Ling Catherine (CSC)
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Printing a report in landscape mode

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

RE: a PL/SQL question - how to catch errors without going into ex

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

RE: Follow-up :Long running SQL Problem?

2002-04-03 Thread CHAN Chor Ling Catherine (CSC)
To: Multiple recipients of list ORACLE-L Subject:Re: Follow-up :Long running SQL Problem? CHAN Chor Ling Catherine (CSC) wrote: Hi Gurus, My senior DBA always tell us

RE: Long running SQL Problem?

2002-04-02 Thread CHAN Chor Ling Catherine (CSC)
advise. Thanks. Regds, Catherine -Original Message- Sent: Wednesday, March 27, 2002 8:19 PM To: CHAN Chor Ling Catherine (CSC) Hello Catherine Thanks first of all for your suggestions. The indexes were already in exitance before your email, so I did not even try that. But your query

RE: ORA-600 Error

2002-04-01 Thread CHAN Chor Ling Catherine (CSC)
above are entirely my own and not those of my employer or clients ** -Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] I am trying to gather the events that will led up

RE: Move index to another tablespace

2002-04-01 Thread CHAN Chor Ling Catherine (CSC)
: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

ORA-600 Error

2002-03-31 Thread CHAN Chor Ling Catherine (CSC)
651 366 7 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

ORA-01000: maximum open cursors exceeded

2002-03-31 Thread CHAN Chor Ling Catherine (CSC)
ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Long running SQL Problem?

2002-03-27 Thread CHAN Chor Ling Catherine (CSC)
by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: How to duplicate production database onto development box

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

RE: How to duplicate production database onto development box

2002-03-27 Thread CHAN Chor Ling Catherine (CSC)
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

OT: Oracle HRMS Applications - Cannot view concurrent request ou

2002-03-26 Thread CHAN Chor Ling Catherine (CSC)
not affect the view of report, right ? Please help. Thanks. Desperate DBA :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Oracle HRMS Applications - Cannot view concurrent request ou

2002-03-26 Thread CHAN Chor Ling Catherine (CSC)
Hi Gurus, The problem has been resolved. Not enough disk space in the /var/tmp directory. Regds, ChorLing -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Tuesday, March 26, 2002 10:23 PM To: Multiple

RE: Concatenating formated number and date doesn't work

2002-03-26 Thread CHAN Chor Ling Catherine (CSC)
cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED

OT : Upgrade Unix OS with Veritas Volumn Manager

2002-03-25 Thread CHAN Chor Ling Catherine (CSC)
. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: CASE under Oracle8i

2002-03-24 Thread CHAN Chor Ling Catherine (CSC)
: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: CPU usage for each oracle instance

2002-03-23 Thread CHAN Chor Ling Catherine (CSC)
FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: OT : Unix script to monitor log file size/disk space

2002-03-21 Thread CHAN Chor Ling Catherine (CSC)
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Oracle CERT Advisory

2002-03-20 Thread CHAN Chor Ling Catherine (CSC)
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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

2002-03-18 Thread CHAN Chor Ling Catherine (CSC)
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

OT : Unix script to monitor log file size/disk space

2002-03-12 Thread CHAN Chor Ling Catherine (CSC)
. Regds, New Bee in Unix -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Upgrade OS for database 8.1.6

2002-03-06 Thread CHAN Chor Ling Catherine (CSC)
addbctl.sh: exiting with status 0 I am thinking of asking him to install a fresh copy of the OS 5.6 ? Any advice ? Please help. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat

RE: Upgrade OS for database 8.1.6

2002-03-06 Thread CHAN Chor Ling Catherine (CSC)
Hi Gurus, We've solved the problem. Some of the unix Kernel parameters are not set properly. Thanks. Regds, New Bee -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Thursday, March 07, 2002 10:28 AM

RE: Error in relinking executables after Upgrade Unix OS from 2.6

2002-03-04 Thread CHAN Chor Ling Catherine (CSC)
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 2:14 PM To: CHAN Chor Ling Catherine (CSC) Subject:RE: Error in relinking executables after Upgrade Unix OS from 2.6 TO Check the Oracle8/8i Installation Guide

RE: Error in relinking executables after Upgrade Unix OS from 2.6

2002-03-03 Thread CHAN Chor Ling Catherine (CSC)
CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] 04/03/2002 10:48 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

RE: Disable certain users from login to database while applying H

2002-02-20 Thread CHAN Chor Ling Catherine (CSC)
] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 4:44 PM To: CHAN Chor Ling Catherine (CSC) Cc: [EMAIL PROTECTED] Subject:RE: Disable certain users from login to database while applying H

Web DB 2.5 listener always hung for Oracle HRMS applications V11.

2002-02-20 Thread CHAN Chor Ling Catherine (CSC)
Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Web DB 2.5 listener always hung for Oracle HRMS applications

2002-02-20 Thread CHAN Chor Ling Catherine (CSC)
. Thank -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 11:10 AM To: CHAN Chor Ling Catherine (CSC) Cc: [EMAIL PROTECTED

RE: Web DB 2.5 listener always hung for Oracle HRMS applications

2002-02-20 Thread CHAN Chor Ling Catherine (CSC)
Principal DBA Chartered Semiconductor Manufacturing Ltd CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] 21/02/2002 10:13 AM Sent by: [EMAIL PROTECTED

RE: Disable certain users from login to database while applying H

2002-02-19 Thread CHAN Chor Ling Catherine (CSC)
Semiconductor Manufacturing Ltd CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] 18/02/2002 03:28 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL

RE: Disable certain users from login to database while applying H

2002-02-19 Thread CHAN Chor Ling Catherine (CSC)
. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat

Disable certain users from login to database while applying Human

2002-02-17 Thread CHAN Chor Ling Catherine (CSC)
://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: Any other OCP discount code ? S36 code can no longer be used

2002-01-11 Thread CHAN Chor Ling Catherine (CSC)
: CHAN Chor Ling Catherine (CSC) Sent: Friday, January 11, 2002 10:40 AM To: Multiple recipients of list ORACLE-L Subject:Any other OCP discount code ? S36 code can

Any other OCP discount code ? S36 code can no longer be used

2002-01-10 Thread CHAN Chor Ling Catherine (CSC)
Dear Gurus, The education discount code S36 can no longer be used to get 20% discount from the OCP Test. Does anyone know of any discount code ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine

RE: Any other OCP discount code ? S36 code can no longer be used

2002-01-10 Thread CHAN Chor Ling Catherine (CSC)
Dear All, I've found the discount code. Regds, New Bee -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Friday, January 11, 2002 10:40 AM To: Multiple recipients of list ORACLE-L

RE: TABLESPACE ALERT

2002-01-08 Thread CHAN Chor Ling Catherine (CSC)
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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: database administration questions

2001-12-26 Thread CHAN Chor Ling Catherine (CSC)
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Mail list for Oracle Applications 11.0 and 11i?

2001-12-14 Thread CHAN Chor Ling Catherine (CSC)
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Upgrade OS from Unix 2.6 to Unix 2.8 for Oracle HRMS Applications

2001-12-10 Thread CHAN Chor Ling Catherine (CSC)
-- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: OCP

2001-12-09 Thread CHAN Chor Ling Catherine (CSC)
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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL

Change sysdate in database to a future date

2001-12-06 Thread CHAN Chor Ling Catherine (CSC)
Hi Gurus, I need to change the sysdate in the database to a future date. Does anyone know the command to do it ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City

RE: Change sysdate in database to a future date

2001-12-06 Thread CHAN Chor Ling Catherine (CSC)
it ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED

RE: Change sysdate in database to a future date

2001-12-06 Thread CHAN Chor Ling Catherine (CSC)
Dear All, I've found the answer. I manage to use the date command in root account to change the date. Thanks. Regds, New Bee -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Friday, December 07, 2001 1:10 PM

RE: Script for next_extent of objects = free space available

2001-10-31 Thread CHAN Chor Ling Catherine (CSC)
Regds, New bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services

Script for next_extent of objects = free space available

2001-10-30 Thread CHAN Chor Ling Catherine (CSC)
, New bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: OT : Is Oracle HRMS 11i 11.5.1 supported in Unix OS 2.8 ?

2001-10-05 Thread CHAN Chor Ling Catherine (CSC)
Hi, I've found the answer. Regds, ChorLing -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Friday, October 05, 2001 12:10 PM To: Multiple recipients of list ORACLE-L Subject

OT : Is Oracle HRMS 11i 11.5.1 supported in Unix OS 2.8 ?

2001-10-04 Thread CHAN Chor Ling Catherine (CSC)
-- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: The DBA in the IS organization

2001-09-16 Thread CHAN Chor Ling Catherine (CSC)
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: SO UPSET FOR ALL AMERICANS

2001-09-12 Thread CHAN Chor Ling Catherine (CSC)
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: OT: STOP THE PRESS!!

2001-09-11 Thread CHAN Chor Ling Catherine (CSC)
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

How to organize oracle directories in Unix ?

2001-09-09 Thread CHAN Chor Ling Catherine (CSC)
-- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: How to organize oracle directories in Unix ?

2001-09-09 Thread CHAN Chor Ling Catherine (CSC)
volume days), we could handle making sure of duplexing redo logs, etc. joe CHAN Chor Ling Catherine (CSC) wrote: Hi Guru, How do you organize your oracle directories in Unix ? I am thinking of using the configurations below. We are using Raid 5 with various mount points. \dg1\oracle

RE: OT : Changing APPLSYS password in Oracle Human

2001-09-05 Thread CHAN Chor Ling Catherine (CSC)
with? Salu2 Mario Alberto Ramos CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] 09/05/01 01:48 AM Hi Mario, Mario wrote : That's not the way it works. I remember I did it once and the right

OT : Changing APPLSYS password in Oracle Human Resources System

2001-09-04 Thread CHAN Chor Ling Catherine (CSC)
are hardcoded in the configuration files. Any pointers ? TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: OT : Changing APPLSYS password in Oracle Human Resources Syst

2001-09-04 Thread CHAN Chor Ling Catherine (CSC)
: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: OT : Changing APPLSYS password in Oracle Human Resources

2001-09-04 Thread CHAN Chor Ling Catherine (CSC)
, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

OT (Unix): Find names of files (in current sub-dir) that contai

2001-08-31 Thread CHAN Chor Ling Catherine (CSC)
-directory as well. TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: OT (Unix): Find names of files (in current sub-dir) that co

2001-08-31 Thread CHAN Chor Ling Catherine (CSC)
in the sub-directory as well. TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET

Drop Recreate table or alter table drop column. Which is

2001-08-29 Thread CHAN Chor Ling Catherine (CSC)
: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing

RE: SQL+ SELECT statement need help

2001-08-27 Thread CHAN Chor Ling Catherine (CSC)
, 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: CHAN Chor Ling

OT: Unix - performance tuning (vmstat 5)

2001-08-22 Thread CHAN Chor Ling Catherine (CSC)
11612 11576 0 18:50:53 pts/11 0:00 grep vmstat orahrms 11271 11263 0 17:30:00 ?0:00 vmstat 5 Please help. Thanks in advance. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City

RE: Unix - performance tuning (vmstat 5)

2001-08-22 Thread CHAN Chor Ling Catherine (CSC)
! Cyril Jaouich (Conseiller Unix) --- Centre de support informatique CSI -- Tél 514-289-1122 x6237 -- De :CHAN Chor Ling Catherine (CSC)[SMTP:[EMAIL PROTECTED]] Répondre à :[EMAIL PROTECTED] Date : mercredi 22

RE: OT: Unix - performance tuning (vmstat 5)

2001-08-22 Thread CHAN Chor Ling Catherine (CSC)
Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Oracle Performance in Unix machine with hardware Raid 5

2001-08-17 Thread CHAN Chor Ling Catherine (CSC)
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: How to create 2 unique indexes (Field1, Field2) and (Field1,

2001-05-31 Thread CHAN Chor Ling Catherine (CSC)
Hi, I would like to thank those who replied. Yes, my problem has been resolved after removing duplicate values in the table. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City

How to encrypt Password in Export script file ?

2001-05-31 Thread CHAN Chor Ling Catherine (CSC)
the system password before passing it as a variable to the export script ? If yes, could I have a copy of your script ? Thanks. Regds, New Bee in Unix -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network

RE: How to encrypt Password in Export script file ?

2001-05-31 Thread CHAN Chor Ling Catherine (CSC)
then change your shell script to read userid=/ and run the script from the exportacct account this way you don't need to hardcode a password ANYWHERE Rachel From: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED

How to drop unique index

2001-05-30 Thread CHAN Chor Ling Catherine (CSC)
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: How to drop unique index

2001-05-30 Thread CHAN Chor Ling Catherine (CSC)
Thanks to all who replied. The command Drop Unique index_name works. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

How to create 2 unique indexes (Field1, Field2) and (Field1, Fiel

2001-05-30 Thread CHAN Chor Ling Catherine (CSC)
keys found Any advice ? Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: recruiters. Aargh. (More on them!)

2001-05-23 Thread CHAN Chor Ling Catherine (CSC)
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

OT : Unix Mail

2001-05-21 Thread CHAN Chor Ling Catherine (CSC)
-- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

RE: OT : Unix Mail

2001-05-21 Thread CHAN Chor Ling Catherine (CSC)
Hi, I've found the answer. Thanks. -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Tuesday, May 22, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Subject:OT : Unix

Shutdown database abort

2001-05-11 Thread CHAN Chor Ling Catherine (CSC)
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

  1   2   >