Hello,
I need to create a batch file that drops the user from the database, recreate and import the database with an existing backup.
I have already created a routine that gives a drop in user and recreates with the permissions defined, this routine I saved in a file and to use this routine, I need to inform two parameters, the user name and if it is to drop or keep if this user exists, here is an example:
SQL> @CriaUsuario
Indique o nome do usußrio.: <Nome_do_usuario>
Dropar usußrio? (s/n).: <sim para dropar e não para manter>
I have already created a batch, which connects and calls the routine described above, but I can not pass the parameters to it. Follow batch:
@ECHO OFF
CLS
@ECHO OFF
CLS
SET usuario=<banco>
SET senha=<senha_do_banco>
SET sid=<sid>
SQLPLUS %usuario%/%senha%@%sid% @ImportaUsuario.sql "baseteste" "s"
But nothing happens, the system logs with the informed user, executes the file @ImportaUsuario, but does not inform the two parameters. Here is the result in cmd:
SQL*Plus: Release 11.2.0.1.0 Production on Ter Mar 13 17:47:55 2018
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Conectado a:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
Indique o nome do usußrio.:
Does anyone know the correct way to enter the parameters in this case?