Search Results

I wanted to use the if statement.

Hi,
In my script it takes the input from the user. i.e. sys or system.
How can i make it case insensitive in my code.

if [ "$LEVEL" = "sys" ] || [ "$LEVEL" = "system" ]; then
echo...

In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all...

Now my script is:
#!/bin/sh
echo "Enter the EXPORT_LEVEL:(sys/system or user)"
read EXPORT_LEVEL
if [[ $EXPORT_LEVEL = "user" ]]; then
echo "u r in if part"
else
echo "u r in else...

#!/bin/sh

now it gives error:
./test2: [[: not found

if [[ -d $DUMP && -d $LOG && "$PARALLEL_EXPORT" = "n" ]]; then

Is the above if statement is correct?

Hi, I'm using the && operator in if statement:

if [ -d $DUMP && -d $LOG && "$PARALLEL_EXPORT" = "n" ]; then

exp $UID/$PWD@$ORACLE_SID FILE=./DUMP/$TODAY$CONCAT_STR$USERNAME.dmp STATISTICS=NONE...

I intend to do parallel export of my Oracle db (i.e all the schema in my db).

Currently I'm using the below exp command in my script:

exp $uid/$pwd@$ORACLE_SID FILE=./DUMP/$today$username.dmp...

Thanks..

What is code tag?

I could not access the url for code tag.

https://www.unix.com/how-post-unix-li...code-tags.html

It is blocked here.

#!bin/sh
if [ -z $ORACLE_HOME ] # True if the length of string is zero
then
echo "Enter the value of ORACLE_HOME"
read ORACLE_HOME
export $ORACLE_HOME
fi


here is my script but it...

I'm new into unix.

My question: is possible to write a shell script which will ask for the
ORACLE_HOME, ORACLE_SID, USERNAME, PASSWORD to connect to Oracle db.

In generally we have to set...

For eg: I have sample.txt file with 4 rows of record like:

user1|password1
user2|password2
user3|password3
user4|password4

The username and password is sepsrated by '|'

I want to get the...

the requirement is: It read the text file and take the first username and password, connect to db then do the export. And this process will continue for all the users in that text file....

all the objects of the schema.

hi, i'm new to shell scripting.

I have a text file(sample.txt). It contains the different username & password for different users of oracle db.
.txt content
user1|password1
user2|password2...