How to execute an Oracle Script

Hi

Yes, I am a newbie, and I can't find any answer in the Oracle documentation.

I have the following file and I want to execute it. How/where can I do it? I tried it with SQL*Plus Worksheet but I just get syntax errors.

The file is called 'CreateDB' and the content looks like this:

#
# Initialize OWENA-database
#

print "All tables of database $1 will be dropped. Do you want to continue (Y/N)?"
read answer

if [[ $answer == "Y" || $answer == "y" ]]; then   print "Please wait ..."
else
  return 1
fi

if PreCreate $@
then
  cd ../src

  database=${3:-""}
  if [[ $database == "" || $database == "dummy" ]]; then     CreateOWENA.nosid $1 $2
    ../install/PostCreate

    cd ../data
    LoadData.nosid $1 $2
  else
    CreateOWENA $1 $2 $3
    ../install/PostCreate

    cd ../data
    LoadData $1 $2 $3
  fi
fi

So, how do I execute it?? (We use Oracle 8.1)

Thanks,

Juerg Received on Mon Oct 07 2002 - 09:36:46 CDT