Search Results

Sorry RudiC. Its my bad that i dint give a description about the code. I will definitely do this next time.

This script accepts 3 arguments ie, DB name, parfile and EXP|IMP.
This script will be...

Hi,

I am trying to use variable output in awk to append a string to a word in a line. But that is not happening. Could you please help me on this.

YouTube Video Tutorial: How to Use Code Tags...

Thanks Chubler..Appreciate you help..that worked....

Thanks..That worked....But dont know..unix variable is not taking....

I am getting below error

SELECT 'ALTER DISKGROUP ' $DG ' DROP FILE '''||R.NAME||'''; '
*
ERROR...

#! /bin/ksh
#############################################
# Script to delete ODS archived logs from ASM
#############################################
export TIMESTAMP=`date "+%y%m%d_%H%M%S"`
set...

Thanks For the reply.

The below code is the complete script except the function. I already mentioned the function

# DATABASES NOT IN THE ABOVE LISTS ARE NOT IN ARCHIVELOG MODE...

Hi All,

Can you please let me know what I missed in the below function? Whenever I try to execute the script i am getting

syntax error at line 101 : `fi' unexpected

Function is

function...

Hi All,

I am just looking for CVS automation for SQL scripts. Normally Devs will check in new sql scripts or they will update the existing sql scripts with new query. We will take the scripts from...

Hi All,

I have a query with output below

select 'create synonym "'||TABLE_NAME||'" for '||Table_owner||'."'||table_name||'"'||chr(59) from user_synonyms;

==================

create synonym...

Hi All,

There is a code like below in my script

###############################################
###Create Directories and Sub-Directories
###############################################
...

Hi All,

I am doing an export and import (datapump) of 4 schema. I know we can do an export of 4 schema in one command. But just want to know how to check the exit status if i do the export/import...

Hi All,

I am writing script for Env refresh for Oracle DB. I am using Datapump for that. If i start expdp or impdp, how can i know that export or import has completed. I have query for that. How...

Yes I will do....I am writing the script for env refresh and doing the testing parallel....It will not go to PROD...but anyway i will do that once i am done with the clean up module... Thanks alot

You are correct....it was space issue... i put a tab and it got worked..thanks a lot
sqlplus -s $sch/$tpwd@$ttns <<EOF

I think EOF started at beginning of sql and end after doing the query. Please correct me if i am wrong.

Hi All,

Please let me know what i am missing in the following code (part of my script)

Schemas=(AWQM WFCONTROLLER PROVCO PRISM)

for s in "${Schemas[@]}"
do
sch="${s}_$tol"

...

Hi Scott,

Everyone know how to attach variable to array values..Only i dont know how to do that... :) Any way i have mentioned below

Schemas=(AWQM WFCONTROLLER PROVCO PRISM)

for s in...

Hi All,

Need a help. I am just learning Shell scripting. Need a requirement like to attach variable to array values. Value of from is AF and to is AD.



froml=$(echo $from | tr '[a-z]'...

Hi Scott,

Thanks Scott...It worked.... Also thanks for the suggestion...I will change my code....

Thanks,
Mani

---------- Post updated at 07:09 PM ---------- Previous update was at 07:05...

Ohhh I have not noticed that. But the directory created like this

DP_FROM_{AF}_TO_{AD}

Hi Scott,

I am in writing code of database refresh. So the code is incomplete and its in starting stage.

The code is

##############################################
read -p "Enter From...

Hi,

Thanks for the reply.

I tried that its giving error

./datapump.sh: line 57: =DP_FROM_{ad}_TO_{af}: command not found

Hi All,

I am new to Shell scripting. I have two arguments $from and $to. My requirement is

$dpdir= DB_FROM_$from_TO_$to
mkdir $dpdir

Please help me on this.

Thanks,
Mani