Mufasa thanks a lot for your suggestion. I have tried to run the script using your example but it is giving me following errors.
P2-0042: unknown command "..." - rest of line ignored.
SQL> Accept foo PROMPT "Pausing...Press [Enter]-key to continue processing: "
Pausing...Press [Enter]-key to...
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...
Thanks Dave it works. Now second hurdle I have connecting different schema users like user, hr,payroll. How to connect different users using varible when running upgrade script on oracle instance in sh script instead of using connect user/user with every connection
Thanks in advance
Ron
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
Yes creating a test environment. I'm planning to move coldbackup files of oracle instance which is oracle9i to another aix box where 10 g installed. I need to know how to copy data files from one aix to another aix box.
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.