OT (just responding to say thanks): Re: Scripting and NT

2001-11-11 Thread Casey Dyke

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

2001-11-11 Thread Andrey Bronfin

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

2001-11-11 Thread Andrey Bronfin

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

2001-11-11 Thread Sujatha Madan

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

2001-11-11 Thread Peter . McLarty

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

2001-11-11 Thread Tatireddy, Shrinivas (MED, Keane)

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

2001-11-11 Thread Jeroen van Sluisdam

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

2001-11-11 Thread Prasad BAV

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

2001-11-11 Thread ALEMU Abiy



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