@echo off

rem configureTablespaceAndUser.bat - run sql to create tablesspace and configure user for Oracle
rem This script takes 6 arguments as follows:
rem argument no. 1:  password for SYS user, that you specified when you created the database,
rem argument no. 2:  db_instance_name
rem argument no. 3:  default_tablespace_name 
rem argument no. 4:  Datafile_name, for example, see2022.dbf
rem argument no. 5:  user_name
rem argument no. 6:  user_pwd

set checkArguments=true
if "%1"=="" set checkArguments=false
if "%2"=="" set checkArguments=false
if "%3"=="" set checkArguments=false
if "%4"=="" set checkArguments=false
if "%5"=="" set checkArguments=false
if "%6"=="" set checkArguments=false
if not "%7"=="" set checkArguments=false
if not "%checkArguments%" == "true" (
    goto :usage
)

sqlplus -L SYS/%1@%2 as sysdba @configureTablespaceAndUser.sql %3 %4 %5 %6 > configureTablespaceAndUser.log
goto end

:usage
@echo -------------------------------------------------
@echo Create Tablespace
@echo -------------------------------------------------
@echo usage: configureTablespaceAndUser requires exactly 6 arguments in the following sequence:
@echo arg #1:  password for SYS user, that you specified when you created the database
@echo arg #2:  db_instance_name
@echo arg #3:  default_tablespace_name 
@echo arg #4:  Datafile_name, for example, see2022.dbf
@echo arg #5:  user_name
@echo arg #6:  user_pwd
@echo For example: configureTablespaceAndUser.bat sys_pwd see2022 fiper_ts SEE.dbf user1 user_pwd
@echo -------------------------------------------------

:end


