OT (just responding to say thanks): Re: Scripting and NT
Thanks to all who responded, in particular Jared for his comprehensive coverage of the Perl side of things. Much appreciated. :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casey Dyke 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: FYI - another good Oracle list
I don't know ... ;-( Try again. Make sure the body of your mail contains ONLY one phrase : SUBSCRIBE ORACLE-L. Also try www.dba-village.com for another list. Good luck ! DBAndrey -Original Message- Sent: Friday, November 09, 2001 10:41 PM To: 'Andrey Bronfin' I get this back from them... -- SUBSCRIBE ORACLE-L Your message did not contain any command. Note that lines starting with a greater than sign ('') are ignored. Summary of resource utilization --- CPU time:0.000 sec Overhead CPU:0.000 sec CPU model: Ultra-80 (4096M) Job origin: [EMAIL PROTECTED] -Original Message- From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]] Sent: Sunday, August 26, 2001 3:14 AM To: LazyDBA.com Discussion Subject: FYI - another good Oracle list Write to [EMAIL PROTECTED] and, in the text of your message (not the subject line), write: SUBSCRIBE ORACLE-L DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT : linux flavors
It's perfectly fine , i'd love to hear different opinions. THANKS A LOT TO ALL WHO RESPONDED !!! DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, November 08, 2001 8:36 PM To: Multiple recipients of list ORACLE-L OOps we are now in danger of confusing DBAndrey by 3 independent people recommending 3 different things Let us NOT start the discussion on which is better in the Forum ;-) Martin -Original Message- Mendoza Sent: 08 November 2001 17:08 To: Multiple recipients of list ORACLE-L For starters, I'd recomend redhat, it's quite friendly. HTH --Yohans On Thu, 8 Nov 2001, Andrey Bronfin wrote: Dear list ! I've got a question that i realize has no correct answer. I want to install Linux at home on my lousy PC. I have NO-WHATSOEVER experience with Linux , although have some knowledge of Solaris HP-UX. I want to pick up a linux flavor that is : 1) Pretty frequently used one , so i can get tutorials , and there are many experienced users to ask questions , and many answers can be found on the web. 2) Closest one to Solaris (or HP-UX or other big UNIX) . 3) Can run on a PC with little memeory . Than U very much in advance for your time. DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yohans Mendoza 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
pfs_mount/umount
Hi, This is more of a Unix question. I am installing v8.1.7 on a HP-UX 11.0 machine. To mount the cd it asks you to use pfs_mount rather than the normal mount/umount. However, when I do pfs_umount, it never wants to eject the CD (or lets you eject it). It shows the file system unmounted but the CD never comes out. Does anyone know of a way around this??? ... assuming I have no free space to copy the CD onto disk. Regards, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: pfs_mount/umount
Hi Sounds like you are running the install from the CD directory, as such you haven't unmounted and therefore you can eject the CD-ROM, do you install from a different directory with a full path to the installer to run it eg peterm@bigserver: /opt$/cdrom/oracle8/runInstaller HTH Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 -- Facsimile: +61 (0)7 3303 3048 Sujatha Madan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/11/2001 02:50 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:pfs_mount/umount Hi, This is more of a Unix question. I am installing v8.1.7 on a HP-UX 11.0 machine. To mount the cd it asks you to use pfs_mount rather than the normal mount/umount. However, when I do pfs_umount, it never wants to eject the CD (or lets you eject it). It shows the file system unmounted but the CD never comes out. Does anyone know of a way around this??? ... assuming I have no free space to copy the CD onto disk. Regards, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
RE: how to find files that are generated on a particular date
sorry forgot to mention that it is Solaris. -Original Message- Sent: Monday, November 12, 2001 2:35 AM To: Multiple recipients of list ORACLE-L Hi lists does anybody can post me a command In unix how can I find files generated on a particulat date example files generated on Nov 10 regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to find files that are generated on a particular date
Hi, Try something like (works on HP-UX, don't have Solaris here): find . -type f | grep Nov 10 . says current directory, use / for the root filesystem as origin Note 2 spaces between Nov and 10 Hth, Jeroen -Oorspronkelijk bericht- Van: Tatireddy, Shrinivas (MED, Keane) [mailto:[EMAIL PROTECTED]] Verzonden: maandag 12 november 2001 7:35 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: how to find files that are generated on a particular date sorry forgot to mention that it is Solaris. -Original Message- Sent: Monday, November 12, 2001 2:35 AM To: Multiple recipients of list ORACLE-L Hi lists does anybody can post me a command In unix how can I find files generated on a particulat date example files generated on Nov 10 regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ASCII Char function
Hi Muths, There is chr() function in PL/SQL. For example select chr(65) from dual will give you the corresponding ascii character. I hope this answers your question. Regards, Prasad BAV. --- Muthaiah [EMAIL PROTECTED] wrote: Hi, I am writing a program to get the ASCII character by giving input as the number. If I give 65, the program should return me A. How can I achieve this in PL/SQL. TIA, Muths _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthaiah 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV 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, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Replication question
I'm setting up a basic replication on a 8.1.7 oracle database and I'm wondering if a schema change is also replicated along with data changes. If I modify the structure of a table on the master site, is that modification is propagated to my snapshot site ? Please help