I'm run scripts as below in sqlplus with different schema user.
@$PATH/create_table.sql
@$PATH/alter_table.sql
@$PATH/constraint.sql
@$PATH/sequence.sql
but interesting connection to different schema user disconnected I'm when I'm using pause in execution
set pause on
set pause PLEASE...
I have different schema like user,hr,payroll in sh script. Right now I'm using connect user/user are hardcord in script. I'm looking how to use variable for each user in sh script instead of specifying indidual connection for each user when running scripts releated to each schema user.
Thanks...
I have scripts files in oracle/home/scripts how to set this directory path in sqlplus in order to get files and execute from this directory.
Thanks in advance
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.