RE: NT script question ???

. how to make bat file take parameters. I had a backup.bat, and like to pass in Oracle SID, so the script can backup any database. 2. in the bat file, how to dynamically append date/time into a directory name, like backup_06022001121314 Thank you! Andrea -- Please see the official ORACLE-L FAQ

NT script

Hi, Thank you all very much for answering my NT batch script question. Do you mind I ask another one? I pass in SID as a parameter, if they don't pass it in, I'd like to echo out an error message. So how to check whether the parameter is passed in or not? I never write bat file before

RE: NT script and NT Script resources

: Monday, 4 June 2001 2:35 Hi, Thank you all very much for answering my NT batch script question. Do you mind I ask another one? I pass in SID as a parameter, if they don't pass it in, I'd like to echo out an error message. So how to check whether the parameter is passed in or not? I never

NT script question ???

Hi, I have couple of questions about bat file in NT 4.0 for Oracle 8.1.5. 1. how to make bat file take parameters. I had a backup.bat, and like to pass in Oracle SID, so the script can backup any database. 2. in the bat file, how to dynamically append date/time into a directory name, like

one more question about NT bat script

Hi, one more question about bat script in NT 4.0: when I put del c:\test\*.* in the bat file, and run it, I got Are you sure (Y/N)?, how to surpress this question? Thank you. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail

NT - Re: one more question about NT bat script

Andrea Oracle wrote: Hi, one more question about bat script in NT 4.0: when I put del c:\test\*.* in the bat file, and run it, I got Are you sure (Y/N)?, how to surpress this question? Thank you. del /Y Paul C:\del /? Deletes one or more files. DEL [/P] [/F] [/S] [/Q

How to encrypt Password in Export script file ?

Hi Unix Gurus, My daily export file (daily_exp.sh) contains : exp userid='system/password' file=file_name.dmp grants=y rows=y constraints=y compress=y full=y inctype=complete log=file_name.log The system password is stated clearly in the export script file. Has anyone encrypt/decrypt

RE: Script examples for NT. (yuk!)

08:26:45 -0400 Subject: Script examples for NT. (yuk!) Quick question.. ALL of my experience has been on UNIX platforms... Recently, I have been asked to work on an Oracle DB that runs on NT.. My scripting capability in the NT world is weak at best. So I am trying to compare ksh type activities

Re: How to encrypt Password in Export script file ?

a) Changet the script to print system/password | exp full=y ... so no-one can see it with a 'ps' b) chmod 700 daily_exp.sh so no-one except the (presumably) oracle account can see the script hth connor --- CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] wrote: Hi Unix Gurus, My daily

Re: How to encrypt Password in Export script file ?

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

RE: How to encrypt Password in Export script file ?

create session and exp_full_database then change your shell script to read userid=/ and run the script from the exportacct account this way you don't need to hardcode a password ANYWHERE Rachel From: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple

RE: How to encrypt Password in Export script file ?

-Original Message- From: Fisher, Julie [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 6:16 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to encrypt Password in Export script file ? I also did this on all my databases - works very slick. Julie

Re: How to encrypt Password in Export script file ?

script file. Has anyone encrypt/decrypt the system password before passing it as a variable to the export script ? If yes, could I have a copy of your script ? Thanks. Regds, New Bee in Unix Create an externally identified Oracle account with the suitable privileges, and run your script from

Re: How to encrypt Password in Export script file ?

] Date: Thu, 31 May 2001 05:07:24 -0800 a) Changet the script to print system/password | exp full=y ... so no-one can see it with a 'ps' b) chmod 700 daily_exp.sh so no-one except the (presumably) oracle account can see the script hth connor --- CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED

RE: How to encrypt Password in Export script file ?

Hi Gurus, Thanks to those who replied. We feel that Unix account is easily hacked, so we will not implement the method that Rachel mentioned. We will probably encrypt the password in another file. Before exporting, we will decrypt the password before passing the password to the export script

Re: Script and control file

Hi, Within your *.sql script you can jump to the OS and give OS commands. e.g: host sqlldr. (start with host). I have used it with import and it works. Jack

Script examples for NT. (yuk!)

Quick question.. ALL of my experience has been on UNIX platforms... Recently, I have been asked to work on an Oracle DB that runs on NT.. My scripting capability in the NT world is weak at best. So I am trying to compare ksh type activities with the NT world. SO I was wondering if any of you

re: Script examples for NT. (yuk!)

PROTECTED] ] -Original Message- From: Andrew S. Baker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 8:46 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Yet another scripting question However, if the user double clicks the script again, it should not map a new

RE: Script examples for NT. (yuk!)

My suggestion would be to install cygwin (http://sources.redhat.com/cygwin/). -Original Message- From: GLoughmiller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 8:25 AM To: ORACLE-L Cc: GLoughmiller Subject: Script examples for NT. (yuk!) Quick question.. ALL

RE: Script examples for NT. (yuk!)

You can download CyGWin from Redhat for free that will give you a very nice cloned shell of linux environment, full compatable with Bash/Sh scripting. Wish i could find a ksh shell for it, but it has ALOT of the tools normally available with Unix. ps, kill, grep, tail, head, piping, shell

Script and control file

First of all, I'm a beginner to SQL/SQL Loader. Currently,I'm working with Oracle 8. I would like to know if it's possible invoke SQL Loader inside a script. Example: - inside the script I want to create a new table TABLE1 - copy some data inside TABLE1 using SQL loader - work on TABLE1 using

Re: Script and control file

see the host command in pl/sql [EMAIL PROTECTED] 05/29/01 11:15AM First of all, I'm a beginner to SQL/SQL Loader. Currently,I'm working with Oracle 8. I would like to know if it's possible invoke SQL Loader inside a script. Example: - inside the script I want to create a new table TABLE1

RE: Script and control file

Andrea, Is this UNIX or NT. In UNIX ( I don't know NT that well), the most simple method would be to use a shell script. The following is about as basic as it comes but would need to be embellished with environment settings and error checking etc.. eg. Start of Script

RE: Script and control file

- Sent: Tuesday, May 29, 2001 12:12 PM To: Multiple recipients of list ORACLE-L Andrea, Is this UNIX or NT. In UNIX ( I don't know NT that well), the most simple method would be to use a shell script. The following is about as basic as it comes but would need to be embellished with environment

RE: Script and control file

:Re: Script and control file see the host command in pl/sql [EMAIL PROTECTED] 05/29/01 11:15AM First of all, I'm a beginner to SQL/SQL Loader. Currently,I'm working with Oracle 8. I would like to know if it's possible invoke SQL Loader inside a script. Example: - inside the script I want

Re: Script and control file

know you know this: there is no host command in pl/sql. Assuming you meant sqlplus. :) Jared [EMAIL PROTECTED] 05/29/01 11:15AM First of all, I'm a beginner to SQL/SQL Loader. Currently,I'm working with Oracle 8. I would like to know if it's possible invoke SQL Loader inside a script

Re: Script to compare two schemas

On Thursday 24 May 2001 17:20, Helmut Daiminger wrote: Does anybody out there have a script to compare to database schemas and list the differences? I'm forwarding a post I made on this topic a few days ago. Jared -- Forwarded Message -- Date: Sun, 13 May 2001 21:44:53

Script to compare two schemas

Hi! Does anybody out there have a script to compare to database schemas and list the differences? I know this has been posted a few times, but I don't have the emails anymore and can't find anything in the archives... Sorry. This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official

Re: ....A drop schema script ??

On Friday 18 May 2001 18:01, Jacques Kilchoer wrote: I hope Mr. Still won't mind if I post another script in the same vein, that I used after hearing him recommend this approach. This one also drops public synonyms for objects in the schema being dropped. Please note

RE: ....A drop schema script ??

DUHHH ! I could write the algorithm to solve the logarithm .. IF I ONLY HAD A BRAIN .. Thank you to all of you, and special thanks for not bashing me Luis Octavio Luis DeUrioste wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script

Re: ....A drop schema script ??

Thank you Jared for the words of encouragement and specially for the SCRIPT Luis Octavio Jared Still wrote: Luis, Don't feel bad, this is a valid question. DROP USER CASCADE is not always the most efficient way to drop a user, especially a user with a large number of objects. I've had

RE: ....A drop schema script ??

Title: RE: A drop schema script ?? -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] I've found that when dropping a schema owner, it's much easier to drop their objects individually, then drop the user. I hope Mr. Still won't mind if I post another script

RE: Script to remove redundant rows in a table?

delete from table the duplicates. -Original Message- From: Haskins, Ed [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 04:10 To: Multiple recipients of list ORACLE-L Subject: Script to remove redundant rows in a table? A few months ago I remember seeing a script

Re: Export Split Script

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 5:27 PM there is a note out on Metalink on how to do this. You can also break the export into separate files in later versions of Oracle8i. or you can run the following script (modified

RE: Export Split Script

On Wed, 16 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon: -de nada -- just trying to beat my fan club (thanks Ruth and Bill :) ) to -the punch. Hi, I'm Bill and I'm a Goddess Groupie.;-) - -Now. in 8i (not sure which flavor) you can have export do the split as -part

RE: Script that will remove redundant rows from table

people post the answer to this yesterday??? On 16 May 2001, at 17:10, Haskins, Ed wrote: A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET

RE: Script that will remove redundant rows from table

ORACLE-L [EMAIL PROTECTED] Subject: Re: Script that will remove redundant rows from table Date: Wed, 16 May 2001 17:45:22 -0800 didn't 27 1/2 people post the answer to this yesterday??? On 16 May 2001, at 17:10, Haskins, Ed wrote: A few months ago I remember seeing a script that enabled

Re: Script that will remove redundant rows from table

How about we split the difference? | 1* select (25.25+27.5)/2 from dual |SQL / | |(25.25+27.5)/2 |-- |26.375 | (no this is not the mean) On 16 May 2001, at 19:36, Rachel Carmichael wrote: now now, don't exaggerate it was only 25 1/4 people ... didn't 27 1/2

RE: Script that will remove redundant rows from table

recipients of list ORACLE-L || Subject: Re: Script that will remove redundant rows from table || || || How about we split the difference? || || | 1* select (25.25+27.5)/2 from dual || |SQL / || | || |(25.25+27.5)/2 || |-- || |26.375 || | || || (no this is not the mean

Re: Script that will remove redundant rows from table

, 2001 1:32 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Script that will remove redundant rows from table || || || How about we split the difference? || || | 1* select (25.25+27.5)/2 from dual || |SQL / || | || |(25.25+27.5)/2 || |-- || |26.375

Re: Script that will remove redundant rows from table

Deal! :) From: Eric D. Pierce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Script that will remove redundant rows from table Date: Thu, 17 May 2001 09:31:33 -0800 How about we split the difference? | 1* select (25.25

RE: Script that will remove redundant rows from table

Mr. Rhet Device (rhet oracle device, that is) On 17 May 2001, at 8:21, Alan Aschenbrenner wrote: Who was the half person? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

....A drop schema script ??

All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1

Re: ....A drop schema script ??

How about: drop user username cascade; --- Luis DeUrioste [EMAIL PROTECTED] wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A begin:vcard n:de Urioste;Luis Octavio tel;fax

RE: ....A drop schema script ??

Login in as system: drop user user_name cascade; -Original Message- Sent: Thursday, May 17, 2001 12:26 PM To: Multiple recipients of list ORACLE-L All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly

RE: ....A drop schema script ??

] Sent: Thursday, May 17, 2001 4:48 PM How about: drop user username cascade; --- Luis DeUrioste [EMAIL PROTECTED] wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I

RE: Script that will remove redundant rows from table

GROAN From: Eric D. Pierce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Script that will remove redundant rows from table Date: Thu, 17 May 2001 10:50:39 -0800 Mr. Rhet Device (rhet oracle device, that is) On 17 May 2001

Re: ....A drop schema script ??

uhhh DUHHH ! I could write the algorithm to solve the logarithm .. IF I ONLY HAD A BRAIN .. Thank you to all of you, and special thanks for not bashing me Luis Octavio Luis DeUrioste wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would

Re: ....A drop schema script ??

thanks for not bashing me Luis Octavio Luis DeUrioste wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A Content-Type: text/x-vcard

Export Split Script

I tries using a compressed export and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L

Re: Export Split Script

On Wed, 16 May 2001,Smith, Ron L. scribbled on the wall in glitter crayon: -I tries using a compressed export and the output is still over 2G. Does -anyone have the export script that splits the export files into multiple -files? - -Ron Smith -Database Administration -[EMAIL PROTECTED] - Go

RE: Export Split Script

http://www.oracle.com/oramag/code/tip01168.html Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 2:57 PM To: Multiple recipients of list ORACLE-L Subject: Export Split Script I tries

Re: Export Split Script

http://www.oracle.com/oramag/code/tips1998/index.html 1/16/98 I tries using a compressed export and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see

Re: Export Split Script

anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Export Split Script

: Wednesday, May 16, 2001 3:57 PM To: Multiple recipients of list ORACLE-L Subject:Export Split Script I tries using a compressed export and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration

RE: Export Split Script

and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network

RE: Export Split Script

Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Rajaram [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: Export Split Script If you are using Oracle on Unix , You may want to use unix pipes ( mknod

RE: Export Split Script

there is a note out on Metalink on how to do this. You can also break the export into separate files in later versions of Oracle8i. or you can run the following script (modified to suit your system, it was last tested on Solaris/Oracle 7.3.4) #!/bin/sh # cd $EXPORT_DIR # # set maximum file

RE: Export Split Script

PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject:RE: Export Split Script Rajaram, Please give me details on how to use mknod to split export files larger than 2 GB. We have broken our jobs into over 50 separate export jobs on the table level just to keep our files less

Re: Export Split Script

:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: Export Split Script If you are using Oracle on Unix , You may want to use unix pipes ( mknod). - most people use this method to manage files 2GB. Rajaram (Now that I am

RE: Export Split Script

of list ORACLE-L Subject: RE: Export Split Script there is a note out on Metalink on how to do this. You can also break the export into separate files in later versions of Oracle8i. or you can run the following script (modified to suit your system, it was last tested on Solaris

Script that will remove redundant rows from table

Title: auditing tables A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region

Re: Script that will remove redundant rows from table

didn't 27 1/2 people post the answer to this yesterday??? On 16 May 2001, at 17:10, Haskins, Ed wrote: A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D

Script to remove redundant rows in a table?

A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region Database. I've loaded these connect

RE: Export Split Script

PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Export Split Script Date: Wed, 16 May 2001 14:05:29 -0800 Thanks, Rachel. You're a sweetheart. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo

Re: Script that will remove redundant rows from table

now now, don't exaggerate it was only 25 1/4 people From: Eric D. Pierce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Script that will remove redundant rows from table Date: Wed, 16 May 2001 17:45:22 -0800 didn't

Re: Export Split Script - reply from NT-Land

Rachel Carmichael wrote: de nada -- just trying to beat my fan club (thanks Ruth and Bill :) ) to the punch. Now. in 8i (not sure which flavor) you can have export do the split as part of the export. I don't think it compresses it but it will at least break the files down the

Script that will remove redundant rows from table

Title: auditing tables A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region

Script that will remove redundant rows from table

A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region Database. I've loaded these connect

RES: Script that will remove redundant rows from table

; -Mensagem original- De: Haskins, Ed [mailto:[EMAIL PROTECTED]] Enviada em: Tuesday, May 15, 2001 02:46 PM Para: Multiple recipients of list ORACLE-L Assunto: Script that will remove redundant rows from table A few months ago I remember seeing a script that enabled the removal

Re: Script that will remove redundant rows from table

: Script that will remove redundant rows from table Date: Tue, 15 May 2001 09:40:47 -0800 A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores

RE: Script that will remove redundant rows from table

Message- Sent: Tuesday, May 15, 2001 1:46 PM To: Multiple recipients of list ORACLE-L A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores

Re: DATABASE COMPARE SCRIPT

- From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Saturday, May 12, 2001 12:20 AM Subject: DATABASE COMPARE SCRIPT I am trying to find out the schema differences between two databases. Differences like Column size,column datatype,column data

Fwd: Re: DATABASE COMPARE SCRIPT

--Boundary-00=_TI6B0KP3KE5T3HEN611V Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit The database compare script didn't come out to well the first time, so I've just embedded them in this post. The scripts are: clears.sql columns.sql title.sql

DATABASE COMPARE SCRIPT

Title: RE: When to go for ORACLE NAMES Server I am trying to find out the schema differences between two databases. Differences like Column size,column datatype,column data length, indexes,tables,constraints etc. If anyone has a script or know where I can get one that will accomplish

Re: DATABASE COMPARE SCRIPT

--Boundary-00=_I6J7K4TVKE7DS65S6BN5 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Perhaps this will help. If the attachments don't go through, I will resend as part of the message. FYI I haven't used the schema_diff.sql script in awhile

RE: looking for export with dynamic compress script on VMS

Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 14:56 To: Multiple recipients of list ORACLE-L Subject: looking for export with dynamic compress script on VMS Hi VMS DBA gurus, As part of migration process from Oracle v7 to v8i, we are trying

RE: looking for export with dynamic compress script on VMS

are trying to do the complete export of our database. Due to the lack of disk space, we can not land such a big export file. Our v7 database is on VMS platform and I am looking for the VMS script, which does dynamic compression (like the way pipes work on Unix systems) while export is running. If any one

??? run unix script on NT

Hi, Does anybody know some tool/utility that can run Unix kshell script on NT? Thanks! Leslie __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http

Re: ??? run unix script on NT

Yes, UWIN from http://www.research.att.com/sw/tools/uwin/ works wonders. Original Message On 5/9/01, 3:03:22 PM, Leslie Lu [EMAIL PROTECTED] wrote regarding ??? run unix script on NT: Hi, Does anybody know some tool/utility that can run Unix kshell script on NT? Thanks! Leslie

RE: looking for export with dynamic compress script on VMS

platform and I am looking for the VMS script, which does dynamic compression (like the way pipes work on Unix systems) while export is running. If any one has such script and would like share it, please post it on the list. I really appreciate for your help. Thanks in advance, Best Regards, Prasad

never mind -- Re: ??? Again: run unix script on NT

--- Leslie Lu [EMAIL PROTECTED] wrote: Thank you for all those who answered my question. I just installed uwin. I'm running a script upgrade_db.ksh. In the script, there is someting like: function check_login { # Login

RE: never mind -- Re: ??? Again: run unix script on NT

Title: RE: never mind -- Re: ??? Again: run unix script on NT Look in ORACLE_HOME\bin for the correct name of the SQL*Plus executable. Be sure to use the line command version (the one WITHOUT a W at the end of the file name.) Depending on the version of Oracle, it could be SQLPLUS, or PLUS80

??? Again: run unix script on NT

Thank you for all those who answered my question. I just installed uwin. I'm running a script upgrade_db.ksh. In the script, there is someting like: function check_login { # Login to the database using the variables provided

RE: ??? Again: run unix script on NT

. I'm running a script upgrade_db.ksh. In the script, there is someting like: function check_login { # Login to the database using the variables provided BAD_LOGIN=`sqlplus -s

Re: script to run before startup

Use the database trigger after startup event of the database. -- On Sat, 28 Apr 2001 07:35:34 Bunyamin K.Karadeniz wrote: I want to run a script after the startup of database automatically. How can I do this on NT?? Bunyamin K.Karadeniz Database Group

script to run before startup

I want to run a script after the startup of database automatically. How can I do this on NT?? Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729

Off Topic: Unix shell script problem - Urgent advise needed

Hello all, Ihave the following script, called as tst. When the script is executed as, tst, then every thing is okay, but when it is executed as . tst, then I get the error:- sh: SHLIB_PATH: Parameter not set. I need to use the following format that is . .profile, as in above case as . tst

Re: Off Topic: Unix shell script problem - Urgent advise needed

Hi Viraj, It looks to me like your clearing the value of $SHLIB_PATH (unset SHLIB_PATH) then using $SHLIB_PATH to set the value of SHLIB_PATH. Since it is empty to begin with the value will be null. In a shell script if you run it from a user's current shell (in your case by executing tst

Re: Off Topic: Unix shell script problem - Urgent advise needed

Hello, Thanks for some lead. Sorry the script is executed like this:- . prgnrc.sh in the case of sh and bash. This line gets writen in the .profile, so when you login to the envt. then it reads the last line in .profile, which reads as:- . /home/supp/testinst/prgnrc.sh which contains

RE: Script for reversing a string? - FYI

FYI: Apparently the reverse function exists in SQL Plus but not in PL/SQL (I couldn't compile a function that referenced it). utl_raw.cast_to_varchar2(utl_raw.reverse(utl_raw.cast_to_raw('LOOK'))) worked perfectly though. -Original Message- Sent: Tuesday, March 13, 2001 3:46 AM To:

RE: crontab script problem

. Cheers Rajesh -Original Message- Sent: Monday, April 16, 2001 11:06 PM To: Multiple recipients of list ORACLE-L When running a script from cron we first execute a script that sets all the environment variables. Here's the code we use: #SET DATABASE ENVIRONMENT VARIABLES

Where do I find the patch script on the install CD ?

I just finished installing Oracle8.0.6 on a SUN SPARC ULTRA 5. The install cd is : Oracle8 Enterprise Edition Release 8.0.6.0.1 After the install I query v$version and I notice that I have version 8.0.6.0.0 Where do I find the patch on the CD (or the local Oracle Home Directory) to bring it from

RE: crontab script problem

When running a script from cron we first execute a script that sets all the environment variables. Here's the code we use: #SET DATABASE ENVIRONMENT VARIABLES FOR DATABASE nyccp. DSM 2/6/96 # PATH=/oracle/oper:/oracle/product/8.0.4/lib:.:/opt/SUNWspro/bin:/usr/bin/sbi n:/e tc:/usr/bin:/usr

Re: Where do I find the patch script on the install CD ?

I have never seen a patch set on the Installation CD. I've always had to download it from Metalink. HTH Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent:

RE: crontab script problem

Saturday, April 14, 2001 2:00 AM To: Multiple recipients of list ORACLE-L Subject: crontab script problem Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands

Re: crontab script problem

Rajesh, Instead of running the .profile for the oracle user, you might try invoking the oracle user. I don't think you're seeing the $ORACLE_HOME. Try something like: su - oracle "-c sqlplus -s"END system/manager END @/oracle/test2.sql Hope this helps.

crontab script problem

Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus, it gives following error: /oracle/test1.sh: -o: bad option(s)

Where do I find the patch script on the install CD ?

I just finished installing Oracle8.0.6 on a SUN SPARC ULTRA 5. The install cd is : Oracle8 Enterprise Edition Release 8.0.6.0.1 After the install I query v$version and I notice that I have version 8.0.6.0.0 Where do I find the patch on the CD (or the local Oracle Home Directory) to bring it

OT: shell script to compare nos.

Hello, I need some help in comparing 2 nos. in a unix shell. 1) e.g var1="7.04.03" and var2="7.05" I want to test:- if [ "$var2" "$var1" ];then then $var2 version is greater than $var1" fi 2) 2nd condition is :- var1="7.04.03" var2="7.04.02" I want to test:- if [ "$var1" "$var2"

<    4   5   6   7   8   9   10   >