Re: data manipulation of a large unix file
If you're on 9i, external tables and pipelined table functions should be useful... on 1/22/04 7:59 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: > We are getting a feed of an 800 MB file that will come in nightly. It needs to > be loaded to the database. Per requirements, we have to add some data to the > file before loading(its not negotiable). > > ksh eats up 24% of total CPU on a 4 CPU Solaris box. We cannot do this. I am > not allowed to stream it with a named pipe. any other solutions? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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-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: data manipulation of a large unix file
Ryan - Can you provide more details? Typically ksh scripts are much, much more efficient than alternate methods, such as manipulating data within the database. Depending on which method you are using to measure CPU usage, you may be seeing 1/4 of one CPU. But even if your script is using a full CPU, that may not be unreasonable. The real question is how long the CPU is used. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 9:00 AM To: Multiple recipients of list ORACLE-L We are getting a feed of an 800 MB file that will come in nightly. It needs to be loaded to the database. Per requirements, we have to add some data to the file before loading(its not negotiable). ksh eats up 24% of total CPU on a 4 CPU Solaris box. We cannot do this. I am not allowed to stream it with a named pipe. any other solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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.net -- Author: DENNIS WILLIAMS 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-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: data manipulation of a large unix file
Ryan, Could you cat the second file on to the end of the first file and have the data load successfully? cat file2 >> file1 How about a second box to perform the editing of the data file. Something that resource intensive and manditory should not have a problem getting funded. Ron >>> [EMAIL PROTECTED] 01/22/2004 9:59:41 AM >>> We are getting a feed of an 800 MB file that will come in nightly. It needs to be loaded to the database. Per requirements, we have to add some data to the file before loading(its not negotiable). ksh eats up 24% of total CPU on a 4 CPU Solaris box. We cannot do this. I am not allowed to stream it with a named pipe. any other solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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.net -- Author: Ron Rogers 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-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: data manipulation of a large Unix file
considered Perl ?? also the load you mention is for what? adding data to the data file you get or loading into the db?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, January 22, 2004 10:00 AM To: Multiple recipients of list ORACLE-L We are getting a feed of an 800 MB file that will come in nightly. It needs to be loaded to the database. Per requirements, we have to add some data to the file before loading(its not negotiable). ksh eats up 24% of total CPU on a 4 CPU Solaris box. We cannot do this. I am not allowed to stream it with a named pipe. any other solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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 e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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-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).
data manipulation of a large unix file
We are getting a feed of an 800 MB file that will come in nightly. It needs to be loaded to the database. Per requirements, we have to add some data to the file before loading(its not negotiable). ksh eats up 24% of total CPU on a 4 CPU Solaris box. We cannot do this. I am not allowed to stream it with a named pipe. any other solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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 hide oracle password from a unix ps -ef | grep?
One more... sqlplus <username/password statement1; statement2; exit EOF -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Friday, January 16, 2004 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: how to hide oracle password from a unix ps -ef | grep? Few ideas: 1) sqlplus /nolog connect user/[EMAIL PROTECTED] 2) . $HOME/.orapwd sqlplus user/[EMAIL PROTECTED] (.orapwd script has to set environment variable ORAPWD to the password) 3) sqlplus [EMAIL PROTECTED] < $HOME/.orapwd (.orapwd must contain one line, the password) Tanel. - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Friday, January 16, 2004 8:04 PM Subject: how to hide oracle password from a unix ps -ef | grep? Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?
Re: how to hide oracle password from a unix ps -ef | grep?
> > 2) . $HOME/.orapwd > >sqlplus user/[EMAIL PROTECTED] > > This will actually show password because shell will interpret the ORAPWD > variable before passing the arguments to fork/exec combination. Password > will be clearly visible by "ps -ef". Yep, you're right... I missed this somehow... Thanks, Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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-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 hide oracle password from a unix ps -ef | grep?
On 01/16/2004 01:34:45 PM, Tanel Poder wrote: > Few ideas: > > 1) sqlplus /nolog >connect user/[EMAIL PROTECTED] This requres putting ASCII (non-encrypted) password in the SQL script. Not very safe. > > 2) . $HOME/.orapwd >sqlplus user/[EMAIL PROTECTED] This will actually show password because shell will interpret the ORAPWD variable before passing the arguments to fork/exec combination. Password will be clearly visible by "ps -ef". > > (.orapwd script has to set environment variable ORAPWD to the password) > > 3) sqlplus [EMAIL PROTECTED] < $HOME/.orapwd > > (.orapwd must contain one line, the password) This is semi-decent because password is still in an ASCII file, but hidden. Root (SA) can still read it. If that's acceptable, it's OK, provided that the protection mask is set properly. I would add 4) CREATE USER OPS$MLADEN identified externally - that uses OS authorization and can be easily cracked by root (su -) 5) Oracle advanced security. That is the best answer, supporting Radius, Kerberos and biometrics, but costs $$. I would use 4, despite oracle's claims that this type of authorization is "discouraged" or "deprecated". So is RBO and yet it lives on. That is only a marketing pitch. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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-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 hide oracle password from a unix ps -ef | grep?
Google for hide.c -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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-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 hide oracle password from a unix ps -ef | grep?
Ryan, check this out, if you haven't looked it already, it might help. http://www.orafaq.org/faqunix.htm#HIDEPSW thanks, senthil - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Friday, January 16, 2004 1:04 PM Subject: how to hide oracle password from a unix ps -ef | grep? Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?
Re: how to hide oracle password from a unix ps -ef | grep?
Few ideas: 1) sqlplus /nolog connect user/[EMAIL PROTECTED] 2) . $HOME/.orapwd sqlplus user/[EMAIL PROTECTED] (.orapwd script has to set environment variable ORAPWD to the password) 3) sqlplus [EMAIL PROTECTED] < $HOME/.orapwd (.orapwd must contain one line, the password) Tanel. - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Friday, January 16, 2004 8:04 PM Subject: how to hide oracle password from a unix ps -ef | grep? Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?
RE: how to hide oracle password from a unix ps -ef | grep?
start sqlplus then loginif a script is executing start sqlplus with /nolog then issue a connect command in the script... place the script in a secure location -Original Message-From: Ryan [mailto:[EMAIL PROTECTED]Sent: Friday, January 16, 2004 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: how to hide oracle password from a unix ps -ef | grep? Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?
RE: how to hide oracle password from a unix ps -ef | grep?
Title: Message You can do any of: sqlplus /nolog connect user/[EMAIL PROTECTED] export TWO_TASK=whatever sqlplus user Password: xxx sqlplus [EMAIL PROTECTED] Password: xxx Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown -Original Message-From: Ryan [mailto:[EMAIL PROTECTED] Sent: Friday, January 16, 2004 1:05 PMTo: Multiple recipients of list ORACLE-LSubject: how to hide oracle password from a unix ps -ef | grep? Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?
Re: how to hide oracle password from a unix ps -ef | grep?
Ryan wrote: Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it? Try http://asktom.oracle.com/pls/ask/f?p=4950:8:12188015396454707431::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:142212348066, -- Bricklen Anderson, Database Administrator PresiNET Systems http://www.PresiNET.com Live Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson 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-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 hide oracle password from a unix ps -ef | grep?
Create a dummy user dummy with pw as dummy and only with create session priv. Execute a sql script which will connect to the username/pw and which does not have read privs at os level for others. May be someone on the list has a better idea. HTH GovindanK On Fri, 16 Jan 2004 10:04:35 -0800, "Ryan" <[EMAIL PROTECTED]> said: > Is there a way to log into sqlplus without the username and password > available to anyone who wants to grab it? -- http://www.fastmail.fm - Same, same, but different -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK 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-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 hide oracle password from a unix ps -ef | grep?
Sure. Create the database userid so that it is authenticated externally (Identfied externally). Then the userid can log in via SQL*Plus using a "/" instead of a userid or password. The OS userid should be a controlled account so that everyone and his grandmother cannot log into it. If it is a matter of encryption, turn on encryption by adding the encryption login parameter to the sqlnet.ora file. RWB Reginald W. Bailey IBM Global Services JPMC Account - DCI ETS Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] ox.net To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: how to hide oracle password from a unix ps -ef | grep? ity.com 01/16/2004 12:04 PM Please respond to ORACLE-L Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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-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).
how to hide oracle password from a unix ps -ef | grep?
Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?
RE: Display unix directory hierarchy
It suddenly popped into my head a couple days ago that there could be a problem with the script (isn't it crazy what the subconscious mind does?). Note that when it cd's to a new directory, it ASS-U-MEs that it can do that; and then it calls the script again. I haven't verified if for sure (shoot me now), but I think this could set up a nasty loop. So one should test the readability and executability (??) of the directory before trying to cd into it -- the solution to which is left as an exercise for the reader. (AAAUGH! Yeah, I've had a Math course or two.) > -Original Message- > > In addition to the fine solution from Bambi, Here's another > approach that I > think will work. I did only minimal testing (in TRUE > development tradition. > But ... But ... It worked OK in test!). One caveat: This relies on > recursion, so on a big directory tree you might get swatted > with OS resource > limitations. > > -- > #!/bin/ksh > > if [ $# -eq 1 ]; then >ARG=$1 > else >ARG=0 >export MYNAME="`pwd`/`basename $0`" > fi > > X=0 > PAD="" > while [ $X -lt $ARG ]; do >PAD=$PAD" " >X=$(( X + 1 )) > done > > ## list non-directory files first > for i in `ls -a1 2> /dev/null`; do >if [ "$i" = "." -o "$i" = ".." ]; then > continue >fi >if [ ! -d $i ]; then > echo "$PAD$i" >fi > done > > ## then plow into the directories > ## NO. They ain't "folders". They're "DIRECTORIES". > for i in `ls -a1 2> /dev/null`; do >if [ "$i" = "." -o "$i" = ".." ]; then > continue >fi >if [ -d "$i" ]; then > echo "$PAD/$i" > { > cd "$i" > $MYNAME $(( $ARG + 1 )) > cd .. > } >fi > done > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > 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-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.net -- Author: <[EMAIL PROTECTED] 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-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: Display unix directory hierarchy
In addition to the fine solution from Bambi, Here's another approach that I think will work. I did only minimal testing (in TRUE development tradition. But ... But ... It worked OK in test!). One caveat: This relies on recursion, so on a big directory tree you might get swatted with OS resource limitations. -- #!/bin/ksh if [ $# -eq 1 ]; then ARG=$1 else ARG=0 export MYNAME="`pwd`/`basename $0`" fi X=0 PAD="" while [ $X -lt $ARG ]; do PAD=$PAD" " X=$(( X + 1 )) done ## list non-directory files first for i in `ls -a1 2> /dev/null`; do if [ "$i" = "." -o "$i" = ".." ]; then continue fi if [ ! -d $i ]; then echo "$PAD$i" fi done ## then plow into the directories ## NO. They ain't "folders". They're "DIRECTORIES". for i in `ls -a1 2> /dev/null`; do if [ "$i" = "." -o "$i" = ".." ]; then continue fi if [ -d "$i" ]; then echo "$PAD/$i" { cd "$i" $MYNAME $(( $ARG + 1 )) cd .. } fi done -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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: Display unix directory hierarchy
Here's a freebie... Bambi. = #!/bin/ksh LEVEL=1 INCREMENT=FALSE ls -lR|grep -v ^total|while read i do echo $i|grep ^d >/dev/null 2>/dev/null if [ $? -eq 0 ] ; then continue fi FILE=`echo $i|awk '{print $NF}'` echo $i|grep "\/" >/dev/null 2>/dev/null if [ $? -eq 0 ] ; then LEVEL=`expr \`echo $i|awk -F/ '{print NF}'\` - 1` FILE=`echo $i|awk -F/ '{print "/" $NF}'|sed "s/://"` INCREMENT=TRUE fi CTR=1 while [ $CTR -lt $LEVEL ] ; do echo " \c" let CTR=CTR+1 done echo $FILE if [ $INCREMENT = "TRUE" ] ; then let LEVEL=LEVEL+1 INCREMENT=FALSE fi done|pg == -Original Message- Sent: Tuesday, December 23, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Hi, listers. As documentation for a project, I would like to display some unix directories in hierarchical format and add the output to the documentation set. (Solaris 9) Either flowchart-like or explorer-like will do. Sorta like what is shown below. Does anyone know of a freebie tool that will do this? (Or is this some fancy ls command I'm missing?) Thanks for any help. Barb /dna /orasrv /1.4 /scripts /1.7 /scripts /logs __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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-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.net -- Author: Bellow, Bambi 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-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: Unix question
grep -v try will give you all the lines which do not contain "try" cat |sed "s/try//g" > newfile will strip the characters "try" from all lines HTH, Bambi. -Original Message- Sent: Monday, December 22, 2003 6:54 AM To: Multiple recipients of list ORACLE-L Hallo all of you, Is there anyone whom could help me with the unix command how to find all rows , that doesnt exists "try" in a file. I mean how to find all rows which doesnt have the characters try in. Maybe this is too simple, but would appreciate anyone whom could give me some quick help. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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-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.net -- Author: Bellow, Bambi 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-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: Display unix directory hierarchy
Barbara, You might try tossing the following snippet in a shell script. I call it dtree and you can pass a parameter of a directory. === snip D=${1:-`pwd`} (cd $D; pwd) find $D -type d -print | sort | sed -e "s,^$D,,"\ -e "/^$/d"\ -e "s,[^/]*/\([^/]*\)$,\:-\1,"\ -e "s,[^/]*/,: ,g" == snip ... Output looks like :-somedir1 : :-somedir2 : :-somedir3 : :-somedir4 :-somedir2 :-somedir3 :-somedir4 : :-somedir1 : : :-somedir2 : : :-somedir3 : : :-somedir4 : :-somedir2 : :-somedir3 -Original Message- Sent: Tuesday, December 23, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Hi, listers. As documentation for a project, I would like to display some unix directories in hierarchical format and add the output to the documentation set. (Solaris 9) Either flowchart-like or explorer-like will do. Sorta like what is shown below. Does anyone know of a freebie tool that will do this? (Or is this some fancy ls command I'm missing?) Thanks for any help. Barb /dna /orasrv /1.4 /scripts /1.7 /scripts /logs __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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-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.net -- Author: Seibert, Jason 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-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: Display unix directory hierarchy
Hi Barb, You can use tree/dtree to do this. Windows also has a tree dos command to do the same. HTH Mark -Original Message- Barbara Baker Sent: 23 December 2003 08:49 To: Multiple recipients of list ORACLE-L Hi, listers. As documentation for a project, I would like to display some unix directories in hierarchical format and add the output to the documentation set. (Solaris 9) Either flowchart-like or explorer-like will do. Sorta like what is shown below. Does anyone know of a freebie tool that will do this? (Or is this some fancy ls command I'm missing?) Thanks for any help. Barb /dna /orasrv /1.4 /scripts /1.7 /scripts /logs __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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-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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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-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).
OT: Display unix directory hierarchy
Hi, listers. As documentation for a project, I would like to display some unix directories in hierarchical format and add the output to the documentation set. (Solaris 9) Either flowchart-like or explorer-like will do. Sorta like what is shown below. Does anyone know of a freebie tool that will do this? (Or is this some fancy ls command I'm missing?) Thanks for any help. Barb /dna /orasrv /1.4 /scripts /1.7 /scripts /logs __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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-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: Unix question
Hi, You can use the grep command in the following manner: grep -v try filename The option -v negates the search pattern, meaning rows which do not have a try string in them. The string can be enclosed in double quotes as well, this is useful if you are searching for multiple patterns... Hope this will help. Regards kesh -Original Message-From: Gene Sais [mailto:[EMAIL PROTECTED]Sent: Monday, December 22, 2003 6:39 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Unix question grep command will help you or you could venture to the sed command. grep is probably the most used unix command. To learn more, man grep . >>> [EMAIL PROTECTED] 12/22/03 07:54AM >>>Hallo all of you,Is there anyone whom could help me with the unix command how to find all rows , that doesnt exists "try" in a file.I mean how to find all rows which doesnt have the characters try in.Maybe this is too simple, but would appreciate anyone whom could give me some quick help.Thanks in advanceRoland-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. Visit us at http://www.cognizant.com
Re: Unix question
grep command will help you or you could venture to the sed command. grep is probably the most used unix command. To learn more, man grep . >>> [EMAIL PROTECTED] 12/22/03 07:54AM >>>Hallo all of you,Is there anyone whom could help me with the unix command how to find all rows , that doesnt exists "try" in a file.I mean how to find all rows which doesnt have the characters try in.Maybe this is too simple, but would appreciate anyone whom could give me some quick help.Thanks in advanceRoland-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Unix question
Hallo all of you, Is there anyone whom could help me with the unix command how to find all rows , that doesnt exists "try" in a file. I mean how to find all rows which doesnt have the characters try in. Maybe this is too simple, but would appreciate anyone whom could give me some quick help. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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-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: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv
My bad. IGNORE PREVIOUS. It should be the same as: select * from global_name. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 11, 2003 5:34 PM > Yes. The name must be equal to select name from v$database. > > Yechiel Adar > Mehish > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, December 11, 2003 4:54 PM > > > > Clive, > > > > If the GLOBAL_NAMES parameter is set to true, then you must create the > > database link with the same name as the database to which it connects.. Is > > that the case? > > > > Mark > > > > > > > > -Original Message- > > Hybart, Clive > > Sent: 11 December 2003 12:24 > > To: Multiple recipients of list ORACLE-L > > inv > > > > > > On UNIX 8.1.7 global_names = true > > > > On Zos 390 9i global_names = false > > > > > > Is this causing a mismatch perhaps ? > > > > Regards > > > > Clive > > > > -Original Message- > > Sent: 10 December 2003 12:10 > > To: Multiple recipients of list ORACLE-L > > inv > > > > > > Clive, > > during the upgrade has the global_names parameter somehow been changed > > from false to true? This would cause the connection to be refused if the > > link name does not match the global_name for the target database. > > > > Cheers, > > Mike Hately > > > > -Original Message- > > On Behalf Of Hybart, Clive > > Sent: 10 December 2003 10:39 > > To: Multiple recipients of list ORACLE-L > > > > > > > > Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between > > a Unix box (8.1.7.0) and the mainframe fails. > > However sqlplus using the same connection syntax "Connect > > username/[EMAIL PROTECTED]" is fine. > > Any ideas, peeps ? > > > > > > > > > > > > E mail Disclaimer > > > > You agree that you have read and understood this disclaimer and you > > agree to be bound by its terms. > > > > The information contained in this e-mail and any files transmitted with > > it (if any) are confidential and intended for the addressee only. If > > you have received this e-mail in error please notify the originator. > > > > > > This e-mail and any attachments have been scanned for certain viruses > > prior to sending but CE Electric UK Funding Company nor any of its > > associated companies from whom this e-mail originates shall be liable > > for any losses as a result of any viruses being passed on. > > > > No warranty of any kind is given in respect of any information contained > > in this e-mail and you should be aware that that it might be > > incomplete, out of date or incorrect. It is therefore essential that you > > verify all such information with us before placing any reliance upon it. > > > > CE Electric UK Funding Company > > Lloyds Court > > 78 Grey Street > > Newcastle upon Tyne > > NE1 6AF > > Registered in England and Wales: Number 3476201 > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Hately, Mike (LogicaCMG) > > 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-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.net > > -- > > Author: Hybart, Clive > > 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 mail
Re: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv
Yes. The name must be equal to select name from v$database. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 11, 2003 4:54 PM > Clive, > > If the GLOBAL_NAMES parameter is set to true, then you must create the > database link with the same name as the database to which it connects.. Is > that the case? > > Mark > > > > -Original Message- > Hybart, Clive > Sent: 11 December 2003 12:24 > To: Multiple recipients of list ORACLE-L > inv > > > On UNIX 8.1.7 global_names = true > > On Zos 390 9i global_names = false > > > Is this causing a mismatch perhaps ? > > Regards > > Clive > > -Original Message- > Sent: 10 December 2003 12:10 > To: Multiple recipients of list ORACLE-L > inv > > > Clive, > during the upgrade has the global_names parameter somehow been changed > from false to true? This would cause the connection to be refused if the > link name does not match the global_name for the target database. > > Cheers, > Mike Hately > > -Original Message- > On Behalf Of Hybart, Clive > Sent: 10 December 2003 10:39 > To: Multiple recipients of list ORACLE-L > > > > Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between > a Unix box (8.1.7.0) and the mainframe fails. > However sqlplus using the same connection syntax "Connect > username/[EMAIL PROTECTED]" is fine. > Any ideas, peeps ? > > > > > > E mail Disclaimer > > You agree that you have read and understood this disclaimer and you > agree to be bound by its terms. > > The information contained in this e-mail and any files transmitted with > it (if any) are confidential and intended for the addressee only. If > you have received this e-mail in error please notify the originator. > > > This e-mail and any attachments have been scanned for certain viruses > prior to sending but CE Electric UK Funding Company nor any of its > associated companies from whom this e-mail originates shall be liable > for any losses as a result of any viruses being passed on. > > No warranty of any kind is given in respect of any information contained > in this e-mail and you should be aware that that it might be > incomplete, out of date or incorrect. It is therefore essential that you > verify all such information with us before placing any reliance upon it. > > CE Electric UK Funding Company > Lloyds Court > 78 Grey Street > Newcastle upon Tyne > NE1 6AF > Registered in England and Wales: Number 3476201 > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hately, Mike (LogicaCMG) > 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-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.net > -- > Author: Hybart, Clive > 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-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). > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat
RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv
Clive, If the GLOBAL_NAMES parameter is set to true, then you must create the database link with the same name as the database to which it connects.. Is that the case? Mark -Original Message- Hybart, Clive Sent: 11 December 2003 12:24 To: Multiple recipients of list ORACLE-L inv On UNIX 8.1.7 global_names = true On Zos 390 9i global_names = false Is this causing a mismatch perhaps ? Regards Clive -Original Message- Sent: 10 December 2003 12:10 To: Multiple recipients of list ORACLE-L inv Clive, during the upgrade has the global_names parameter somehow been changed from false to true? This would cause the connection to be refused if the link name does not match the global_name for the target database. Cheers, Mike Hately -Original Message- On Behalf Of Hybart, Clive Sent: 10 December 2003 10:39 To: Multiple recipients of list ORACLE-L Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ? E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) 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-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.net -- Author: Hybart, Clive 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-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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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-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: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv
On UNIX 8.1.7 global_names = true On Zos 390 9i global_names = false Is this causing a mismatch perhaps ? Regards Clive -Original Message- Sent: 10 December 2003 12:10 To: Multiple recipients of list ORACLE-L inv Clive, during the upgrade has the global_names parameter somehow been changed from false to true? This would cause the connection to be refused if the link name does not match the global_name for the target database. Cheers, Mike Hately -Original Message- On Behalf Of Hybart, Clive Sent: 10 December 2003 10:39 To: Multiple recipients of list ORACLE-L Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ? E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) 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-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.net -- Author: Hybart, Clive 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-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: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
Title: Message Tnsnames is used to resolve aliases - we are currently looking at the global_names parameter -Original Message-From: Hybart, Clive [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 15:19To: Multiple recipients of list ORACLE-LSubject: RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid Usual ORA-01017 Mark Invalid username/password and yet SQLPLUS is quite happy with the same login -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 11:59To: Multiple recipients of list ORACLE-LSubject: RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid Hi there Clive! :) < SPAN class=814030411-10122003> Are you getting any specific errors - and if so, what are they? Cheers Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hybart, CliveSent: 10 December 2003 10:39To: Multiple recipients of list ORACLE-LSubject: Dblink fails be tween 8.1.7 (Unix) and 9i (Zos 390) due to invalid Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ?
Re: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
How are you resolving your aliases on the unix box and on your client? Are you using onames for both (check your sqlnet.ora at both locations) or are you using local copies of tnsnames.ora? (or some other method). "Hybart, Clive" @metoffice.com> cc: Sent by: Subject: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid ml-errors 12/10/2003 05:39 AM Please respond to ORACLE-L Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day 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-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: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
Title: Message Usual ORA-01017 Mark Invalid username/password and yet SQLPLUS is quite happy with the same login -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 11:59To: Multiple recipients of list ORACLE-LSubject: RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid Hi there Clive! :) Are you getting any specific errors - and if so, what are they? Cheers Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hybart, CliveSent: 10 December 2003 10:39To: Multiple recipients of list ORACLE-LSubject: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ?
RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv
Clive, during the upgrade has the global_names parameter somehow been changed from false to true? This would cause the connection to be refused if the link name does not match the global_name for the target database. Cheers, Mike Hately -Original Message- On Behalf Of Hybart, Clive Sent: 10 December 2003 10:39 To: Multiple recipients of list ORACLE-L Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ? E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) 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-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: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
Title: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid username or password Hi there Clive! :) Are you getting any specific errors - and if so, what are they? Cheers Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hybart, CliveSent: 10 December 2003 10:39To: Multiple recipients of list ORACLE-LSubject: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ?
Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
Title: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid username or password Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ?
Re: Unix scripts on Windows 2000 after installing MKS tool kit
Carel, Thank you very much for your response and advise. I have started testing with little problem so far... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 03 Dec 2003 00:59:26 -0800 > Hi > > Has anybody experience with using unix scripts on Windows 2000 after > installing MKS toolkit? > Are those scripts run without major modification (after changing > path/folder > related info). > > My client wants to run their unix shell scripts on their Windows platform > after installing MKS toolkit version 8.6. > > Regards > Rafiq > Hi, Last week I installed my dataguard scripts with a customer using MKS. I developed them on Linux and Solaris. No serious problems, except with dynamic generation of pathnames from database views (replace '\' by '/') and some colon-related problems when using rcp/scp (e.g. rcp ${SHOST}:D:\ORACLE\ORADATA\SID\SYSTEM01.ORA \ ${DHOST}:D:\ORACLE\ORADATA\SID\SYSTEM01.ORA ) doesn't work. replace D: by D= (and replace backslashes, of course), and all's fine. I got ssh to work, although setting passwordless authentication didn't work. Because the customer has a closed environment, rsh/rcp was sufficient. Be aware that NTFS is needed to set protection for .rhosts and rsa/dsa private key files. Success, Carel-Jan -- There will allways be another last 10 bugs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel 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-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). _ Get holiday tips for festive fun. http://special.msn.com/network/happyholidays.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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-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: Unix scripts on Windows 2000 after installing MKS tool kit
> Hi > > Has anybody experience with using unix scripts on Windows 2000 after > installing MKS toolkit? > Are those scripts run without major modification (after changing > path/folder > related info). > > My client wants to run their unix shell scripts on their Windows platform > after installing MKS toolkit version 8.6. > > Regards > Rafiq > Hi, Last week I installed my dataguard scripts with a customer using MKS. I developed them on Linux and Solaris. No serious problems, except with dynamic generation of pathnames from database views (replace '\' by '/') and some colon-related problems when using rcp/scp (e.g. rcp ${SHOST}:D:\ORACLE\ORADATA\SID\SYSTEM01.ORA \ ${DHOST}:D:\ORACLE\ORADATA\SID\SYSTEM01.ORA ) doesn't work. replace D: by D= (and replace backslashes, of course), and all's fine. I got ssh to work, although setting passwordless authentication didn't work. Because the customer has a closed environment, rsh/rcp was sufficient. Be aware that NTFS is needed to set protection for .rhosts and rsa/dsa private key files. Success, Carel-Jan -- There will allways be another last 10 bugs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel 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-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).
Unix scripts on Windows 2000 after installing MKS tool kit
Hi Has anybody experience with using unix scripts on Windows 2000 after installing MKS toolkit? Are those scripts run without major modification (after changing path/folder related info). My client wants to run their unix shell scripts on their Windows platform after installing MKS toolkit version 8.6. Regards Rafiq _ Winterize your home with tips from MSN House & Home. http://special.msn.com/home/warmhome.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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-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: UNIX OT: exclude files in tar
Expanding the logic to its logical conclusion, we produce philosophies similar to that found at www.despair.com. CONSULTING: If you aren't part of the solution, then there is good money to be made in prolonging the problem. > -Original Message- > > I like that logic! I might just start (ab)using Perl now. > > Thanks to all replies. Now I've got a few options to play > around with to do > this 'exclude files' and not necessarily tar . > > > > -Original Message- > > > > > > > > On 11/25/2003 11:44:26 AM, [EMAIL PROTECTED] wrote: > > > > > > Maybe can use -prune option of find to send file list to tar: > > > > > > > Why do it in a simple way when there is an opportunity to > > (ab)use perl? > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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: UNIX OT: exclude files in tar
I like that logic! I might just start (ab)using Perl now. Thanks to all replies. Now I've got a few options to play around with to do this 'exclude files' and not necessarily tar . Rgds, Ross > -Original Message- > From: Mladen Gogala [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 26 November 2003 6:25 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: UNIX OT: exclude files in tar > > > > On 11/25/2003 11:44:26 AM, [EMAIL PROTECTED] wrote: > > > > Maybe can use -prune option of find to send file list to tar: > > > > Why do it in a simple way when there is an opportunity to > (ab)use perl? > > Mladen Gogala > Oracle DBA > > > > Note: > This message is for the named person's use only. It may > contain confidential, proprietary or legally privileged > information. No confidentiality or privilege is waived or > lost by any mistransmission. If you receive this message in > error, please immediately delete it and all copies of it from > your system, destroy any hard copies of it and notify the > sender. You must not, directly or indirectly, use, disclose, > distribute, print, or copy any part of this message if you > are not the intended recipient. Wang Trading LLC and any of > its subsidiaries each reserve the right to monitor all e-mail > communications through its networks. > Any views expressed in this message are those of the > individual sender, except where the message states otherwise > and the sender is authorized to state them to be the views of > any such entity. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > 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-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.net -- Author: Ross Collado 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-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: UNIX OT: exclude files in tar
On 11/25/2003 11:44:26 AM, [EMAIL PROTECTED] wrote: > > Maybe can use -prune option of find to send file list to tar: > Why do it in a simple way when there is an opportunity to (ab)use perl? Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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-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: UNIX OT: exclude files in tar
Then I'll pipe it to cpio -H tar, which will solve the problem. On 11/25/2003 01:24:26 PM, Tanel Poder wrote: > This approach might cause problems, if you have really lots of files -> your > shell argument buffer (or whatever is the correct name for it) becomes full > > Tanel. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, November 25, 2003 4:54 PM > > > > I never rely on tar to do that. Here is the trick that I use when I want > to be selective: > > > > tar zcvf /tmp/test1.tgz `perl -e 'foreach (<*.pl>) { if (/connect/) > {print "$_\n";}}'` > > > > Basically, you write a small perl script which will output only the files > > you want and hand that to tar. Works each and every time. That is > precisely > > why Unix is such a great OS and Slowaris definitely is Unix, unless SCO > > has revoked the license. > > > > On 11/25/2003 12:24:26 AM, Ross Collado wrote: > > > Hello, > > > > > > On Solaris 8 > > > > > > I can't seem to get the tar command right. I wanted to tar a directory > but > > > EXCLUDE one of the subdirectory in it. > > > Example: > > > /home/user01 > > > /home/user01/mark01 > > > /home/user01/mark01/ask.txt > > > /home/user01/mark01/ghost.txt > > > /home/user01/mark02 > > > /home/user01/mark02/ask.txt > > > /home/user01/mark02/ghost.txt > > > /home/user01/mark03 > > > /home/user01/mark03/ask.txt > > > /home/user01/mark03/ghost.txt > > > > > > I wanted to tar everything except /home/user01/mark03/* > > > man pages on tar says there is an option to exclude files but I just > can't > > > get it to work for me. > > > > > > Can someone show me how to do this right? > > > > > > Thanks, > > > Ross > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Ross Collado > > > 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-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). > > > > > > > Mladen Gogala > > Oracle DBA > > > > > > > > Note: > > This message is for the named person's use only. It may contain > confidential, proprietary or legally privileged information. No > confidentiality or privilege is waived or lost by any mistransmission. If > you receive this message in error, please immediately delete it and all > copies of it from your system, destroy any hard copies of it and notify the > sender. You must not, directly or indirectly, use, disclose, distribute, > print, or copy any part of this message if you are not the intended > recipient. Wang Trading LLC and any of its subsidiaries each reserve the > right to monitor all e-mail communications through its networks. > > Any views expressed in this message are those of the individual sender, > except where the message states otherwise and the sender is authorized to > state them to be the views of any such entity. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > 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-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.net > -- > Author: Tanel Poder > INET: [EMAIL PROTECTED] > > Fat Cit
Re: UNIX OT: exclude files in tar
This approach might cause problems, if you have really lots of files -> your shell argument buffer (or whatever is the correct name for it) becomes full Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, November 25, 2003 4:54 PM > I never rely on tar to do that. Here is the trick that I use when I want to be selective: > > tar zcvf /tmp/test1.tgz `perl -e 'foreach (<*.pl>) { if (/connect/) {print "$_\n";}}'` > > Basically, you write a small perl script which will output only the files > you want and hand that to tar. Works each and every time. That is precisely > why Unix is such a great OS and Slowaris definitely is Unix, unless SCO > has revoked the license. > > On 11/25/2003 12:24:26 AM, Ross Collado wrote: > > Hello, > > > > On Solaris 8 > > > > I can't seem to get the tar command right. I wanted to tar a directory but > > EXCLUDE one of the subdirectory in it. > > Example: > > /home/user01 > > /home/user01/mark01 > > /home/user01/mark01/ask.txt > > /home/user01/mark01/ghost.txt > > /home/user01/mark02 > > /home/user01/mark02/ask.txt > > /home/user01/mark02/ghost.txt > > /home/user01/mark03 > > /home/user01/mark03/ask.txt > > /home/user01/mark03/ghost.txt > > > > I wanted to tar everything except /home/user01/mark03/* > > man pages on tar says there is an option to exclude files but I just can't > > get it to work for me. > > > > Can someone show me how to do this right? > > > > Thanks, > > Ross > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Ross Collado > > 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-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). > > > > Mladen Gogala > Oracle DBA > > > > Note: > This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. > Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > 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-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.net -- Author: Tanel Poder 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-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: UNIX OT: exclude files in tar
You can use the -L option and have a file listing everything you want ie, ls > file edit file and remove the dir you don't want tar files with the -L option and the file you created above. never done this myself -Original Message- [EMAIL PROTECTED] Sent: 25 November 2003 16:44 To: Multiple recipients of list ORACLE-L Maybe can use -prune option of find to send file list to tar: cd /home find ./user01 -name mark03 -prune -o -print > -Original Message- > > > > I can't seem to get the tar command right. I wanted to tar > a directory but > > EXCLUDE one of the subdirectory in it. > > Example: > > /home/user01 > > /home/user01/mark01 > > /home/user01/mark01/ask.txt > > /home/user01/mark01/ghost.txt > > /home/user01/mark02 > > /home/user01/mark02/ask.txt > > /home/user01/mark02/ghost.txt > > /home/user01/mark03 > > /home/user01/mark03/ask.txt > > /home/user01/mark03/ghost.txt > > > > I wanted to tar everything except /home/user01/mark03/* > > man pages on tar says there is an option to exclude files > but I just can't > > get it to work for me. > > > > Can someone show me how to do this right? > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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). ** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe 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-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: UNIX OT: exclude files in tar
Maybe can use -prune option of find to send file list to tar: cd /home find ./user01 -name mark03 -prune -o -print > -Original Message- > > > > I can't seem to get the tar command right. I wanted to tar > a directory but > > EXCLUDE one of the subdirectory in it. > > Example: > > /home/user01 > > /home/user01/mark01 > > /home/user01/mark01/ask.txt > > /home/user01/mark01/ghost.txt > > /home/user01/mark02 > > /home/user01/mark02/ask.txt > > /home/user01/mark02/ghost.txt > > /home/user01/mark03 > > /home/user01/mark03/ask.txt > > /home/user01/mark03/ghost.txt > > > > I wanted to tar everything except /home/user01/mark03/* > > man pages on tar says there is an option to exclude files > but I just can't > > get it to work for me. > > > > Can someone show me how to do this right? > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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: UNIX OT: exclude files in tar
tar cvf /tmp/test1.tar `perl -e 'foreach On 11/25/2003 12:24:26 AM, Ross Collado wrote: > Hello, > > On Solaris 8 > > I can't seem to get the tar command right. I wanted to tar a directory but > EXCLUDE one of the subdirectory in it. > Example: > /home/user01 > /home/user01/mark01 > /home/user01/mark01/ask.txt > /home/user01/mark01/ghost.txt > /home/user01/mark02 > /home/user01/mark02/ask.txt > /home/user01/mark02/ghost.txt > /home/user01/mark03 > /home/user01/mark03/ask.txt > /home/user01/mark03/ghost.txt > Here is how to do it: Create script called /tmp/tmp1.pl containing the following: #!/usr/bin/perl open FL,"find /home -print|"||die "Cannot open file:$!\n"; $pattern="\/mark03\/"; while () { chomp; if (/$pattern/) { next; } print "$_\n"; } Purists will cringe when seeing a script without "use strict" and executing "find" but it's short and it works. Next, you chmod /tmp/tmp1.pl to 700 and do tar cvf /mydir/myfile.tar `/tmp/tmp1.pl` It works each and every time. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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-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: UNIX OT: exclude files in tar
I never rely on tar to do that. Here is the trick that I use when I want to be selective: tar zcvf /tmp/test1.tgz `perl -e 'foreach (<*.pl>) { if (/connect/) {print "$_\n";}}'` Basically, you write a small perl script which will output only the files you want and hand that to tar. Works each and every time. That is precisely why Unix is such a great OS and Slowaris definitely is Unix, unless SCO has revoked the license. On 11/25/2003 12:24:26 AM, Ross Collado wrote: > Hello, > > On Solaris 8 > > I can't seem to get the tar command right. I wanted to tar a directory but > EXCLUDE one of the subdirectory in it. > Example: > /home/user01 > /home/user01/mark01 > /home/user01/mark01/ask.txt > /home/user01/mark01/ghost.txt > /home/user01/mark02 > /home/user01/mark02/ask.txt > /home/user01/mark02/ghost.txt > /home/user01/mark03 > /home/user01/mark03/ask.txt > /home/user01/mark03/ghost.txt > > I wanted to tar everything except /home/user01/mark03/* > man pages on tar says there is an option to exclude files but I just can't > get it to work for me. > > Can someone show me how to do this right? > > Thanks, > Ross > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ross Collado > 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-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). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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-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: UNIX OT: exclude files in tar
It doesn't use the exclude, but it would do what you want: cd /home/user01 tar -cvf /dev/rmt0 mark01 mark02 where /dev/rmt0 is your tape device, or you can substitute a disk destination. HTH, Mike Ross Collado <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> hpac.com>cc: Sent by: Subject: UNIX OT: exclude files in tar [EMAIL PROTECTED] .com 11/25/2003 12:24 AM Please respond to ORACLE-L Hello, On Solaris 8 I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01 /home/user01/mark01 /home/user01/mark01/ask.txt /home/user01/mark01/ghost.txt /home/user01/mark02 /home/user01/mark02/ask.txt /home/user01/mark02/ghost.txt /home/user01/mark03 /home/user01/mark03/ask.txt /home/user01/mark03/ghost.txt I wanted to tar everything except /home/user01/mark03/* man pages on tar says there is an option to exclude files but I just can't get it to work for me. Can someone show me how to do this right? Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado 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-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.net -- Author: Michael Boligan 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-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: UNIX OT: exclude files in tar
Just another excuse to read the tar man page. This series of commands seamed to work in testing. Note the "excluded" and "OK" on the tar command output. As the tar man page states, be careful on the leading and trailing spaces in the exclude file. As with most Unix commands, DON'T use a "-" in the exclude file name, doing so will lead you to question your own sanity when things just don't seam to work right. mkdir -p level.1/level.2.1/level.2.1.1 \ level.1/level.2.1/level.2.1.2 \ level.1/level.2.2/level.2.2.1 \ level.1/level.2.3/level.2.3.1 touch level.1/level.2.1/level.2.1.1/yes.level.2.1.1 \ level.1/level.2.1/level.2.1.2/no.level.2.1.1 \ level.1/level.2.2/yes.2.2.1 \ level.1/level.2.2/level.2.2.1/no.2.2.1\ level.1/level.2.3/level.2.3.1/yes.2.3.1 echo "level.1/level.2.1/level.2.1.2" >exclude.file echo "level.1/level.2.2/level.2.2.1" >>exclude.file tar -cvfX myfiles.tar exclude.file level.1 tar -tvf myfiles.tar find . -name '*' -type f ls -Fla uname -a 24956:[EMAIL PROTECTED]> tar -cvfX myfiles.tar exclude.file level.1 a level.1/ 0K a level.1/level.2.1/ 0K a level.1/level.2.1/level.2.1.1/ 0K a level.1/level.2.1/level.2.1.1/yes.level.2.1.1 0K a level.1/level.2.1/level.2.1.2 excluded a level.1/level.2.2/ 0K a level.1/level.2.2/level.2.2.1 excluded a level.1/level.2.2/yes.2.2.1 0K a level.1/level.2.3/ 0K a level.1/level.2.3/level.2.3.1/ 0K a level.1/level.2.3/level.2.3.1/yes.2.3.1 0K 24956:[EMAIL PROTECTED]> tar -tvf myfiles.tar tar: blocksize = 11 drwxr-xr-x 101/2000 0 Nov 24 22:46 2003 level.1/ drwxr-xr-x 101/2000 0 Nov 24 22:46 2003 level.1/level.2.1/ drwxr-xr-x 101/2000 0 Nov 24 22:46 2003 level.1/level.2.1/level.2.1.1/ -rw-r--r-- 101/2000 0 Nov 24 22:46 2003 level.1/level.2.1/level.2.1.1/yes.level.2.1.1 drwxr-xr-x 101/2000 0 Nov 24 22:46 2003 level.1/level.2.2/ -rw-r--r-- 101/2000 0 Nov 24 22:46 2003 level.1/level.2.2/yes.2.2.1 drwxr-xr-x 101/2000 0 Nov 24 22:46 2003 level.1/level.2.3/ drwxr-xr-x 101/2000 0 Nov 24 22:46 2003 level.1/level.2.3/level.2.3.1/ -rw-r--r-- 101/2000 0 Nov 24 22:46 2003 level.1/level.2.3/level.2.3.1/yes.2.3.1 24956:[EMAIL PROTECTED]> find . -name '*' -type f ./level.1/level.2.1/level.2.1.1/yes.level.2.1.1 ./level.1/level.2.1/level.2.1.2/no.level.2.1.1 ./level.1/level.2.2/level.2.2.1/no.2.2.1 ./level.1/level.2.2/yes.2.2.1 ./level.1/level.2.3/level.2.3.1/yes.2.3.1 ./myfiles.tar ./exclude.file 24956:[EMAIL PROTECTED]> ls -Fla total 80 drwxr-xr-x 3 oracle dba 318 Nov 24 22:52 ./ drwxrwxrwt 13 root sys 8057 Nov 24 22:59 ../ -rw-r--r-- 1 oracle dba 60 Nov 24 22:46 exclude.file drwxr-xr-x 5 oracle dba 315 Nov 24 22:46 level.1/ -rw-r--r-- 1 oracle dba 5632 Nov 24 22:53 myfiles.tar 24956:[EMAIL PROTECTED]> uname -a SunOS bigkahuna 5.8 Generic_108528-22 sun4u sparc SUNW,Ultra-Enterprise Ross Collado <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> hpac.com>cc: Sent by: Subject: UNIX OT: exclude files in tar [EMAIL PROTECTED] .com 11/24/2003 10:24 PM Please respond to ORACLE-L Hello, On Solaris 8 I can't seem to get the tar command
UNIX OT: exclude files in tar
Hello, On Solaris 8 I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01 /home/user01/mark01 /home/user01/mark01/ask.txt /home/user01/mark01/ghost.txt /home/user01/mark02 /home/user01/mark02/ask.txt /home/user01/mark02/ghost.txt /home/user01/mark03 /home/user01/mark03/ask.txt /home/user01/mark03/ghost.txt I wanted to tar everything except /home/user01/mark03/* man pages on tar says there is an option to exclude files but I just can't get it to work for me. Can someone show me how to do this right? Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado 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-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: unix question
Something our Unix admins tend to do is move the files along different directories. E.g. they start in dir1; after succesfull backup, move them to dir2, etc. and after succesfull backup in dir4 delete them. So they should always get backed up 4 times even if you miss a run. Of course your backup needs to start in dir4 and work back to dir1 for obvious reasons. mvg/regards Jo [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/19/2003 21:20 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: unix question I want to store some files. I make a new copy every night. I want to archive it back 4 days. So after 4 days, I want to delete the old copy. How do I do this? However, if i miss a nightly batch and have less than 4 copies, I do not want to delete any? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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.net -- Author: 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-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: unix question
The following statement will delete all files older than 5 days: find . -name 'files_you_want_to_delete*.log' -mtime +5 -exec rm {} \; To test it, change the name of the file name and change the 'rm' to 'ls'. It should just list the files older than 5 days. That way you know it is working. Ron Smith -Original Message- Sent: Wednesday, November 19, 2003 3:10 PM To: Multiple recipients of list ORACLE-L USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE. COUNT=`ls -lrt /|wc -l` if [ $COUNT -ge 4 ] ; then find -name -mtime +4 -exec rm -f {} \; fi USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE. HTH, Bambi. -Original Message- Sent: Wednesday, November 19, 2003 2:21 PM To: Multiple recipients of list ORACLE-L I want to store some files. I make a new copy every night. I want to archive it back 4 days. So after 4 days, I want to delete the old copy. How do I do this? However, if i miss a nightly batch and have less than 4 copies, I do not want to delete any? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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.net -- Author: Bellow, Bambi 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-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). 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 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-- Mailing list and web hosting services - 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: unix question
USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE. COUNT=`ls -lrt /|wc -l` if [ $COUNT -ge 4 ] ; then find -name -mtime +4 -exec rm -f {} \; fi USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE. HTH, Bambi. -Original Message- Sent: Wednesday, November 19, 2003 2:21 PM To: Multiple recipients of list ORACLE-L I want to store some files. I make a new copy every night. I want to archive it back 4 days. So after 4 days, I want to delete the old copy. How do I do this? However, if i miss a nightly batch and have less than 4 copies, I do not want to delete any? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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.net -- Author: Bellow, Bambi 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-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: unix question
How about something like dir=foo if [ `ls -1 $dir` -lt 4 ]; then find $dir -mtime +4 | xargs rm fi On Wed, 2003-11-19 at 15:20, [EMAIL PROTECTED] wrote: > I want to store some files. I make a new copy every night. I want to archive it back > 4 days. So after 4 days, I want to delete the old copy. How do I do this? > > However, if i miss a nightly batch and have less than 4 copies, I do not want to > delete any? > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems & Computing, DBMS Virginia Tech -- "Please give me some good advice in your next letter. I promise not to follow it." -- Edna St. Vincent Millay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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-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: unix question
How about something like ... find /your_dir_name_here -name '*.log' -mtime +4 -exec \ rm {} \; Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, November 19, 2003 3:21 PM To: Multiple recipients of list ORACLE-L I want to store some files. I make a new copy every night. I want to archive it back 4 days. So after 4 days, I want to delete the old copy. How do I do this? However, if i miss a nightly batch and have less than 4 copies, I do not want to delete any? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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 e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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-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).
unix question
I want to store some files. I make a new copy every night. I want to archive it back 4 days. So after 4 days, I want to delete the old copy. How do I do this? However, if i miss a nightly batch and have less than 4 copies, I do not want to delete any? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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: UNIX OT: deleting file starting with --
Many unix commands recognize the '--' parameter. What this means on the command line is that everything entered after the -- is not a switch, but an argument. 'rm -- --cart' will delete the file. man getopt for details. Jared On Thu, 2003-10-30 at 20:44, Ross Collado wrote: > Hi, > How do I delete a file named --cart ? > Thanks, > Ross > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ross Collado > 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-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.net -- Author: Jared Still 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-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: UNIX OT: deleting file starting with --
Ross Collado wrote: Hi, How do I delete a file named --cart ? Thanks, Ross touch -- --card ls -al -- --card rm -- --card ls -al -- --card -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun 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-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: UNIX OT: deleting file starting with --
rm -i ??cart -Original Message- Sent: 31 October 2003 12:44 To: Multiple recipients of list ORACLE-L Hi, How do I delete a file named --cart ? Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado 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-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.net -- Author: Sinardy Xing 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-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: UNIX OT: deleting file starting with --
We just had one like this. Our UNIX SA said to use the fully-qualified path to the file, as in rm -i /this/is/the/path/to/--cart HTH, Mike -Original Message- Sent: Thursday, October 30, 2003 8:44 PM To: Multiple recipients of list ORACLE-L Hi, How do I delete a file named --cart ? Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado 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-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.net -- Author: Vergara, Michael (TEM) 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-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).
UNIX OT: deleting file starting with --
Hi, How do I delete a file named --cart ? Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado 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-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: RE: wait/notify syntax for unix help please
There's no problem with waiting after the process has already finished, you'll just get a non-zero return code the wait but evrything will still work fine. Chris -Original Message- Sent: 27 October 2003 18:54 To: Multiple recipients of list ORACLE-L if you attemp to wait after the process is complete, will it cause a problem? say the PID no longer exists when you issue wait? > > From: "Dunscombe, Chris" <[EMAIL PROTECTED]> > Date: 2003/10/27 Mon AM 11:39:34 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: wait/notify syntax for unix help please > > I don't know about Solaris but on HP-UX and AIX you can do: > > run_sql_1 & > run_sql_2 & > wait > > This will wait until both have finished. > > Re a specific PID $! will return you PID of the last child process and then > you can wait on that PID. Looks something like: > > run_sql_1 & > run_sql_2 & > PID_WAIT=$! > wait ${PID_WAIT} > > HTH > > Chris Dunscombe > > > -Original Message- > Sent: 27 October 2003 16:09 > To: Multiple recipients of list ORACLE-L > > > I need to parallelize some sql operations and Im running them from unix > scripts. > > I want to spawn off a few in the background from a master script, then have > the master script 'wait' for them to finish. Ive done this in Java and with > dbms_alert, but I cant dig up the syntax to do this with korn shell on > solaris. > > Also, if I want to wait for a specific PID, how do I get the PID of the > thread I want to wait for? > > so I have > > nohup run_sql & > > wait(on previous nohup) > > then to use notify, I just use 'notify()' inside the script right? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > 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-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.net > -- > Author: Dunscombe, Chris > 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-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.net -- Author: <[EMAIL PROTECTED] 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-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.net -- Author: Dunscombe, Chris 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-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: RE: wait/notify syntax for Unix help please
Mladen Gogala scribbled on the wall in glitter crayon: > On 10/27/2003 01:54:25 PM, [EMAIL PROTECTED] wrote: >> if you attemp to wait after the process is complete, will it cause a >> problem? say the PID no longer exists when you issue wait? > > Why don't you try it? There is this phenomenal Unix IDE called "vi" > which can help you to write a shell script and O'Reilly has a book > explaini9ng how to use it. There is also a heresy against The One True > Editor called "Emacs", but I'd advise against it. Emacs is a nice operating system, but i prefer Unix.;-) -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] I cannot imagine a God who rewards and punishes the objects of his creation, whose purposes are modelled after our own - a God, in short, who is but a reflection of human frailty. Neither can I believe that the individual survives the death of his body, although feeble souls harbour such thoughts through fear or ridiculous egotisms. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William 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-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: RE: wait/notify syntax for unix help please
On 10/27/2003 01:54:25 PM, [EMAIL PROTECTED] wrote: if you attemp to wait after the process is complete, will it cause a problem? say the PID no longer exists when you issue wait? Why don't you try it? There is this phenomenal Unix IDE called "vi" which can help you to write a shell script and O'Reilly has a book explaini9ng how to use it. There is also a heresy against The One True Editor called "Emacs", but I'd advise against it. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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-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: RE: wait/notify syntax for unix help please
if you attemp to wait after the process is complete, will it cause a problem? say the PID no longer exists when you issue wait? > > From: "Dunscombe, Chris" <[EMAIL PROTECTED]> > Date: 2003/10/27 Mon AM 11:39:34 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: wait/notify syntax for unix help please > > I don't know about Solaris but on HP-UX and AIX you can do: > > run_sql_1 & > run_sql_2 & > wait > > This will wait until both have finished. > > Re a specific PID $! will return you PID of the last child process and then > you can wait on that PID. Looks something like: > > run_sql_1 & > run_sql_2 & > PID_WAIT=$! > wait ${PID_WAIT} > > HTH > > Chris Dunscombe > > > -Original Message- > Sent: 27 October 2003 16:09 > To: Multiple recipients of list ORACLE-L > > > I need to parallelize some sql operations and Im running them from unix > scripts. > > I want to spawn off a few in the background from a master script, then have > the master script 'wait' for them to finish. Ive done this in Java and with > dbms_alert, but I cant dig up the syntax to do this with korn shell on > solaris. > > Also, if I want to wait for a specific PID, how do I get the PID of the > thread I want to wait for? > > so I have > > nohup run_sql & > > wait(on previous nohup) > > then to use notify, I just use 'notify()' inside the script right? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > 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-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.net > -- > Author: Dunscombe, Chris > 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-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.net -- Author: <[EMAIL PROTECTED] 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-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: wait/notify syntax for unix help please
Here's another idea. Expand on it and modify as needed. COUNT=1 while [ $COUNT -le 8 ]; do ## The first jobs command is to clear out any "jobs completed" messages. jobs > /dev/null if [ -z "`jobs`" ]; then break; fi sleep 30 COUNT=$(( $COUNT + 1 )) done jobs > /dev/null echo "SLEPT $COUNT times" >> "$LOG_FILE" ## Kill any remaining jobs. for JOB_NUMBER in `jobs | sed 's/\([^0-9]*\)\([1-9][0-9]*\)\(.*\)/\2/'`; do kill %${JOB_NUMBER} echo "killed job number $JOB_NUMBER" >> "$LOG_FILE" done > > I need to parallelize some sql operations and Im running them > from unix > scripts. > > I want to spawn off a few in the background from a master > script, then have > the master script 'wait' for them to finish. Ive done this in > Java and with > dbms_alert, but I cant dig up the syntax to do this with korn shell on > solaris. > > Also, if I want to wait for a specific PID, how do I get the > PID of the > thread I want to wait for? > > so I have > > nohup run_sql & > > wait(on previous nohup) > > then to use notify, I just use 'notify()' inside the script right? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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: wait/notify syntax for unix help please
I don't know about Solaris but on HP-UX and AIX you can do: run_sql_1 & run_sql_2 & wait This will wait until both have finished. Re a specific PID $! will return you PID of the last child process and then you can wait on that PID. Looks something like: run_sql_1 & run_sql_2 & PID_WAIT=$! wait ${PID_WAIT} HTH Chris Dunscombe -Original Message- Sent: 27 October 2003 16:09 To: Multiple recipients of list ORACLE-L I need to parallelize some sql operations and Im running them from unix scripts. I want to spawn off a few in the background from a master script, then have the master script 'wait' for them to finish. Ive done this in Java and with dbms_alert, but I cant dig up the syntax to do this with korn shell on solaris. Also, if I want to wait for a specific PID, how do I get the PID of the thread I want to wait for? so I have nohup run_sql & wait(on previous nohup) then to use notify, I just use 'notify()' inside the script right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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.net -- Author: Dunscombe, Chris 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-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: wait/notify syntax for unix help please
I know that bash has "wait" built in. It works like this: GODOT=`ps -fu $LOGNAME|grep sqlplus|grep -v PID|perl -e 'while (<>) [EMAIL PROTECTED] /\s+/; print "$A[1] "}'` wait $GODOT On 10/27/2003 11:09:25 AM, [EMAIL PROTECTED] wrote: > I need to parallelize some sql operations and Im running them from > unix scripts. > > I want to spawn off a few in the background from a master script, > then > have the master script 'wait' for them to finish. Ive done this in > Java and with dbms_alert, but I cant dig up the syntax to do this > with > korn shell on solaris. > > Also, if I want to wait for a specific PID, how do I get the PID of > the thread I want to wait for? > > so I have > > nohup run_sql & > > wait(on previous nohup) > > then to use notify, I just use 'notify()' inside the script right? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > 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-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). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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-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).
wait/notify syntax for unix help please
I need to parallelize some sql operations and Im running them from unix scripts. I want to spawn off a few in the background from a master script, then have the master script 'wait' for them to finish. Ive done this in Java and with dbms_alert, but I cant dig up the syntax to do this with korn shell on solaris. Also, if I want to wait for a specific PID, how do I get the PID of the thread I want to wait for? so I have nohup run_sql & wait(on previous nohup) then to use notify, I just use 'notify()' inside the script right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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: How to call unix shell scripts from 'C'?
Hi Ryan, You could try the Unix shell compiler at http://www.datsi.fi.upm.es/~frosal/ which doesn't actually compile the shell script but generates C and then the standard C compiler does the rest. maybe write in shell with mv's and compile to C and see if it looks efficient? hope this helps kind regards Pete In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] writes >The unix and C forums are pretty inactive. Hope its ok to ask this here. > >Anyone know how to do this? > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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-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: How to call unix shell scripts from 'C'?
Ah, then what you really need to do this with is perl. Edit in place, make backup copies or not, all very simple. eg. change all instances of SQLServer to Oracle in the files in a directory perl -pi -e 's/SQLServer/Oracle/goi' * Jared "Ryan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/22/2003 08:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: OT: How to call unix shell scripts from 'C'? the basics are they i want 'C' so i can use a file pointer. I need to do some search and replace in a group of files. If I use straight scripting I have to redirect the output to a new file and do a 'mv' to rename it back. with the filepointer, I was hoping to be to use fopen in C to open the file and then manipulate it with search and replace. not sure its possible. I Think you run into the same 'random access' issues you do in java. im pretty weak in C programming. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 12:14 PM > If you want the "C" program and the spawned shell script to > "interact" and communicate back and forth with each other, > then you'd have to use the "pipe()" system call to set up a > two-way interprocess-communication pipe in the "C" program, > then call "fork()" to spawn a new identical process > (including the IPC pipes), then finally "exec()" in the > child process to bring the image of the desired shell > running it's shell script in. Of course, each port of "C" > has variations on those basic function call (i.e. "exec()" > can be "execv()", "execve()", "execle()", etc). > > If you're just going to have the "C" program spawn the shell > script that will operate independently of its parent, you > can just call the "system()" library call and be done with > it... > > Hope this helps... > > -Tim > > > > The unix and C forums are pretty inactive. Hope its ok to > > ask this here. > > Anyone know how to do this? > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net -- > > Author: <[EMAIL PROTECTED] > > 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-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.net > -- > Author: Tim Gorman > 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-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.net -- Author: Ryan 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-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: How to call unix shell scripts from 'C'?
the basics are they i want 'C' so i can use a file pointer. I need to do some search and replace in a group of files. If I use straight scripting I have to redirect the output to a new file and do a 'mv' to rename it back. with the filepointer, I was hoping to be to use fopen in C to open the file and then manipulate it with search and replace. not sure its possible. I Think you run into the same 'random access' issues you do in java. im pretty weak in C programming. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 12:14 PM > If you want the "C" program and the spawned shell script to > "interact" and communicate back and forth with each other, > then you'd have to use the "pipe()" system call to set up a > two-way interprocess-communication pipe in the "C" program, > then call "fork()" to spawn a new identical process > (including the IPC pipes), then finally "exec()" in the > child process to bring the image of the desired shell > running it's shell script in. Of course, each port of "C" > has variations on those basic function call (i.e. "exec()" > can be "execv()", "execve()", "execle()", etc). > > If you're just going to have the "C" program spawn the shell > script that will operate independently of its parent, you > can just call the "system()" library call and be done with > it... > > Hope this helps... > > -Tim > > > > The unix and C forums are pretty inactive. Hope its ok to > > ask this here. > > Anyone know how to do this? > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net -- > > Author: <[EMAIL PROTECTED] > > 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-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.net > -- > Author: Tim Gorman > 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-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.net -- Author: Ryan 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-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: How to call unix shell scripts from 'C'?
"Quintin, Richard" wrote: > > fork() and exec() are what you're looking for. I haven't done it in a > while, but you should be able to find plenty of info online. > > On Wed, 2003-10-22 at 11:44, [EMAIL PROTECTED] wrote: > > The unix and C forums are pretty inactive. Hope its ok to ask this here. > > > > Anyone know how to do this? > > > > -- Acutually, there is simpler than this. If the script echoes nothing, system() can be used. Otherwise, look for popen(). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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-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: How to call unix shell scripts from 'C'?
Title: RE: OT: How to call unix shell scripts from 'C'? If it is just a simple script call use system("/home/me/myscript"); Be careful, your env vars might not be what you expect them to be. -Original Message- From: Quintin, Richard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 22, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: How to call unix shell scripts from 'C'? fork() and exec() are what you're looking for. I haven't done it in a while, but you should be able to find plenty of info online. On Wed, 2003-10-22 at 11:44, [EMAIL PROTECTED] wrote: > The unix and C forums are pretty inactive. Hope its ok to ask this here. > > Anyone know how to do this? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems & Computing, DBMS Virginia Tech -- "If my hands are fully occupied in holding on to something, I can neither give nor receive." -- Dorothee Solle -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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-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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: How to call unix shell scripts from 'C'?
Unix shell scripts are interpreted by a program, typically either a command shell (C-shell, bash, sh, tcsh, etc.) or by a scripting language program (perl, python, ruby, etc.) For a shell script to be "executed" from a shell's command line, the shell script needs to have the execute bit set (see man page for chmod(1)) and the first line in the script will be in the form of: #!/bin/sh The important thing is the "#!" token which tells the shell which interpreter is appropriate for executing the script; in the example above, the intepreter is /bin/sh. So, in answer to your question, your C program should optionally check for the execute bit, fopen() the file and perform a fgets() to read a line, the C program should then parse the line to make sure that it conforms to the "#!" convention. If it finds a path to an interpreter, then your C program will probably need to fork() itself, and then use one of the exec() variants, passing it the file path to the interpreter as the name of the program to execute, and also handing it the path to the script as a "command-line" argument. Read the man pages for the particular interpreter to determine if there are any special switches that will have to be passed in order to introduce a script name for the interpreter to automatically run and exit instead of going into interactive mode. If any such switches are needed, you will have to pack it into the exec() call as well. -Original Message- Sent: Wednesday, October 22, 2003 11:45 AM To: Multiple recipients of list ORACLE-L The unix and C forums are pretty inactive. Hope its ok to ask this here. Anyone know how to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung 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-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 call unix shell scripts from 'C'?
One way to do it to use system(/fqp/your_shell_script); This can be hazardous from a security point of view depending on who you are running the c program as. Allan -Original Message- Sent: Wednesday, October 22, 2003 10:45 AM To: Multiple recipients of list ORACLE-L The unix and C forums are pretty inactive. Hope its ok to ask this here. Anyone know how to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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 email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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-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 call unix shell scripts from 'C'?
use the system command in C -Original Message- Sent: 22 October 2003 16:45 To: Multiple recipients of list ORACLE-L The unix and C forums are pretty inactive. Hope its ok to ask this here. Anyone know how to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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.net -- Author: John Dunn 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-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 call unix shell scripts from 'C'?
Ryan - Take a look at the system() statement. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 22, 2003 10:45 AM To: Multiple recipients of list ORACLE-L The unix and C forums are pretty inactive. Hope its ok to ask this here. Anyone know how to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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.net -- Author: DENNIS WILLIAMS 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-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: How to call unix shell scripts from 'C'?
fork() and exec() are what you're looking for. I haven't done it in a while, but you should be able to find plenty of info online. On Wed, 2003-10-22 at 11:44, [EMAIL PROTECTED] wrote: > The unix and C forums are pretty inactive. Hope its ok to ask this here. > > Anyone know how to do this? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems & Computing, DBMS Virginia Tech -- "If my hands are fully occupied in holding on to something, I can neither give nor receive." -- Dorothee Solle -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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-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 call unix shell scripts from 'C'?
I think you need the "system" command. The unix man page explains it. > -Original Message----- > > The unix and C forums are pretty inactive. Hope its ok to ask > this here. > > Anyone know how to do this? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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: How to call unix shell scripts from 'C'?
If you want the "C" program and the spawned shell script to "interact" and communicate back and forth with each other, then you'd have to use the "pipe()" system call to set up a two-way interprocess-communication pipe in the "C" program, then call "fork()" to spawn a new identical process (including the IPC pipes), then finally "exec()" in the child process to bring the image of the desired shell running it's shell script in. Of course, each port of "C" has variations on those basic function call (i.e. "exec()" can be "execv()", "execve()", "execle()", etc). If you're just going to have the "C" program spawn the shell script that will operate independently of its parent, you can just call the "system()" library call and be done with it... Hope this helps... -Tim > The unix and C forums are pretty inactive. Hope its ok to > ask this here. > Anyone know how to do this? > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net -- > Author: <[EMAIL PROTECTED] > 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-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.net -- Author: Tim Gorman 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-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).
OT: How to call unix shell scripts from 'C'?
The unix and C forums are pretty inactive. Hope its ok to ask this here. Anyone know how to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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-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).
does anyone know how to add terminal type in oracle unix?
does anyone know how to add terminal type in oracle unix? how do you use oraterm and otgen? thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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-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 add ' (comma) at the begining and end of each line? Either Unix or Windows
Use the 'search and replace' functionality of ultraedit with 'regular expressions' enabled. First select 'replace all' for replacing % with ' Then select 'replace all' for replacing $ with ' - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 19:50 Unix or Windows > Hi List > > I have 1000 lines in my data file. I want to add > '(comma) at the begining and end of each line. > > For example, > > abf > jd > djkhk > jd3 > > Shold be convrted to > > 'abf', > 'jd', > 'djkhk', > 'jd3', > > Any help will be really appreciated. > > Thanks > Sami > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Oracle DBA > 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-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.net -- Author: <[EMAIL PROTECTED] 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-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 add ' (comma) at the begining and end of each line? Either Unix or Windows
A windows solution for /f %d in (C:\yourfile.txt) do echo ,%d,>>C:\yourfilewithcomma.txt bob Hi List I have 1000 lines in my data file. I want to add '(comma) at the begining and end of each line. For example, abf jd djkhk jd3 Shold be convrted to 'abf', 'jd', 'djkhk', 'jd3', Any help will be really appreciated. Thanks Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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-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.net -- Author: Bob Metelsky 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-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 add ' (comma) at the begining and end of each line? Either Unix or Windows
perl -i.orig -p -e "s/^/'/ ; s/$/',/" filename The original version of the file will be retained as "filename.orig". -Original Message- Sent: Thursday, October 16, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Either Unix or Windows Hi List I have 1000 lines in my data file. I want to add '(comma) at the begining and end of each line. For example, abf jd djkhk jd3 Shold be convrted to 'abf', 'jd', 'djkhk', 'jd3', Any help will be really appreciated. Thanks Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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-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.net -- Author: Norris, Gregory T [ITS] 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-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 add ' (comma) at the begining and end of each line? Either Unix or Windows
$ cat data.txt abf jd djkhk jd3 $ awk "{print \"'\" \$0 \"',\";}" data.txt 'abf', 'jd', 'djkhk', 'jd3', $ OD> Hi List OD> I have 1000 lines in my data file. I want to add OD> '(comma) at the begining and end of each line. OD> For example, OD> abf OD> jd OD> djkhk OD> jd3 OD> Shold be convrted to OD> 'abf', OD> 'jd', OD> 'djkhk', OD> 'jd3', OD> Any help will be really appreciated. OD> Thanks OD> Sami OD> __ OD> Do you Yahoo!? OD> The New Yahoo! Shopping - with improved product search OD> http://shopping.yahoo.com OD> -- OD> Please see the official ORACLE-L FAQ: http://www.orafaq.net -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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-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).
How to add ' (comma) at the begining and end of each line? Either Unix or Windows
Hi List I have 1000 lines in my data file. I want to add '(comma) at the begining and end of each line. For example, abf jd djkhk jd3 Shold be convrted to 'abf', 'jd', 'djkhk', 'jd3', Any help will be really appreciated. Thanks Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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-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 copy recursive files in Windows? like unix cp -r
xcopy /e /h source destn - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 00:29 > Hi List: > > How to copy recursive files in Windows? like unix cp > -r > > Thanks in advance, > Sami > > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Oracle DBA > 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-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.net -- Author: <[EMAIL PROTECTED] 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-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 copy recursive files in Windows? like UNIX cp -r
For stubborn files, or if an error occurs during the copy, this uses the /c switch FOR /d %a in (G:\some\location\*) do xcopy *.* /s /c H:\someother\location This essentially forces the xcopy through the source directory, sometimes useful for copying off of cds where the data can be temporarily unavailable due to windows interaction with the hardware bob -Original Message- Sent: Wednesday, October 08, 2003 3:15 PM To: Multiple recipients of list ORACLE-L xcopy -Original Message- Sent: Wednesday, October 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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-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.net -- Author: Khedr, Waleed 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-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.net -- Author: Bob Metelsky 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-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 copy recursive files in Windows? like unix cp -r
use xcopy /S or /E C:\>help xcopy Copies files and directory trees. XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W] [/C] [/I] [/Q] [/F] [/L] [/H] [/R] [/T] [/U] [/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z] [/EXCLUDE:file1[+file2][+file3]...] source Specifies the file(s) to copy. destination Specifies the location and/or name of new files. /A Copies only files with the archive attribute set, doesn't change the attribute. /M Copies only files with the archive attribute set, turns off the archive attribute. /D:m-d-y Copies files changed on or after the specified date. If no date is given, copies only those files whose source time is newer than the destination time. /EXCLUDE:file1[+file2][+file3]... Specifies a list of files containing strings. When any of the strings match any part of the absolute path of the file to be copied, that file will be excluded from being copied. For example, specifying a string like \obj\ or .obj will exclude all files underneath the directory obj or all files with the .obj extension respectively. /P Prompts you before creating each destination file. /S Copies directories and subdirectories except empty ones. /E Copies directories and subdirectories, including empty ones. Same as /S /E. May be used to modify /T. /V Verifies each new file. /W Prompts you to press a key before copying. /C Continues copying even if errors occur. /I If destination does not exist and copying more than one file, assumes that destination must be a directory. /Q Does not display file names while copying. /F Displays full source and destination file names while copying. /L Displays files that would be copied. /H Copies hidden and system files also. /R Overwrites read-only files. /T Creates directory structure, but does not copy files. Does not include empty directories or subdirectories. /T /E includes empty directories and subdirectories. /U Copies only files that already exist in destination. /K Copies attributes. Normal Xcopy will reset read-only attributes. /N Copies using the generated short names. /O Copies file ownership and ACL information. /X Copies file audit settings (implies /O). /Y Suppresses prompting to confirm you want to overwrite an existing destination file. /-Y Causes prompting to confirm you want to overwrite an existing destination file. /Z Copies networked files in restartable mode. The switch /Y may be preset in the COPYCMD environment variable. This may be overridden with /-Y on the command line. At 12:59 PM 10/8/2003, you wrote: Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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-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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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-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 copy recursive files in Windows? like unix cp -r
xcopy -Original Message- Sent: Wednesday, October 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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-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.net -- Author: Khedr, Waleed 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-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 copy recursive files in Windows? like unix cp -r
xcopy /e Example: xcopy /e c:\temp e:\ -Original Message- Sent: Wednesday, October 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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-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.net -- Author: Rothouse, Michael 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-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 copy recursive files in Windows? like unix cp -r
Title: RE: How to copy recursive files in Windows? like unix cp -r xcopy /s -- copies recursively if sub-dir is not empty xcopy /e -- everything including empty. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Oracle DBA [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Subject: How to copy recursive files in Windows? like unix cp -r Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**5
How to copy recursive files in Windows? like unix cp -r
Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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-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: IGNORE: Unix Help
Title: Message Or was it that we just ignored your post? ;o) Dave -Original Message-From: Sujatha Madan [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 07, 2003 11:29 PMTo: Multiple recipients of list ORACLE-LSubject: IGNORE: Unix Help Sorry ... but I solved it. Cheers Sujatha -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sujatha MadanSent: Wednesday, 8 October 2003 1:24 PMTo: Multiple recipients of list ORACLE-LSubject: Unix Help Hi, Sorry for the slightly non-Oracle post. I am after a UNIX code snippet that will help me copy archive logs to another directory BUT not if they already exist. So if only 2 archive logs are generated between script runs only the two new ones should copy. I know I can do this using sysdate - "time interval" but I am trying to avoid that. Thanks in advance, Sujatha Madan.
RE: Unix Help
Title: Message DEST_DIR=your_desination_directory SOURCE_DIR=your_source_directory for file in `ls $SOURCE_DIR` do fn=basename $file if [ ! -f $DEST_DIR/$fn ] then cp $file $DEST_DIR/$fn fi done Hope it helps. Allan -Original Message-From: Sujatha Madan [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:24 PMTo: Multiple recipients of list ORACLE-LSubject: Unix Help Hi, Sorry for the slightly non-Oracle post. I am after a UNIX code snippet that will help me copy archive logs to another directory BUT not if they already exist. So if only 2 archive logs are generated between script runs only the two new ones should copy. I know I can do this using sysdate - "time interval" but I am trying to avoid that. Thanks in advance, Sujatha Madan. __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]
IGNORE: Unix Help
Title: Message Sorry ... but I solved it. Cheers Sujatha -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sujatha MadanSent: Wednesday, 8 October 2003 1:24 PMTo: Multiple recipients of list ORACLE-LSubject: Unix Help Hi, Sorry for the slightly non-Oracle post. I am after a UNIX code snippet that will help me copy archive logs to another directory BUT not if they already exist. So if only 2 archive logs are generated between script runs only the two new ones should copy. I know I can do this using sysdate - "time interval" but I am trying to avoid that. Thanks in advance, Sujatha Madan.