Re: OT : Changing APPLSYS password in Oracle Human Resources

2001-09-04 Thread Jeram
, test it, if it is OK then try in Production, or before doing it take a full backup of your application and database also. Hope this can help you. Thanks Jeram -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, September 05, 2001 10:19 AM That's

Re: 81721 upgrade and event 10520

2001-09-04 Thread Jeram
Hi... If I am not wrong event 10520 is for performance enhancement , ex : by turning this event on it is avoiding unchanged object to be recompile, etc. Rgds/Jeram -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, September 05, 2001 12:50 PM

Re: Roles and Responsibilties

2001-09-05 Thread Jeram
Hi... You can try this link http://www.orafaq.org/faqdbacv.htm Rgds/Jeram -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, September 05, 2001 4:42 AM Hi. My boss asked me to supply him with a detail paper on what DBA functions, roles

Re: Backup Recovery Scenarios

2001-09-05 Thread Jeram
a day 2. Offline Backup once in a month or once in 2 weeks. 3. Logical Backup you can do every night. This is just an example. Rgds/Jeram -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, September 05, 2001 2:11 PM Hi, I want to test

Re: Backup Recovery Scenarios

2001-09-05 Thread Jeram
Oracle Backup and Recovery Book written by Rama Velpuri is a good book to learn, there are some good cases to test and learn. Rgds/Jeram -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, September 05, 2001 2:11 PM Hi, I want to test

Re: Create Database ORA-907 need help

2001-09-05 Thread Jeram
Try to remove the brackets. Rgds/Jeram -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, September 05, 2001 2:27 PM Hi all, Can someone tell me whats wrong with my script ? CREATE DATABASE TEST LOGFILE ( '/test/redo01.log' SIZE 10K

Re: 8i OCP

2001-09-05 Thread Jeram
Buy Oracle8i OCP preparation Guide by Oracle Press, there you can sample of question and Offline test of OCP Rgds/Jeram -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, September 05, 2001 6:39 PM Hi Does anyone have any links (url's

Re: Alter tablespace add datafile

2001-09-05 Thread Jeram
space of your TABLESPACE, it wont see from datafile level... Rgds/Jeram -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thursday, September 06, 2001 8:46 AM One of our datafiles is about to reach it's maxsize. Is the only way around this to do an alter

Re: Test for compatibility with Standard Engine

2001-09-06 Thread Jeram
If you are using just PL/SQL it is full supported in Standard Engine, but if u are using Java programming you will get some problems. Rgds/Jeram -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thursday, September 06, 2001 3:02 PM We develop using

RE: Redo log file sizing

2001-12-07 Thread jeram
. OFA standard is minimum 2 Groups per Database, you can define 3 Groups is OK, and each group s minimum 2 members or 3 members is OK. Hope this can help you Rgds/Jeram -Original Message- Susantio Sent: Thursday, December 06, 2001 10:20 PM To: Multiple recipients of list ORACLE-L Hi

Re: OCP discount is avaialable still?

2002-01-09 Thread jeram
Hi... I think the discount is still available, I am working in IT consultant company and we are a member of Oracle Program Partner, we get the discount until 35% for each Modul. Rgds/Jeram - Original Message - From: Ron Rogers To: Multiple recipients of list

Re: HOW TO KNOW INDEX NOT IN USE?

2002-02-04 Thread Jeram
Hi... If you are using oracle 9i you can refer to this document Note:144070.1 in Metalink. Rgds/Jeram - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 05, 2002 11:40 AM Hi As others said pre Oracle 9i it is hard to find out

Re: Sending email from Unix

2002-02-04 Thread Jeram
Title: Oracle standby strange behavior Hi,,, Try this command : uuencode file1.txt file1.xls|mail destination_email_address Try to get more details in Unix help about uuencode, with this command you can convert txt file to Document or Excel file, or another file format. Rgds/Jeram Oracle

Re: EBU Question

2001-09-16 Thread Jeram
directory. It's just a simple command, and easy to understand and use. Can you give me more details about the problems ? Rgds/Jeram -Original Message-From: Koivu, Lisa [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Date: Friday, September 14

Re: ORA-04030 error

2001-09-16 Thread Jeram
Have applied oracle Patch set for 8.1.7.? Rgds/jeram -Original Message-From: Big Planet [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Date: Saturday, September 15, 2001 8:13 AMSubject: ORA-04030 error Hi All , I am

Re: script to populate tables, i just wrote one

2002-02-18 Thread P Jeram
') 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: P Jeram INET: [EMAIL PROTECTED